Solved

SSRS 2008 How to replicate RunningTotal and evaluate options that are available in Crystal

Posted on 2013-06-06
9
517 Views
Last Modified: 2013-07-02
I have a crystal report that I am rebuilding inside of SSRS. In my crystal report I have a running total field that is the Sum of "detail.amount". I have a formula I use to evaluate and return the amount if {@StringType}= 'h'. "StringType" is a formula field that gives me left({Detail.joballoc},1)

Can someone tell me how I can accomplish the same thing inside of SSRS?

Any help is much appreciated.

Thanks!
0
Comment
Question by:J C
[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
  • 5
  • 3
9 Comments
 
LVL 8

Expert Comment

by:rpkhare
ID: 39226800
There are plenty of links if you search Google to get running total.

Check this link:

Running totals per page in SSRS to display cumulative totals.
0
 

Author Comment

by:J C
ID: 39227635
Did you read my entire question? I know there is a RunningValue operator but I need to place conditions on it. I explained my scenario. Any further assistance is appreciated.
0
 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 39228025
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:J C
ID: 39229574
This is what I have constructed based on what PatelAlpesh provided. When the report is run it displays "Error". Do you see anything wrong with this expression?

=RunningValue(IIF(LEFT(Fields!joballoc.Value,1) = "H", Fields!detail_amount.Value, 0),Sum,"DataSet1")
0
 
LVL 8

Expert Comment

by:rpkhare
ID: 39229874
@jleecole:

Sorry I missed your point in my previous answer.

What exactly is the error message?
0
 

Author Comment

by:J C
ID: 39229891
It only tells me #Error
0
 

Author Comment

by:J C
ID: 39229919
Warning      1      [rsAggregateOfMixedDataTypes] The Value expression for the textrun ‘Textbox109.Paragraphs[0].TextRuns[3]’ uses an aggregate function on data of varying data types.  Aggregate functions other than First, Last, Previous, Count, and CountDistinct can only aggregate data of a single data type.
0
 
LVL 8

Accepted Solution

by:
rpkhare earned 500 total points
ID: 39230180
Please try few things:

=RunningValue(IIF(LEFT(Fields!joballoc.Value,1) = "H", Fields!detail_amount.Value, Nothing),Sum,"DataSet1") 

Open in new window


or

=RunningValue(IIF(LEFT(Fields!joballoc.Value,1) = "H", CDbl(Fields!detail_amount.Value), CDbl(0)),Sum,"DataSet1") 

Open in new window


Try both these ways and let me know.
0
 

Author Comment

by:J C
ID: 39235760
rpkhare,

Can't thank you enough.

=RunningValue(IIF(LEFT(Fields!joballoc.Value,1) = "H", Fields!detail_amount.Value, Nothing),Sum,"DataSet1") worked!

Thanks
0

Featured Post

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

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

Suggested Solutions

A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

752 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