Hi,

I have a report with subreport (in Group footer), crosstab (in Group header).

For cross tab calculation, I need a value from subreport to be passed to main report.

I could pass the value.. but since the crosstab is in group header , I am not able to get the values .. .it is all 0....

Please help me ...

Hi Brian,

Thanks for the reply.. I am getting the book today...

Meanwhile, Let me put my query clear enough...

I am not getting any value from cross tab...

I have to pass the value to main report from sub report and that should be used in cross tab...

Here goes my formula,

In sub report I have
shared numbervar cnt:=count((id),@lgroup)
I put this in group header section of sub report

In the mainreport I have
shared numbervar cnt;
cnt

I put this formula in the main report section where I placed my sub report...

I can get the values passed to my main report...

But when i include it in the cross tab (which is in main report group header), I am getting all group count as 0 ...

I hope it is bcoz subreport gets evaluated after the group header... so the value is 0.. Is there any workaround for this ?