nested subreports

[whizzz]

hello friends,

How can I create links on subreports to link to another subreport ?

Basically,

I have 3 reports created.One is a master report which has a link on analyst name,an on demand subreports is linked.And, I want to link from this second report to another subreport through a link on trouble ticket number.That is I need to link a subreport on 1st subreport.First report links to second ,second links to third.

In my case, what is happening is 1st report is linked to 2nd & 2nd is not showing the link to the 3rd.If I run individually, the 1st will link to 2nd and 2nd will link to 3rd.BUt on the flow, its not happening.

My intension is,
The first report will display the analyst details with his name.(eg:Joseph)
The link on name will lead to the second report which contains the list of all calls assigned to that analyst, (eg: say, ticket no: 1, 2,3 are assigned to joseph).
The link on the ticket number on second report will lead to the 3rd report contains the details about that particular call (eg: when I click 3, the details of call no: 3 is displayed)

This way I want to implement a cascading way of reporting...

I need ur help.

Thanks in advance

//smitha

 

[lbass]

You cannot have subreports within subreports. I think you could achieve a similar report by using the drill-down approach. If you inserted groups on analyst name, calls, and ticket numbers, you could then hide the GH2 and GH3 headers and the detail section. Double-clicking on the headers would then make the next level of information available.

-LB