February 5, 2013 at 8:45 am
Is there a way to create variables in the 2005 version? There are two tabs on the Layout screen called Datasets and Variables but everything is grayed out on the Variables one. I have to do a variance calculation for just a portion of report differently than the rest of the report and if I could set my denominator to a variable I would be home free but I can't figure out how to do it. Is there a way?
February 5, 2013 at 10:57 am
When your in a report project on the menu bar under 'Report' there is the 'Report Parameters' you can create them there!
Then do the calculation in the data set and set the parameter to the result.
Regards
ld
Stoke-on-Trent
United Kingdom
If at first you don't succeed, go to the pub and drink away your current thought plan.
February 5, 2013 at 3:24 pm
That won't work because the main dataset that the report is based on is from the results of a stored procedure and I just need one value from that result set (one column of a specific row) to do % calculations for one section of the report. Maybe it would work and I'm just not thinking of something. Any suggestions or guidance in the right direction would be much appreciated.
February 7, 2013 at 8:15 am
Perhaps do the calculations before the data gets to the report (in the stored procedure).
Hope that this helps...thanks.
- Chris
February 8, 2013 at 7:23 am
in the data set you could also add a calculated field (Right click on the dataset). I'd go with what CGSJohnson said. Your performance will be better if you can have the calculation returned from the server.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply