[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

SSRS Expressions

Posted on 2012-04-09
7
Medium Priority
?
811 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
7 Comments
 
LVL 23

Assisted Solution

by:wdosanjos
wdosanjos earned 1000 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
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 

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 1000 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 1000 total points
ID: 37825472
0
 

Author Closing Comment

by:December2000
ID: 37828344
Thank you!
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how the fundamental information of how to create a table.

656 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