asked on

creating chart in ssrs based on calculated cell values?

Can you create a chart based on calculated fields? I have some calculated fields showing total spend and net spend as a percent to sales by month that I want to represent graphically but can't figure out how to do it with calculated fields...

CHART.png

itcouple

Hi

Yes you can do that and one way of doing that is adding extra row in your table and placing the graph in there (you create connection between table and graph) so when you drag and drop any fields into 'drop data fields here ' on the graph you will be able to change it to expression (copy paste should work).

I hope that helps.

Regards
Emil

k1ng87

ASKER

I don't believe I understand that...also, grand total comes (spend) come from one data set as where sales and transbilling come from another...

also, my source data tables are setup where I pivoted the months into columns...dont know if that makes a difference

locations | year | cost | jan | feb | mar | etc....
--------------------------------------------------------

itcouple

Sorry I thought the table uses only one dataset. It is difficult to answer it without playi with it. Is there a way you could upload the rdl file? (remove anything you want I just want dataset fields and calculation on report)

Would you consider returning the data in a separate dataset and using it to create the chart?

Regards
Emil

k1ng87

ASKER

here is the rdl file......I'd be open to any new ideas as I've only started picking up SSRS a few weeks ago some I'm fairly new rookie at this....but it is kinda similar to crystal reports which i've used before
ScoreCard-Prototype.png

k1ng87

ASKER

i had to change the extension to .png to upload it but switch it back to .rdl and it should work.

ASKER CERTIFIED SOLUTION

itcouple

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

k1ng87

ASKER

don't believe this is possible the way i described in SSRS