I'm new to SSRS reporting, Crystal Reports veteran. We are using SSRS Report Builder 3.0 with Epicor 10. I need to declare a variable on my report. Here are the details:
Labor Burden Rate Budget to Actual Report
Data set is my Epicor BAQ and contains all the data I need
I need to name this value and use it in a formula across departments
When I add a Variable to the Report Properties - I get an Error attempting to run the report:
I have tried various versions of the formula and tried to declare or name the variable and I'm missing something obviously....
I get this error:
The Variable(vSalesYTD) expression for the report ‘body’ uses an aggregate expression without a scope. A scope is required for all aggregates used outside of a data region unless the report contains exactly one dataset.
In Crystal Reports - The naming of the variable was straight forward. In here - I'm lost. I've exhausted my search for help on the web and SSRS help that I have available.
Any help would be greatly appreciated.
Thank you so much!