Runtime Error after some pause

Hello,

My users often view some report for some minutes and after that want to return to parent report.
If they did it after small time (~less than minute), everything is OK. But if this pause is above 1 minute they receive "Runtime Error" message and can only to go to homepage.

I think that this is some session time or something like that.
Am I right? How can fix it?

Thank youAfter setting customError=off we receive "Back call without drillthrough report" error|||Did you find a fix for the problem? Can anyone help? I get the same problem.|||

Back call without drillthrough report

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Back call without drillthrough report

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[InvalidOperationException: Back call without drillthrough report]

Microsoft.Reporting.WebForms.ReportViewer.Toolbar_Back(Object sender, EventArgs e) +229

Microsoft.Reporting.WebForms.ToolbarControl.OnBack(Object sender, EventArgs e) +25

Microsoft.Reporting.WebForms.BackGroup.BackButton_Click(Object sender, EventArgs e) +40

Microsoft.Reporting.WebForms.ScriptSwitchImage.EnabledImage_Click(Object sender, ImageClickEventArgs e) +25

System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +105

System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +115

System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7

System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11

System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33

System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

|||

I am also receiving this error but there is no delay. As soon as the report is loaded, I click back to goto the previous report and I get this error.

It is interesting because charts are also not loading. I dont receive an error message but in the event log this is entered: "The stream cannot be found."

This only happens when I drill-through.

|||

I'm having this issue also. Did anyone ever find a solution? thanks

|||Hey guys I think that this issue has something to do with some other problems I have been having due to SP1. I notice that the back button wasn't the only thing messing up, and it was only doing it in the ReportViewer (not when I went to the report directly in VS)

check out this article
http://www.eggheadcafe.com/software/aspnet/29672997/back-call-without-drillth.aspx

-nonoandy|||

i am also facing this problem...

any solutions for this?

