Solved

SSRS Expressions

Posted on 2012-04-09
7
789 Views
Last Modified: 2012-04-10
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
Comment
Question by:December2000
  • 3
  • 3
7 Comments
 
LVL 23

Assisted Solution

by:wdosanjos
wdosanjos earned 250 total points
ID: 37823326
You should add it as a Calculated Field to your Dataset.
0
 

Author Comment

by:December2000
ID: 37823495
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
 
LVL 23

Expert Comment

by:wdosanjos
ID: 37823503
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
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

Author Comment

by:December2000
ID: 37823848
SSRS indicates that you can't use calculated fields for aggregates  (ReportItems!Textbox56.value) is a sum of one field added to another.
0
 
LVL 23

Assisted Solution

by:wdosanjos
wdosanjos earned 250 total points
ID: 37824023
You should use the calculated value added to your Dataset, something like =Sum(Fields!YourRunningValue.Value).
0
 
LVL 21

Accepted Solution

by:
huslayer earned 250 total points
ID: 37825472
0
 

Author Closing Comment

by:December2000
ID: 37828344
Thank you!
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now