Using Visual Studio 2005 to create Sales Chart and need to specify a "Goal"

Question

I'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?

Answer 1

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:

• Adding Indicator in SSRS 2005 report
• Creating an inline bar chart (databar) for SSRS 2005.

Answer 2

Thanks 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.

Answer 3

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.