Report Setup Question

[ghesse]

Hello,

Let me start out by saying what I have: In my system I have users, roles that the users can have, and notifications that are sent out to the user based on their role.

I want to design a report that first displays all the notifications and the read rate for each of the notifications. When the user selects one of the notifications a report is displayed that lists all the roles and their read rate for that notification. Then if the user selects a role I want the users to be listed who haven't read that notification.

I'm working with CR.NET displaying the reports in a ASP.NET application and all the reports depend on stored procedures in MS SQL-2000.

I have all the logic worked out so the stored procedures return the correct value sets and I have created reports that work properly for each of the stored procedures.

My question is, how do I tie in all this functionality, I'm not so clear on what the real diffrence is between drilling down and generating a sub report. Also I need to know how to pass parameters from a specific row in a report to another report so it is generated properly if that is the course I need to take.

I'm open to any suggestions on how to get these three reports linked up so it is somewhat seamless to the user.

Thanks in advance,
ghesse

 

[pgtek]

Hi
If your using store procedure to run your 3 reports.
you cant link storeprocdure to an other.
they work separeted from on of an other. yes they would work
you can not have 2 sub report on 1 report you will loose the second on
If you have to link theses report i recommend to convert your store procedures to views then you will be able to link them

cheers

pgtek

 

[synapsevampire]

The rub here is that you cannot embed a subreport within a subreport, so the 3 level report concept won't work here.

So combining either the first 2 reports, or the second 2 reports might be required, and then you can use drill down or an on demand subreport.

-k