problem with Crosstab in Dummy Group header

[sangisiva]

Hi All,

I am having a problem in crosstab manipulation.I am using Crystal report 10 and oracle 9i.

I am currently working in a report which has one subreport with it.Subreport is placed in group footer... Below goes the structure of the report

Report Header
Page Header
Dummy Group heder - Crosstab
Group Header
Details - Main report's fields
Group Footer #1a - Subreport
Group Footer #1b - placed summary fields of main report and subreport
page Footer
Report Footer


I group the reports based on the country. And Cross tab has 2 summary fields. I have to display the main report summary and subreport summary based on the grouping in corsstab.I can get the subreport summary value group wise using shared variable. But the Problem is I am not able to bring this to crosstab which is in group header. I know it is because crosstab gets evaluated before subreport evaluates.

I tried in the other way too by putting the subreport in the dummy groups group header#1a and placed the crosstab in group header #1b. But the problem here is I am not getting the values as per grops. I am getting the last value (I mean last groups value). I know it is becase this section executes only once (not for each group)


I tried using dynamic array variables to get the summary field for each group. and tried with evaluateafter funtion to get it in Group header. But don not why this is also not working properly. In this case also , I get the summary array values properly in group footer...

Please esperts help me if there is any workaround for this issue...

Thanks in Advance

 

[lbass]

You have not responded to my question. I do not think that you can use the necessary shared variables in a crosstab, especially now when you would have to share arrays in order to match the groups. That is why I was asking for a more general description. There might be a simpler way of doing this. Right now, I don't see how I can help.

-LB