Grouping on Subreport value

[BB45]

CE 10
CR 10
SQL 2000

I am wondering if it is possible to group the main report on a value passed from the subreport.

In my subreport I have this:
@Advocate
shared stringvar Advocate;

shared stringvar Advocate:= {Client.Name};

shared stringvar Advocate;

In my main report I have this:

@Advo
Shared stringvar Advocate;

I want to be able to group by @Advo in the main report. Am I doing something wrong?

Thanks
BB

 

[lbass]

Yes, you cannot do that. You could, however, make your subreport your main report (and make your main report a subreport) and then you will be able to create the group directly on the field.

-LB