• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 845
  • Last Modified:

SSRS Expressions

How do you calculate RunningValue with (ReportItems!Textbox56.value) type of values.

The calculations are in decimal values and (ReportItems!Textbox56.value) calculation is  = IIF((((Fields!UNITBIDAMOUNT.Value) <> 0 or (Fields!BILLINGQTY.Value))  <> 0) , (Fields!UNITBIDAMOUNT.Value) * ( Fields!BILLINGQTY.Value), 0)
0
December2000
Asked:
December2000
  • 3
  • 3
3 Solutions
 
wdosanjosCommented:
You should add it as a Calculated Field to your Dataset.
0
 
December2000Author Commented:
Wow Thanks @ wdosanjos!

I am sort of a newbie, Then I would use the RunningValue? I am trying to get the net value for the invoice but, I am getting the line value with the sum() expression.
0
 
wdosanjosCommented:
I'm not sure I understand your last question/statement, but you can use the Calculated Value as any other field defined in the Dataset.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
December2000Author Commented:
SSRS indicates that you can't use calculated fields for aggregates  (ReportItems!Textbox56.value) is a sum of one field added to another.
0
 
wdosanjosCommented:
You should use the calculated value added to your Dataset, something like =Sum(Fields!YourRunningValue.Value).
0
 
Jason Yousef, MSSr. BI  DeveloperCommented:
0
 
December2000Author Commented:
Thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now