|||Just checking if anyone has any luck with this? I spend more time on these forums than i do developing SSRS. Come across issues on a seemingly endless basis.|||Did you check out this link
http://www.eggheadcafe.com/software/aspnet/29672997/back-call-without-drillth.aspx
?
I had two things that was giving me the same problem one was a Ajax update panel around it and the other was because of the bad release of VS2005 SP1. The "Microsoft.ReportViewer.* assemblies" where messing it up so I had to un-install them from my GAC and find the older "File version"
(To find out what file version of the assemblies you have right click and hit properties. Don't look at the Version tab in the windows explore.)

But you don't have to do that now Microsoft came out with new assemblies in and you can download them in a redistributable package.

Read this
http://support.microsoft.com/default.aspx/kb/933137
and download

Thanks!
Andysql

Runtime Error after some pause

Hello,

My users often view some report for some minutes and after that want to return to parent report.
If they did it after small time (~less than minute), everything is OK. But if this pause is above 1 minute they receive "Runtime Error" message and can only to go to homepage.

I think that this is some session time or something like that.
Am I right? How can fix it?

Thank youAfter setting customError=off we receive "Back call without drillthrough report" error|||Did you find a fix for the problem? Can anyone help? I get the same problem.|||

Back call without drillthrough report

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Back call without drillthrough report

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[InvalidOperationException: Back call without drillthrough report] Microsoft.Reporting.WebForms.ReportViewer.Toolbar_Back(Object sender, EventArgs e) +229 Microsoft.Reporting.WebForms.ToolbarControl.OnBack(Object sender, EventArgs e) +25 Microsoft.Reporting.WebForms.BackGroup.BackButton_Click(Object sender, EventArgs e) +40 Microsoft.Reporting.WebForms.ScriptSwitchImage.EnabledImage_Click(Object sender, ImageClickEventArgs e) +25 System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +105 System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +115 System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

|||

I am also receiving this error but there is no delay. As soon as the report is loaded, I click back to goto the previous report and I get this error.

It is interesting because charts are also not loading. I dont receive an error message but in the event log this is entered: "The stream cannot be found."

This only happens when I drill-through.

|||

I'm having this issue also. Did anyone ever find a solution? thanks

|||Hey guys I think that this issue has something to do with some other problems I have been having due to SP1. I notice that the back button wasn't the only thing messing up, and it was only doing it in the ReportViewer (not when I went to the report directly in VS)

check out this article
http://www.eggheadcafe.com/software/aspnet/29672997/back-call-without-drillth.aspx

-nonoandy|||

i am also facing this problem...

any solutions for this?

|||Just checking if anyone has any luck with this? I spend more time on these forums than i do developing SSRS. Come across issues on a seemingly endless basis.|||Did you check out this link
http://www.eggheadcafe.com/software/aspnet/29672997/back-call-without-drillth.aspx
?
I had two things that was giving me the same problem one was a Ajax update panel around it and the other was because of the bad release of VS2005 SP1. The "Microsoft.ReportViewer.* assemblies" where messing it up so I had to un-install them from my GAC and find the older "File version"
(To find out what file version of the assemblies you have right click and hit properties. Don't look at the Version tab in the windows explore.)

But you don't have to do that now Microsoft came out with new assemblies in and you can download them in a redistributable package.

Read this
http://support.microsoft.com/default.aspx/kb/933137
and download

Thanks!
Andy

Runtime design of report in crystal reports 8.0

Hello All,

I want to change design of report through VB, I mean to say how can I change any textbox location to other location within same report only?
My problem is that we have more than 50 reports & if any customer wants to change location of textbox to other location within same report then he not able to do that & for that small reason support engineer have to visit him for minor change in report.
So saving time as well as man power, can we provide such interface where user can do minor changes in report ?
Any ideas are appreciated...thanx......Which Framework are you programming.
If you work with .Net, it has a solution to control report objects.
But it needs user interface programming.|||See if you find solutiojn at support section of this site
www.BusinessObjects.com

RunningValue()

I have a report that I has a dataset that has a column that can have high and low values. If a row has a value that exceeds either of these values I would like to do a running value on these values. For example, 300 records , 10 high , 3 low.

I know I can do a SQL query that can grab that data and then do a countrows on that dataset but I thought there should be a way of doing a runningvalue for each value.

Anyone have an idea on what the syntax is to do this?

I have also tried using 2 functions in custom code that are doing a simple if else to return the += 1 count for high and low. The value is displayed in a column that I'm hiding but I'm not able to display that variable anywhere else. I tried =Code.DisplayHigh() and it always returns nothing but in my columns I'm getting the right values.

Dim HighCount
Dim LowCount

Public Function CheckHigh(x As Double) As Integer
If x > 120.5 Then
HighCount += 1
Return HighCount
Else
Return 0
End If
End Function

Public Function CheckLow(x As Double) As Integer
If x < 116.2 Then
LowCount += 1
Return LowCount
Else
Return 0
End If
End Function

Public Function DisplayHigh()
Return HighCount
End Function

use properties (set and get ) and set the value and access the value using those. I cant say whats not working, because dont know whats the class structure. But try that first, is to convert these to properties.

RunningValue help!!

the running value works on the preview of reporting services but when
i run the report on the server it displays zero all the time. plz tell
me how to solve it
thanx in advancei figured out the problem !!!

RunningValue crashes VS

I have a standard report with a bunch of fields and groups within a
table.
I've added a field for a running total:
Field is amount_rt
Definition is: =RunningValue(Fields!amount.Value,Sum,Nothing)
The second I try to preview the report or deploy it, VS crashes.
I figured it might be something with my data, so I changed
Fields!amount.Value to Fields!test.Value where test = 1
Same thing.
The error message gives me no detail whatsoever.
Has anyone seen this before?
ThanksDid you create this field by going to your dataset and adding a newfield, or
just by code in a textbox or table?
<bigbrorpi@.gmail.com> wrote in message
news:1156263917.161190.3160@.b28g2000cwb.googlegroups.com...
>I have a standard report with a bunch of fields and groups within a
> table.
> I've added a field for a running total:
> Field is amount_rt
> Definition is: =RunningValue(Fields!amount.Value,Sum,Nothing)
> The second I try to preview the report or deploy it, VS crashes.
> I figured it might be something with my data, so I changed
> Fields!amount.Value to Fields!test.Value where test = 1
> Same thing.
> The error message gives me no detail whatsoever.
> Has anyone seen this before?
> Thanks
>

RunningValue + Aggregate = ERROR?

I am trying to do alternative color row for my report,
1. On Table - it works
=iif(RowNumber(Nothing) Mod 2 , "#F9F9F9","#EBEBEB" )
2. On Matrix with Value - it works too
=iif(RunningValue(Fields!Name.Value, CountDistinct, Nothing) Mod 2,
"#EEEEEE", "#FFFFFF")
3. On Matrix with Aggregate function - it DOESN'T WORK
=iif(RunningValue(Fields!OrderAmount.Value, Sum, Nothing) Mod 2, "#EEEEEE",
"#FFFFFF")
=iif(RunningValue(Sum(Fields!OrderAmount.Value), CountDistinct, Nothing) Mod
2, "#EEEEEE", "#FFFFFF")
It said scope parameter is not for RunningValue?The "Nothing" scope is not supported in matrix cells - because otherwise it
is not clear if the RunningValue should run horizontally or vertically
through the matrix cells. The scope has to be a specific matrix row group or
column group.
In your case, it sounds like you want to achieve alternating colors for
matrix rows. Take a look at the following blog article:
http://blogs.msdn.com/chrishays/archive/2004/08/30/GreenBarMatrix.aspx
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Zean Smith" <nospam@.nospamaaamail.com> wrote in message
news:Wv2dnQkV7dBsD__eRVn-qw@.rogers.com...
>I am trying to do alternative color row for my report,
> 1. On Table - it works
> =iif(RowNumber(Nothing) Mod 2 , "#F9F9F9","#EBEBEB" )
> 2. On Matrix with Value - it works too
> =iif(RunningValue(Fields!Name.Value, CountDistinct, Nothing) Mod 2,
> "#EEEEEE", "#FFFFFF")
> 3. On Matrix with Aggregate function - it DOESN'T WORK
> =iif(RunningValue(Fields!OrderAmount.Value, Sum, Nothing) Mod 2,
> "#EEEEEE", "#FFFFFF")
> =iif(RunningValue(Sum(Fields!OrderAmount.Value), CountDistinct, Nothing)
> Mod 2, "#EEEEEE", "#FFFFFF")
> It said scope parameter is not for RunningValue?
>
>

Running Views on SP2 Slower than SP3

Hi has anybody experienced views running slower on SQL 8 SP2 is slower than
running it on SP3?
I have 1 log shipping report server on SP3 that runs those views with out
problems.
I have another server with Replication running SP2, I find that views runnin
g
on this server has more locks and runs a lot slower. Some reports can't even
finish.
Is there such a big difference in SP3 as it pertains to running Views?
oh btw hardware is the same on both servers.
any help would be greatly appreciated..
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200603/1I have no doubt that SP3 contains fixes for a number of specific query
optimization (and other performance) problems that still existed in SP2.
That really shouldn't come as a surprise. It isn't as simple as SP3 being
better at running "Views", but rather that some set of your Views likely
have a narrow set of circumstances that versions prior to SP3 didn't handle
well.
Is there a reason you don't upgrade the SP2 server to SP3 (or SP4!)? SP2 is
definitely out of date.
Hal Berenson, President
PredictableIT, LLC
http://www.predictableit.com
"sqlclubber via droptable.com" <u19392@.uwe> wrote in message
news:5d11c243b34e5@.uwe...
> Hi has anybody experienced views running slower on SQL 8 SP2 is slower
> than
> running it on SP3?
> I have 1 log shipping report server on SP3 that runs those views with out
> problems.
> I have another server with Replication running SP2, I find that views
> running
> on this server has more locks and runs a lot slower. Some reports can't
> even
> finish.
> Is there such a big difference in SP3 as it pertains to running Views?
> oh btw hardware is the same on both servers.
> any help would be greatly appreciated..
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200603/1

Running Views on SP2 Slower than SP3

Hi has anybody experienced views running slower on SQL 8 SP2 is slower than
running it on SP3?
I have 1 log shipping report server on SP3 that runs those views with out
problems.
I have another server with Replication running SP2, I find that views running
on this server has more locks and runs a lot slower. Some reports can't even
finish.
Is there such a big difference in SP3 as it pertains to running Views?
oh btw hardware is the same on both servers.
any help would be greatly appreciated..
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200603/1
I have no doubt that SP3 contains fixes for a number of specific query
optimization (and other performance) problems that still existed in SP2.
That really shouldn't come as a surprise. It isn't as simple as SP3 being
better at running "Views", but rather that some set of your Views likely
have a narrow set of circumstances that versions prior to SP3 didn't handle
well.
Is there a reason you don't upgrade the SP2 server to SP3 (or SP4!)? SP2 is
definitely out of date.
Hal Berenson, President
PredictableIT, LLC
http://www.predictableit.com
"sqlclubber via droptable.com" <u19392@.uwe> wrote in message
news:5d11c243b34e5@.uwe...
> Hi has anybody experienced views running slower on SQL 8 SP2 is slower
> than
> running it on SP3?
> I have 1 log shipping report server on SP3 that runs those views with out
> problems.
> I have another server with Replication running SP2, I find that views
> running
> on this server has more locks and runs a lot slower. Some reports can't
> even
> finish.
> Is there such a big difference in SP3 as it pertains to running Views?
> oh btw hardware is the same on both servers.
> any help would be greatly appreciated..
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...erver/200603/1

Running Views on SP2 Slower than SP3

Hi has anybody experienced views running slower on SQL 8 SP2 is slower than
running it on SP3?
I have 1 log shipping report server on SP3 that runs those views with out
problems.
I have another server with Replication running SP2, I find that views running
on this server has more locks and runs a lot slower. Some reports can't even
finish.
Is there such a big difference in SP3 as it pertains to running Views?
oh btw hardware is the same on both servers.
any help would be greatly appreciated..
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1I have no doubt that SP3 contains fixes for a number of specific query
optimization (and other performance) problems that still existed in SP2.
That really shouldn't come as a surprise. It isn't as simple as SP3 being
better at running "Views", but rather that some set of your Views likely
have a narrow set of circumstances that versions prior to SP3 didn't handle
well.
Is there a reason you don't upgrade the SP2 server to SP3 (or SP4!)? SP2 is
definitely out of date.
--
Hal Berenson, President
PredictableIT, LLC
http://www.predictableit.com
"sqlclubber via SQLMonster.com" <u19392@.uwe> wrote in message
news:5d11c243b34e5@.uwe...
> Hi has anybody experienced views running slower on SQL 8 SP2 is slower
> than
> running it on SP3?
> I have 1 log shipping report server on SP3 that runs those views with out
> problems.
> I have another server with Replication running SP2, I find that views
> running
> on this server has more locks and runs a lot slower. Some reports can't
> even
> finish.
> Is there such a big difference in SP3 as it pertains to running Views?
> oh btw hardware is the same on both servers.
> any help would be greatly appreciated..
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1sql

Running Value (Chart in a Table)

Hello

I have a report with a Table, in the table I have SubReport1, in Subreport1 I have a Table1, inside table1 I have another table2 and Subreport2.

Subreport2 has 4 different type of charts, depending on the passing parameters from the second subreport 1 of the 4 charts is displayed.

In one of the chart I'm using the Running Value function, works fine ONLY the first time the chart is displayed, after that the charts shows no values. I'm using a series group, which changes for every row, for what I understood the value should be reset everytime the series changes (100,101,102), but that is not the case.

Group level values are 1/10, 2/10, 3/10 etc up to 10/10.

Series level values 100,101,102 etc.

Thank you

Hi

I guess I was not clear,

seems like that the Series group ID never reset the running value even when the value changes from 100 to 101, when the chart is invoked by a subreport.

welcome any suggestion.

Running Value

Hi

In my report I have the total column,under the total i have two sub fields:no , Row%and i have another column Cumulative total sub fields are no,***%

For the Row % under total i write like this:

=Round((Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)/Sum(Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)*100,2)

For the *** % under cumulative total the expression is:

=RunningValue((Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)/Sum(Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)*100,sum,"AgeByGender")

But i am getting this error:

The Value expression for the textbox '*** %' contains an aggregate function (or RunningValue or RowNumber functions) in the argument to another aggregate function (or RunningValue). Aggregate functions cannot be nested inside other aggregate functions.

How to get the cm % for the Cumulative total

Please help me

Thanks in advance

You can not 'sum' inside of other aggregate, you need to remove the sum function

=RunningValue((Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)/Sum(Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)*100,sum,"AgeByGender")

Try without "Sum"

(Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value/Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)*100

Ham

|||

Hi,

I want the SUM inside the runningValue,It is necessary.

Thanks

Running Value

Hi

In my report I have the total column,under the total i have two sub fields:no , Row%and i have another column Cumulative total sub fields are no,***%

For the Row % under total i write like this:

=Round((Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)/Sum(Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)*100,2)

For the *** % under cumulative total the "AgeByGender")

But i am getting this error:

The Value

I solved the problem with the following expression.

For Cumulative %:The formula i used is:

Round(RunningValue((fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value),sum,"AgeByGender") /Sum((fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value), "AgeByGender") *100,2)

This expression solved the problem.

Thanks

Running Value

I currently have a report that salesmen gets a negitve or plus points on the sales that he/she makes. I need to keep a running total of these points. In addition I need this total to never to get over 10 points but if I need the points to minus from 10 if they get a negitive points on a sale.

Example:

Account 1: 4 points Running total: 4

Account 2: 4 points Running total: 8

Account 3: 4 points Running total: 10

Account 4: -2 points Running Total: 8

I have tried Iif statement but I don't know how to keep the value at 10. I also need to have the final value to show in a group footer.

Thanks for any help.

RunningValue(Fields!Cost.Value, Sum, Nothing)

check books on line for more info about RunningValue

sql

Running value

Hi

In my report I have the total column,under the total i have two sub fields:no , Row%and i have another column Cumulative total sub fields are no,***%

For the Row % under total i write like this:

=Round((Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)/Sum(Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)*100,2)

For the *** % under cumulative total the expression is:

=RunningValue((Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)/Sum(Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)*100,sum,"AgeByGender")

But i am getting this error:

The Value expression for the textbox '*** %' contains an aggregate function (or RunningValue or RowNumber functions) in the argument to another aggregate function (or RunningValue). Aggregate functions cannot be nested inside other aggregate functions.

How to get the cm % for the Cumulative total

Please help me

Thanks in advance

Mahima

You will need to remove the "SUM" inside the running value statement.

=RunningValue((Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)/(Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)*100,sum,"AgeByGender")

Ham

|||

Hi,

I need the cum%(Cumulative %) thatswhy i added SUM inside.Without using Sum inside Running value,How to get the Cumulative %,Any work around .

Thanks in advance

|||

Mahima,

I'm missing a piece of Info to help you. Where are you trying to place your cumulative total - Is this a group footer, table footer, or Matrix?

Thks

Ham

|||

Hi,

This Cumulative Total % is a column in a Table.

|||

Hi,

Any one there,Please help me on this issue.

Thanks

|||

Mahima,

I meant to answer but I'm in the middle of a SSRS production release with my client. I did want to say that you could use the ReportItem!Field.value to replace the SUM(Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value) - if you are not using the them in a report column the created a calculated field then use the calculated field in replace the SUM values.

|||

Hi,

Thanks for replying.Can you explain a bit clear.I tried in this way,We have a % column i.e textbox67,In Cum%,i used like that:(ReportItems!TextBox67.Value,Sum,"dataset1").But iam getting error.report items use only in header footer.

Where to calculate that value separately.

Thanks

|||

Okay,

My bad, I now remember why I asked if it was in the header. On the Dataset, on click, Add new calculated field, place your expression, then use in your runningvalue statement.

Ham

|||

Hi,

I did the same before.I created a calculated field and using those calculated field in the RunningValue,But the problem is When i click on View report button,It is displaying the following message,An internal error occured,See ebetlog for details.And closing the application(Visual Studio).Here what is the problem.

The exception is Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogexception occured in devenv.exe.

Thanks

|||

WOW,

It looks like a lot of things are not going right here. Is your data valid?

Ham

|||

Hi,

My data is valid.It is working fine before adding the Calculated field.Any other alternative.

Thanks

|||Please post your expression, I would like to try an verify it.|||

Hi,

In the Dataset named "DataSet1" fields are Male,Female,Unknown.

In the report,i have the following columns

Male Female Unknown Total Total% CumulativeTotal Cumulative%

Total=Fields!Male.Value+Fields!Female.Value+Fields!Unknown.value

Total%=Fields!Male.Value+Fields!Female.Value+Fields!Unknown.value/Sum(Fields!Male.Value+Fields!Female.Value+Fields!Unknown.value)

CumulativeTotal=RunningValue(Fields!Male.Value+Fields!Female.Value+Fields!Unknown.value,Sum,"Dataset1")

CumulativeTotal%=RunningValue(Fields!Male.Value+Fields!Female.Value+Fields!Unknown.value/Sum(Fields!Male.Value+Fields!Female.Value+Fields!Unknown.value),Sum,"DataSet1")

this Cumulativetotal% is giving error,So i created the 'calculated filed' named as "Percent" with the expression:Fields!Male.Value+Fields!Female.Value+Fields!Unknown.value/Sum(Fields!Male.Value+Fields!Female.Value+Fields!Unknown.value)

and try to use the Percent value like this:

RunningValue(Fields!Male.Value+Fields!Female.Value+Fields!Unknown.value/Fields!Percent.Value,Sum,"DataSet1"),This is closing the Visual Studio and giving the exception.

Thanks

|||

In your calculated field,

Only place this Fields!Male.Value+Fields!Female.Value+Fields!Unknown.value in calculated fields

in your expression use RunningValue(Fields!Male.Value+Fields!Female.Value+Fields!Unknown.value/Sum(mycalculatedfields),

I hope that this works for you.

Running Totals with Max/Min Values

I am creating a timesheet report that calculates a running total of hours for the week by day. However, I want to be able to create two running totals for the entered time for the week. One that will max at 40 hours (reg. hours) and the second will start after 40 hours (overtime).

Any ideas?

Thanks!Use two Running totals
Reset first when it reaches 40
and start other when it over 40sql

Running Totals in a Report Builder Column Chart

I've created a Report Builder Column chart with months as the x-axis
(category) and revenue as the y-axis (value). This correctly displays
the revenue for each month, but I'd like to display a running total of
the revenue for the year.

I'm currently displaying:
Jan $2
Feb $1
Mar $4

I want to display:
Jan $2
Feb $3
Mar $7

I know this is possibly using the RunningTotal formula in Reporting
Services, but I'd like to do this in Report Builder so the users can
change and create their own graphs with running totals. Is there a way to do this in Report Builder?

Thanks.

I have been able to get the running total in a TABLE by right clicking on a field, selecting formula, and inserting the following string:

=Format(RunningValue(Fields!Count.Value,Sum,Nothing),"")

The format statement allows formatting "C" (at the end would produce currency (Dollar sign, etc.), not sure what "" (I didn't want currency).

I would also like to know how to do this in a chart....

Running Totals at group level

Hi,

I have a report that groups data by day - I have created a running value to

show cumulative sales for Monday, Monday+Tuesday, Monday+Tuesday+Wednesday etc.

I have a group below this level that expands out the customer. I

wish to create a cumulative sales value for that customer for that day of the

week. i.e. Customer A Monday value, Customer A Monday+Tuesday

value.

When you use RunningValue with scope Nothing, ie.

RunningValue(Fields!nett_value.Value, Sum, Nothing), the value returned on

Tuesday is Total Monday value plus each customer Tuesday value cumulative

adding. If you use scope at customer group level it cumulatively

adds that day’s customer totals.

I need to recreate:
Daily

Cumulative

Monday

100 100

Customer A 50

50

Customer B 25

25

Customer C 25

25

Tuesday

100 200

Customer A 50

100

Customer B 25

50

Customer C 25

50

Any ideas?

Thanks

While I am having fun trying to work this out...

Any help would be great!!!

Thanks!

Running Totals - Extracting specific lines

Hello, I'm new to the forum, but I sure hope someone can help me! I have a report due by tomorrow at noon and I'm really stumped!

I have a group and a subgroup, and I want to do a running total on the subgroup, *BUT* I have to total the lines of the subgroup separately. Here is a sample of what my report looks like: My main group is the date, and the subgroup is the machine (folder, 3knife, cutter trimmer). For each date, the folder could be listed 100 times, so that's why its group as such.

11/06/2005
Folder 30,000
3Knife 5,000
Cutter 10,000
Trimmer 3,200

11/07/2005
Folder 42,000
3Knife 6,000
Cutter 18,000
Trimmer 5,000

11/08/2005
Folder 50,000
3Knife 5,000
Cutter 10,000
Trimmer 80,000

Now - how would I go about doing a running total ONLY for the Folder? I want to total up the 30,000, 42,000, and 50,000. Right now I am doing a running total and it will total up the Folder, 3Knife, Cutter, and Trimmer in for each date. But I want to extract only certain lines from each date (the main group.)

Am I making any sense with this? I've beat my head against the wall and come up with nothing. Please help!You have to do a conditional running total using a formula
{machinetype} = "Folder"|||That worked perfectly, THANK YOU!! :)

Running Totals

We are trying to create a report that shows a Week to Date, Month to Date, and Year to Date

Week to Date Month to Date Year to Date

Item Number

I've tried using an if statement (if date = current week, Qty, 0) and then sum the data but I get an error message that reportitems can only be summed in the page header and footer. I've also tried running totals, but it doesn't like the iif statement. Any ideas on how to do this?

Nancy

Nancy,

Here's an example of running values with a IIF statement. I believe you can accomplish what you're trying to do the same way.

RunningValue(IIf(Fields!elca_employer_number.Value<0,Fields!elca_employer_number.Value,nothing),count,nothing)

Ham

|||

I have the Week to Date and Year to Date working but the period (or month to date) is still causing problems.

The data comes in at the weekly level, so I was able to use:

=iif(Fields!WEEK.Value=Sum(Fields!CurrentWeek.Value, "Current"),Sum(Fields!Ordered.Value),0)

The Year to Date is was able to do a simply sum, but for the Period to Date totals I'm still stuck.

When I try:

=RunningValue(iif(Fields!Period.Value=Sum(Fields!CurrentPeriod.Value, "Current"),Sum(Fields!Ordered.Value),0),sum, Group3)

I get an error - The value expression for the textbox contains an agrregate funtion in the argument to another aggregate function.

I'm trying to evaulate if the Period in my main dataset is equal to the Period in the Current dataset. That part is easy. Then I need to sum that up and display the data on one line

WTD PTD YTD

Item 5 50 500

In Crystal Reports I would have created a field called Period_Ordered that evaluates the if Period=Current Period, then I would have summed the Period_Ordered field in my group footer. Visual Studio doesn't seem to allow this. Very frustrating.

|||

NCL,

Okay we have a partial answer,

On the this statement: RunningValue(iif(Fields!Period.Value=Sum(Fields!CurrentPeriod.Value, "Current"),Sum(Fields!Ordered.Value),0),sum, Group3) you have to remove the "SUM" values because you cannot aggregate inside of an aggregate function.

I do not think you need runningvalues because you are looking at your final totals. I believe this is all you need now. IIF(SUM(Fields!Period.Value,"Current")=Sum(Fields!CurrentPeriod.Value, "Current"),Sum(Fields!Ordered.Value),0)

Ham

|||

On the first one: the sum(fields!CurrentPeriod.Value,"Current") is coming from the dataset. The dataset only contains one line of data. It takes the current date and pulls back the valid Fiscal Week, Period and Year. Not sure why only the sum is available to add to my expression. Maybe that is a different issue.

I tried the second option but it's not calculating the data correctly. It's not summing all of the weeks in current period.

If Current dataset is pulling back today - 1/23/2007 Current Week =30 Current Period = 7

Report pulls:

Item Week Period Year Qty Current Week Current Peroid to date Year to Date

Details:

99999 1 1 2007 5 0 0 5

99999 6 2 2007 10 0 0 15

99999 29 7 2007 10 0 10 25

99999 30 7 2007 5 5 15 30

What I need the report to show in the item group footer is:

99999 5 15 30

Any ideas?

|||

N,

On your question for

What I need the report to show in the item group footer is:

99999 5 15 30

I going to go on the assume that you are return a field name period and a second field name currentPeriod

Fields!Item.value

Fields!CurrentWeek.value

Sum(IIF(Fields!Period.value = Fields!CurrentPeriod.value, Fields!Qty.value,0))

Sum(Fields!Qty.value)

I hope this helps.

Ham

sql