RunningValue funtion doesn't seem to work with a chart data region

I am trying to build a chart where on of the data values represents a running
total. I also created a table data region to show the tablular
representation of the chart data.
The running value function requires a scope parameter representing the
group. I specify the name of the category group for the scope.
When I run the report the tablular data shows a correct running total.
However, the chart doesn't. I don't get any errors but the chart running
total values display as if a simple grouping and sum were done on the values.
Is this a known bug or am I doing something wrong.AS i know the RunningValue & RowNumber don't work on chart only on table...
"john" wrote:
> I am trying to build a chart where on of the data values represents a running
> total. I also created a table data region to show the tablular
> representation of the chart data.
> The running value function requires a scope parameter representing the
> group. I specify the name of the category group for the scope.
> When I run the report the tablular data shows a correct running total.
> However, the chart doesn't. I don't get any errors but the chart running
> total values display as if a simple grouping and sum were done on the values.
> Is this a known bug or am I doing something wrong.

RunningValue ?

I am having problems with the following -

this represents the dataset Date Customer Voucher Number Document Amount Check Amount 7/15/2006 Company G 101 15.00 45.00 7/15/2006 Compnay G 101 25.00 45.00 7/15/2006 Compnay G 101 5.00 45.00 7/18/2006 Company A 102 35.00 35.00 7/25/2006 Company M 103 45.00 50.00 7/25/2006 Company M 103 15.00 50.00

This represents the final report this is what I am getting Date Customer Voucher Number Document Amount Check Amount Check Amount (Hidden) Group 1 Header = Voucher Number (Hidden) Detail 7/15/2006 Company G 101 15.00 45.00 45.00 (Hidden) Detail 7/15/2006 Company G 101 25.00 45.00 45.00 (Hidden) Detail 7/15/2006 Company G 101 5.00 45.00 45.00 Group 1Footer 7/16/2006 Company G 45.00 45.00 135.00 (Hidden) Group1Header = Voucher Number (Hidden) Detail 7/18/2006 Company A 102 35.00 35.00 35.00 Group 1 Footer 7/19/2006 Company A 35.00 35.00 35.00 (Hidden) Group 1 Header = Voucher Number (Hidden) Detail 7/25/2006 Company M 103 45.00 50.00 50.00 (Hidden) Detail 7/25/2006 Company M 103 15.00 50.00 50.00 Group 1 Footer 7/25/2006 Company M 103 60.00 50.00 100.00 Report Footer Grand Total: 140.00 130.00 270.00

(I am using a table)

I can get the correct total for the Group 1 Footer Check Amount by dividing the Total by a count of the Voucher Numbers, but I have not been able to add the Group 1 totals of the Check Amount for the Grand Total in the footer. I have made various attempts using RunningValue with the Group 1 Check Amount Total field, but always getting a error - mostly that the scope was not correct.

Any suggestions will be appreciated.

Ok, so I solved my own problem. Maybe this will help you. I summed the Group 1 Footer cells with the correct Check Amount totals (45, 35,50) in a textbox in the Report Footer =Sum(ReportItems!CHEKTOTL_1.value). Voila! I was trying to make this way too complicated!|||

I am having the exact same problem and have tried about four different approaches without success.

Where are my CRW running totals?!

I my case it is cash receipts and applications (whereas your case appears to be payables).

How did you get your group 1 footer to get just the check amount. I have tried summing a iif(...) where only the first row of a check shows the value - and this did not work (cannot sum a calculation!). You indicate that you divided the total by the number of rows - would you mind showing the expression.

How then did you get this expression in the group 1 footer to be summed - I have all but givin up on runningvalue due to scope issues - this also killed my attempt at VBA code.

Thanks

Philip Neufeld

|||

Here is my solution. I hope my explanation makes sense.

I did some aggregating in the the SQL statement - summing the DocAmount and grouping by Voucher Number, Voucher Date, Check Total and Vendor.

