Solved

SSRS use a expression in calculation

Posted on 2014-08-01
3
414 Views
Last Modified: 2014-08-01
Hello Experts Exchange
I have a SSRS report that has a couple of calculated expressions, I want to take one of the expressions and use it in a new calculation.  Is there a way to may a expression a variable so I can use it in a calculation?

Regards

SQLSearcher
0
Comment
Question by:SQLSearcher
[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 Comments
 
LVL 12

Accepted Solution

by:
Harish Varghese earned 500 total points
ID: 40233667
Yes. You can give a name to your first expression filed and refer to that as ReportItems in another expression. But there are restrictions in doing this when you use aggregate functions.
For example, if you use below expression in a cell in Taxlix and the name of that cell (TextBox) is txtAmount:
=Fields!Qty.Value * Fields!UnitPrice.Value

Open in new window

You can use below expression referring to above formula as:
=ReportItems!txtAmount.Value/100

Open in new window

0
 
LVL 15

Expert Comment

by:Vikas Garg
ID: 40233669
Hi,

Yes you can copy the value of your expression to a parameter and then can use that parameter in other expression or calculation

SSRS
0
 

Author Closing Comment

by:SQLSearcher
ID: 40233779
Thank you for your help.
0

Featured Post

Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Ssrs date parameters 12 147
SSRS Expression IIF Statements 2 72
SQL 2012 R2 Express report problem 2 97
CRM 2016 Custom Reports using Visual Studio 2012 and FetchXml 2 39
Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

726 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