Hi,
I will explain the scenario and the way i am doing it. Pls suggest me on how
to continue.
I have a ReportA with a table with 100 rows. I have a textbox that says
Filter which has a navigation to another Report, ReportB. Now this Report is
like a filter report - Where all the field names in ReportA are loaded as
parameters. Once the user selects the reports - clicks on the view button - I
want this to be show in the table on ReportB and filtered on ReportA.
How can i do that ?
Any help is appreciated.
Thanks
RPI'm not sure I entirely understand what you want to acheive but if you
need to generate data from one report and pass it to another, you may
want to use some VB.Net code using ADO.Net to generate the data which
can then be read in the other report.
If all you're trying to do is mirror parameters selected from ReportA
through to ReportB then set up appropriate parameters in ReportB and
you can pass the selections through dynamically in the navigation
properties.
Chris|||why don't you use a report parameter to filter?
see:
http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=990da582-3282-45e9-9469-fb6647bd8ee6
for some other possibilities
"RP" wrote:
> Hi,
> I will explain the scenario and the way i am doing it. Pls suggest me on how
> to continue.
> I have a ReportA with a table with 100 rows. I have a textbox that says
> Filter which has a navigation to another Report, ReportB. Now this Report is
> like a filter report - Where all the field names in ReportA are loaded as
> parameters. Once the user selects the reports - clicks on the view button - I
> want this to be show in the table on ReportB and filtered on ReportA.
> How can i do that ?
> Any help is appreciated.
> Thanks
> RP
