Wednesday, July 18, 2012 5:43 PMI'm creating an SSRS report using visual studio which queries the Total Sales for 5 different products. That's working fine, however we have a dollar amount sales goal for each product that I want to reflect on the report. I can't find a way to specify what that goal is and show how close we are to achieving that goal. Any thoughts or suggestions?
Thursday, July 19, 2012 7:44 AM
Include the Dollar Amount Sales with the result in your dataset.
Add one more column in your tablix, where you would compare the Total Sales with the Dollar Amount Sales. To better illustrate you could add a DataBar or an Indicator. Because SSRS 2005 doesn't support them (they were introduced later) you shoul'd check these posts:
Thursday, July 19, 2012 4:29 PMThanks for the reply. Sorry, I see I didn't state this above, but the Dollar Amount Sales Goal is not actual data in the database. Its jsut a number we've come up with. So I can't query it and add it to the report. That's the challenge.
Friday, July 20, 2012 6:11 AM
Does it change for each Product or it is the same for all?
You can include it in your dataset, if it is same for all Products:
select *, 'something not in the database' from tbl
If it is different for each product: Create one table where you specify what is the Dollar Amount for each product. Join the table with the result.