My report is for multiple companies, so in the design portion I used a list data region sorted by company. Then I added a table, grouped by Company.

I put the Date, Voucher Number, Vendor, Voucher Amount and Check Amount in the detail rows of the table and summed the Voucher Amount and Check Total in the Table Summary row.

On the General tab of the table properties, I checked Insert a page break after this table and Fit table on one page if possible. When the report is exported to Excel, each company appears on a separate worksheet and the summaries also appear. That was another problem I was having with another solution I had devised - the totals appeared on my screen in the Reporting Manager, but apparently the formulas that I used to get the totals weren't exporting into Excel.

Hope this helps!

sjm

sql

RunningValue ?

I am having problems with the following -

this represents the dataset

Date

Customer

Voucher Number

Document Amount

Check Amount

7/15/2006

Company G

101

15.00

45.00

7/15/2006

Compnay G

101

25.00

45.00

7/15/2006

Compnay G

101

5.00

45.00

7/18/2006

Company A

102

35.00

35.00

7/25/2006

Company M

103

45.00

50.00

7/25/2006

Company M

103

15.00

50.00

This represents the final report

this is what I am getting

Date

Customer

Voucher Number

Document Amount

Check Amount

Check Amount

(Hidden)

Group 1 Header = Voucher Number

(Hidden)

Detail

7/15/2006

Company G

101

15.00

45.00

45.00

(Hidden)

Detail

7/15/2006

Company G

101

25.00

45.00

45.00

(Hidden)

Detail

7/15/2006

Company G

101

5.00

45.00

45.00

Group 1Footer

7/16/2006

Company G

45.00

45.00

135.00

(Hidden)

Group1Header = Voucher Number

(Hidden)

Detail

7/18/2006

Company A

102

35.00

35.00

35.00

Group 1 Footer

7/19/2006

Company A

35.00

35.00

35.00

(Hidden)

Group 1 Header = Voucher Number

(Hidden)

Detail

7/25/2006

Company M

103

45.00

50.00

50.00

(Hidden)

Detail

7/25/2006

Company M

103

15.00

50.00

50.00

Group 1 Footer

7/25/2006

Company M

103

60.00

50.00

100.00

Report Footer

Grand Total:

140.00

130.00

270.00

(I am using a table)

I can get the correct total for the Group 1 Footer Check Amount by dividing the Total by a count of the Voucher Numbers, but I have not been able to add the Group 1 totals of the Check Amount for the Grand Total in the footer. I have made various attempts using RunningValue with the Group 1 Check Amount Total field, but always getting a error - mostly that the scope was not correct.

Any suggestions will be appreciated.

Ok, so I solved my own problem. Maybe this will help you. I summed the Group 1 Footer cells with the correct Check Amount totals (45, 35,50) in a textbox in the Report Footer =Sum(ReportItems!CHEKTOTL_1.value). Voila! I was trying to make this way too complicated!|||

I am having the exact same problem and have tried about four different approaches without success.

Where are my CRW running totals?!

I my case it is cash receipts and applications (whereas your case appears to be payables).

How did you get your group 1 footer to get just the check amount. I have tried summing a iif(...) where only the first row of a check shows the value - and this did not work (cannot sum a calculation!). You indicate that you divided the total by the number of rows - would you mind showing the expression.

How then did you get this expression in the group 1 footer to be summed - I have all but givin up on runningvalue due to scope issues - this also killed my attempt at VBA code.

Thanks

Philip Neufeld

|||

Here is my solution. I hope my explanation makes sense.

I did some aggregating in the the SQL statement - summing the DocAmount and grouping by Voucher Number, Voucher Date, Check Total and Vendor.

My report is for multiple companies, so in the design portion I used a list data region sorted by company. Then I added a table, grouped by Company.

I put the Date, Voucher Number, Vendor, Voucher Amount and Check Amount in the detail rows of the table and summed the Voucher Amount and Check Total in the Table Summary row.

