How to link from Detailed to Summary

[jchennuri]

Hi All:

Here is the situation

Month 1:

A text1 text2 text3
B text4 text5 text6

Month 2:

A text1 text2 text3
B text4 text5 text6

If I click on A I should get
A:
Month 1 text1....
Month 2 text1....

What is the best way to do?

Any help is highly appreciated.

Thanks,
JC

 

[lbass]

It is unclear whether the "situation" you show is how the report must be laid out or whether you are showing the database fields. If you have the option, then group on {table.letter} and then on {table.month}.

If instead you are saying that the "situation" is your required report format and you need to also show the results per letter, then you could insert an on-demand subreport which is grouped by {table.letter} and then by month and linked to the main report on {table.letter}.

The main report should be grouped by month and then by {table.letter} with the detail suppressed. Place the subreport in the {table.letter} group header instead of the groupname. Then go to format subreport->subreport->on demand->caption->x+2 and enter {table.letter} so that the letter itself becomes the link to the subreport.

-LB