Expression

Hi,

In RunningValue expression, can we able to put the DataSet name.

Thanks

Mahima,

The runningvalue function goes as follow: RunningValue(Expression, Function, Scope).

The Scope can be the name of a dataset, grouping, or data region that contains the report items to which to apply the aggregate function. If a dataset is specified, the running value is not reset throughout the entire dataset.

I hope this helps.

|||

Hi,

Hammer, Can you look at the following problem.In this case what i have to use in the Runningvalue.

Hi,

In my report, i have 3 tables joined together.My requirement is the fllowing table

Age male Female Total Cumulativetotal

1 40 10 50 50

2 20 5 25 75

.. ..

total children 60 15 75 75

20 5 20 25 100

30 10 10 20 120

Total adults 15 30 45 45

Unknown age 5 5 10 130

Total 80 50 130 130

Upto Total children i created on table, and for total Adults i created another table, For Unknown Age and Total iam using one table,I got a problem in calculating Cumulative Total.

For Child ages Cumulative Formual is:RunningValue(Fileds!Male.Value+Fields!Female.value,Sum,"DataSet1")

For Age 20,30.. The Formula is:RunningValue(Fields!Male.Value+Fields!Female.Value,Sum,"Dataset1")

Now iam getting is

Age male Female Total Cumulativetotal

1 40 10 50 50

2 20 5 25 75

.. ..

total children 60 15 75 75

20 5 20 25 25 -- This value need to be:100

30 10 10 20 45 This value need to be:120

Total adults 15 30 45 45

Unknown age 5 5 10 130

Total 80 50 130 130

Here,My problem is For Adults 20,30.. cumulative totals are displaying their cumulative totals ,These are not with respect to entire table Cumulative Totals.

How to get the result as shown in the first table.

Thanks in advance.

|||

Mahima,

You appear to be using the correct function syntax, however it appears that your running value is being reset in your next set on results.

total children 60 15 75 75

20 5 20 25 25 -- This value need to be:100

30 10 10 20 45 This value need to be:120

Total adults 15 30 45 45

Thus you are getting the restarted count of Males and Females adults, with child male and female excluded. I would suggest placing (Fields!Male.Value+Fields!Female.Value, Sum, Nothing) so then you are limiting the scope of your count.

Ham

|||

Hi,

With Nothing, Still iam getting the same result.The adults are in another table,Whether it is the reason for Running Value count restart.

Please help me.

Thanks in advance

|||

Mahima,

Are the child male/female records in the same dataset as Adults male/female records?

Ham

|||

Hi,

yeah, The Child male/Female are from the same DataSet as Adult male/female records.

|||

Mahima,

I do not believe that "RunningValue" is design to keep a running count across data regions(Tables). I did test and my count restarted each time on different tables no matter what scope I placed.

My only other suggestion, Combine your 3 tables to a single table and use the "grouping" to show your subtotals of Childrens, Adults, and "unknowns"

Ham

|||

Hi,

I forgot to mention one thing, All the 3 tables have the filters applied on it, whether this is the reason for Running Value count to reset,I don't think so, because we are using "Dataset" name in the running value.

thanks

|||

Hammer,

Can you please tell me how to group to show sub totals of children,Adults,Unknowns.

To know the Children,Adults,Unknown I have only AgeUnitID 1->Age 1,2-> Age 2...16->Unknown

How to use this AgeUnitID in grouping.

Thanks

|||

Hammer,

Thank you very much

I created a single table and applied grouping on it.

Thanks

|||

Mahima,

On your table, select a row, right click, select "Insert Group", In the "Group On:" expression select the dataset field "AgeUnitID"

In the Group Footer, Add, you Summary Fields, and then add your running value statement.

Ham

|||

Mahima,

Can you mark this as answer? this way other will see our solution.

Ham

|||

Hi,

Hammer

I got the Cumulative %.

|||

Hi Mahima,

That's very good to hear, I'm glad it worked out for you.

Ham