Add filters dynamically

Hi,

I am using a ReportViewer control on the windows form to connect to Report Server, process the report remotely (ServerReport) and render the report in PDF format.

The user wants to add some fiter(criteria) each time before the report is rendered. The filter (criteria) is generated separately. The original content of RDL should not be changed. I know, Report Builder is an option available. But, the end-user doesnt want to use Report builder to design the report.

I need to know, is there anyway I can retrieve the dataset->commandtext of the report(published on REport Server), edit and set it back dynamically, before rendering to PDF or any API, which can allow to add filters programmatically.

Thanks in advance.

You can pass it as report parameter. But is must be done carefully to prevent SQL injections)

Add filters dynamically

Hi,

I am using a ReportViewer control on the windows form to connect to Report Server, process the report remotely (ServerReport) and render the report in PDF format.

The user wants to add some fiter(criteria) each time before the report is rendered. The filter (criteria) is generated separately. The original content of RDL should not be changed. I know, Report Builder is an option available. But, the end-user doesnt want to use Report builder to design the report.

I need to know, is there anyway I can retrieve the dataset->commandtext of the report(published on REport Server), edit and set it back dynamically, before rendering to PDF or any API, which can allow to add filters programmatically.

Thanks in advance.

You can pass it as report parameter. But is must be done carefully to prevent SQL injections)

Add a print button on to Reportviewer of srs

Hi,
I have generated reports using SQL server reporting services 2000. I need to
put a print button in the report tool bar which will prints the content
displayed in the report(only the report content). Can any body tell me how to
enable the print option in the tool bar of repotviewer.
Thanks in advance
AjayAjay,
To my knowledge, you need to export to PDF, then print from acrobat reader.
Ask for a second opinion though...
--
TIM ELLISON
"Ajay Kumar" <AjayKumar@.discussions.microsoft.com> wrote in message
news:8517AE77-6E2F-4F29-AB37-93FEEEA5C173@.microsoft.com...
> Hi,
> I have generated reports using SQL server reporting services 2000. I need
to
> put a print button in the report tool bar which will prints the content
> displayed in the report(only the report content). Can any body tell me how
to
> enable the print option in the tool bar of repotviewer.
> Thanks in advance
> Ajay
>|||Ajay,
It is simple ... you can't :-(
However, if you are willing to hold you breath a couple of months, Service
Pack 2 will come with a print control and you will have the much coveted
print button.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Ajay Kumar" <AjayKumar@.discussions.microsoft.com> wrote in message
news:8517AE77-6E2F-4F29-AB37-93FEEEA5C173@.microsoft.com...
> Hi,
> I have generated reports using SQL server reporting services 2000. I need
> to
> put a print button in the report tool bar which will prints the content
> displayed in the report(only the report content). Can any body tell me how
> to
> enable the print option in the tool bar of repotviewer.
> Thanks in advance
> Ajay
>|||When Service Pack 2 will be released ? Is it before SQL Server 2005 ?
Thanks
"Teo Lachev [MVP]" wrote:
> Ajay,
> It is simple ... you can't :-(
> However, if you are willing to hold you breath a couple of months, Service
> Pack 2 will come with a print control and you will have the much coveted
> print button.
> --
> Hope this helps.
> ---
> Teo Lachev, MVP [SQL Server], MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/|||The last think I heard is that it will be slated to January - February
timeframe.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Keenz" <Keenz@.discussions.microsoft.com> wrote in message
news:E60EFA77-809F-476B-BE01-FD58778ABF05@.microsoft.com...
> When Service Pack 2 will be released ? Is it before SQL Server 2005 ?
> Thanks
> "Teo Lachev [MVP]" wrote:
>> Ajay,
>> It is simple ... you can't :-(
>> However, if you are willing to hold you breath a couple of months,
>> Service
>> Pack 2 will come with a print control and you will have the much coveted
>> print button.
>> --
>> Hope this helps.
>> ---
>> Teo Lachev, MVP [SQL Server], MCSD, MCT
>> Author: "Microsoft Reporting Services in Action"
>> Publisher website: http://www.manning.com/lachev
>> Buy it from Amazon.com: http://shrinkster.com/eq
>> Home page and blog: http://www.prologika.com/|||Has the new service pack release for print option in the report veiwer .
Please need the information urgently.
Thanks
Ajay kumar
"Ajay Kumar" wrote:
> Hi,
> I have generated reports using SQL server reporting services 2000. I need to
> put a print button in the report tool bar which will prints the content
> displayed in the report(only the report content). Can any body tell me how to
> enable the print option in the tool bar of repotviewer.
> Thanks in advance
> Ajay
>|||SP2 will contain a new print button on the tool bar. We are currently in
beta.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ajay Kumar" <AjayKumar@.discussions.microsoft.com> wrote in message
news:69CE9B88-19EC-455F-8B51-4668360B8C21@.microsoft.com...
> Has the new service pack release for print option in the report veiwer .
> Please need the information urgently.
> Thanks
> Ajay kumar
> "Ajay Kumar" wrote:
>> Hi,
>> I have generated reports using SQL server reporting services 2000. I need
>> to
>> put a print button in the report tool bar which will prints the content
>> displayed in the report(only the report content). Can any body tell me
>> how to
>> enable the print option in the tool bar of repotviewer.
>> Thanks in advance
>> Ajay|||Any news from service pack 2 ?
Greetz
"Daniel Reib [MSFT]" wrote:
> SP2 will contain a new print button on the tool bar. We are currently in
> beta.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Ajay Kumar" <AjayKumar@.discussions.microsoft.com> wrote in message
> news:69CE9B88-19EC-455F-8B51-4668360B8C21@.microsoft.com...
> >
> > Has the new service pack release for print option in the report veiwer .
> >
> > Please need the information urgently.
> >
> > Thanks
> > Ajay kumar
> >
> > "Ajay Kumar" wrote:
> >
> >> Hi,
> >>
> >> I have generated reports using SQL server reporting services 2000. I need
> >> to
> >> put a print button in the report tool bar which will prints the content
> >> displayed in the report(only the report content). Can any body tell me
> >> how to
> >> enable the print option in the tool bar of repotviewer.
> >>
> >> Thanks in advance
> >>
> >> Ajay
> >>
>
>|||Not sure what you are asking. SP2 was released last week.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Koen" <Koen@.discussions.microsoft.com> wrote in message
news:6D56A681-91A3-4E37-8910-E63F38D321DF@.microsoft.com...
> Any news from service pack 2 ?
> Greetz
> "Daniel Reib [MSFT]" wrote:
>> SP2 will contain a new print button on the tool bar. We are currently in
>> beta.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Ajay Kumar" <AjayKumar@.discussions.microsoft.com> wrote in message
>> news:69CE9B88-19EC-455F-8B51-4668360B8C21@.microsoft.com...
>> >
>> > Has the new service pack release for print option in the report veiwer
>> > .
>> >
>> > Please need the information urgently.
>> >
>> > Thanks
>> > Ajay kumar
>> >
>> > "Ajay Kumar" wrote:
>> >
>> >> Hi,
>> >>
>> >> I have generated reports using SQL server reporting services 2000. I
>> >> need
>> >> to
>> >> put a print button in the report tool bar which will prints the
>> >> content
>> >> displayed in the report(only the report content). Can any body tell me
>> >> how to
>> >> enable the print option in the tool bar of repotviewer.
>> >>
>> >> Thanks in advance
>> >>
>> >> Ajay
>> >>
>>