Chart based on a group footer formula, grouped by date

[brosenhamer]

I am attempting to create a subreport chart in version 10 developer, as described in the charting print time pdf posted on the business objects website.

After rolling up the data and passing the parameter to the subreport, I ran into a problem.

I cannot extract the "rolled up" data and associate it to a database field, like is done in the example. The formula I am attempting to chart is calculating a value, based on two running total fields for the grouping.

The group is defined by week, therefore, I cannot associate the value to a database value.

When I create the identical grouping in the subreport, trying to compare the group week values with the on change of values, I cannot reference the group name.

What can I do to chart these values? Is there another method that someone has gotten to work?

Appreciatively,
brosenhamer

 

[lbass]

Please share the contents of your formulas--the show value and on change of formulas as well as any nested formulas. Also please explain the group structure of your main and sub- reports.

-LB

 

[brosenhamer]

There exist two group total fields that are used for a calculation. Total Units and total shift person hours. These totals are placed in the group footer section.

WhilePrintingRecords;
Shared NumberVar averageProductivity := {#Total Units}/{#Total Shift Person Hours};

The formulas that are passed to the subreports are listed here:

Passes the productivity group value
stringvar strShowValue;
strShowValue := strShowValue +
totext({@AVERAGE PRODUCTIVITY}) + "^";

Passes the onChangeOf GroupName
whileprintingrecords;
stringvar strOnChangeOf;
strOnChangeOf := strOnChangeOf + GroupName ({PRODUCTIVITY.TIMESTAMP}, "weekly") + "^";

Each of these are placed in the a secondary group footer section that is supressed.

The main report has a timestamp in the details section that is used to group the details into weekly groups.

Hopefully this is enough to develop a prognosis.

Thanks

 

[lbass]

Instead of using the groupname, use:

whileprintingrecords;
stringvar strOnChangeOf;
strOnChangeOf := strOnChangeOf + totext(datepart("ww",{PRODUCTIVITY.TIMESTAMP}),"00")+ totext(year({PRODUCTIVITY.TIMESTAMP}),"0000") + "^";

Then in the subreport record selection area use:

totext(datepart("ww",{PRODUCTIVITY.TIMESTAMP}),"00")+ totext(year({PRODUCTIVITY.TIMESTAMP}),"0000") in split({?pm-@onchangeof},"^")

In the chart expert, you can use the timestamp directly as your on change of field and then go to order and set it for on change of week.

You should insert a group on week in the subreport, too. When you create the {@subShowValue} formula, change recordnumber to groupnumber, as in:

tonumber(split({?Pm-@show value},", ")[groupnumber])

-LB

 

[brosenhamer]

That worked perfectly. Thank you for your help.
brosenhamer