Any suggestions pls....

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

any plans for SQL 2K on x64 systems ?

Theres SQL 2000 on IA-64 but none for x64 .. why ? and are there plans for
launching it soon ? Pls let me know . Thanks
SQL 2005 (Yukon) Beta 2 is available to MSDN subscribers. One of the build
platforms is x64. I doubt that this will be retrofitted back into SQL 2000.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:ud5SY3yhEHA.2764@.TK2MSFTNGP11.phx.gbl...
> Theres SQL 2000 on IA-64 but none for x64 .. why ? and are there plans for
> launching it soon ? Pls let me know . Thanks
>

any plans for SQL 2K on x64 systems ?

Theres SQL 2000 on IA-64 but none for x64 .. why ? and are there plans for
launching it soon ? Pls let me know . ThanksSQL 2005 (Yukon) Beta 2 is available to MSDN subscribers. One of the build
platforms is x64. I doubt that this will be retrofitted back into SQL 2000.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:ud5SY3yhEHA.2764@.TK2MSFTNGP11.phx.gbl...
> Theres SQL 2000 on IA-64 but none for x64 .. why ? and are there plans for
> launching it soon ? Pls let me know . Thanks
>

any plans for SQL 2K on x64 systems ?

Theres SQL 2000 on IA-64 but none for x64 .. why ? and are there plans for
launching it soon ? Pls let me know . ThanksSQL 2005 (Yukon) Beta 2 is available to MSDN subscribers. One of the build
platforms is x64. I doubt that this will be retrofitted back into SQL 2000.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:ud5SY3yhEHA.2764@.TK2MSFTNGP11.phx.gbl...
> Theres SQL 2000 on IA-64 but none for x64 .. why ? and are there plans for
> launching it soon ? Pls let me know . Thanks
>