[quoted text, click to view] On Mon, 4 Apr 2005 20:55:02 -0700, VijayK <kvjkumar@gmail.com> wrote:
>Hi,
>
>I am very new to using this MS Reporting Services.
>I have a question regarding linking different report Project.
>
>My Report requirement is
>User Keyin Certain Parameters on a Single Screen(First Report) should be
>able to generate 4 Different Reports
>(1.Summary Report, 2.Detail Report, 3. Charting Diagram (Bar Chart)
>4. Charting Diagram ( Line Chart) using the same User Keyin Parameters.
>
>Basically the flow is First Report (Summary Report) is generated using the
>User keyin parameters & reterving Data from SQL Table A. Then using the
>Output of the Summary Report as a key for reterving Data from SQL Table B &
>Generate the Detail Report . Then Using Certain key values of the Detail
>Report Output as a key Reterive Data from SQL Table C & generate both the
>Charting Diagrams (Bar / Line Charts)
>
>Also All the 4 Reports needed to generated at the same time (I mean
>Automatically when the User key in the Parameter on First Screen and Press
>View Report)
>
>Is this kind of Reporting Acheivable using MS Reporting Services. If it is
>possible can anyone help me how to acheive this.
> --
>VJ
Do your reports have to be on "live" data?
If not, then scheduled reports might give you what you need. Of
course, if there is a large number of possible parameters that would
be a clumsy approach but might still work ok depending on whether you
could run all the posts, say, at 04:00 to be used during the following
working day.
Andrew Watt
