Solved

SSRS Expressions

Posted on 2012-04-09
7
790 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

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:
Jason Yousef, MS earned 250 total points
ID: 37825472
0
 

Author Closing Comment

by:December2000
ID: 37828344
Thank you!
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
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

895 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

14 Experts available now in Live!

Get 1:1 Help Now