Creating Variables in Reporting Services

  • 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?

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

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

  • Perhaps do the calculations before the data gets to the report (in the stored procedure).

    Hope that this helps...thanks.

    - Chris

  • 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