On the General tab of the table properties, I checked Insert a page break after this table and Fit table on one page if possible. When the report is exported to Excel, each company appears on a separate worksheet and the summaries also appear. That was another problem I was having with another solution I had devised - the totals appeared on my screen in the Reporting Manager, but apparently the formulas that I used to get the totals weren't exporting into Excel.

Hope this helps!

sjm

Running totals in matrix?

Is it possible to create a row in a matrix that represents the running total
over time? Can I do this in the matrix itself or does this need to be
calculated in the dataset? If it's the latter, any ideas for how to do this
simply?
Example:
Jan Feb Mar
Monthly Sales 150 59 124
Cumulative Sales 150 209 333
Thanks!there is a running value in the aggregation expression...
On Jan 5, 1:36=A0am, jmann <jm...@.discussions.microsoft.com> wrote:
> Is it possible to create a row in a matrix that represents the running tot=al
> over time? =A0Can I do this in the matrix itself or does this need to be
> calculated in the dataset? =A0If it's the latter, any ideas for how to do =this
> simply?
> Example:
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Jan =A0= =A0 =A0 Feb =A0 =A0 =A0 Mar
> Monthly Sales =A0 =A0 =A0 =A0 =A0 150 =A0 =A0 =A0 =A059 =A0 =A0 =A0 =A0 ==A0124
> Cumulative Sales =A0 =A0 =A0150 =A0 =A0 =A0 =A0209 =A0 =A0 =A0 =A0333
> Thanks!|||On Jan 5, 4:53 am, Sridar K <srid...@.gmail.com> wrote:
> there is a running value in the aggregation expression...
> On Jan 5, 1:36 am, jmann <jm...@.discussions.microsoft.com> wrote:
> > Is it possible to create a row in a matrix that represents the running total
> > over time? Can I do this in the matrix itself or does this need to be
> > calculated in the dataset? If it's the latter, any ideas for how to do this
> > simply?
> > Example:
> > Jan Feb Mar
> > Monthly Sales 150 59 124
> > Cumulative Sales 150 209 333
> > Thanks!
The Running Total/Value expression is explained here:
http://msdn2.microsoft.com/en-us/library/aa255824.aspx
Just as an FYI, you would normally use a cursor or while loop to
provide this type of functionality in the stored procedure/query that
is sourcing the report. Of course, this option adds complexity and
poor performance, so I would suggest using the Running Value
expression. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||I'm trying the RunningTotal expression (Fields!Sales.Value, Sum, Nothing) and
getting the following error:
"The value expression for the textbox â'textbox6â' has a scope parameter that
is not valid for RunningValue, RowNumber or Previous. The scope parameter
must be set to a string constant that is equal to the name of a containing
group within the matrix â'matrix1â'." Not sure what this means. Any ideas?
Thanks!
"EMartinez" wrote:
> On Jan 5, 4:53 am, Sridar K <srid...@.gmail.com> wrote:
> > there is a running value in the aggregation expression...
> >
> > On Jan 5, 1:36 am, jmann <jm...@.discussions.microsoft.com> wrote:
> >
> > > Is it possible to create a row in a matrix that represents the running total
> > > over time? Can I do this in the matrix itself or does this need to be
> > > calculated in the dataset? If it's the latter, any ideas for how to do this
> > > simply?
> >
> > > Example:
> >
> > > Jan Feb Mar
> > > Monthly Sales 150 59 124
> > > Cumulative Sales 150 209 333
> >
> > > Thanks!
>
> The Running Total/Value expression is explained here:
> http://msdn2.microsoft.com/en-us/library/aa255824.aspx
> Just as an FYI, you would normally use a cursor or while loop to
> provide this type of functionality in the stored procedure/query that
> is sourcing the report. Of course, this option adds complexity and
> poor performance, so I would suggest using the Running Value
> expression. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>