troubleshooting Question

SSRS Declare a Variable

Avatar of Erin Leale
Erin LealeFlag for United States of America asked on
SSRSMicrosoft Server OSMicrosoft SQL Server
5 Comments2 Solutions7 ViewsLast Modified:
Good day!  

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
 =abs(sum(Fields!Calculated_Sales.Value))  
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!
EL

ASKER CERTIFIED SOLUTION
Bembi
CEO

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros