Parameterized part of the query?

I have a standard report that I would like to use over and over. The
difference for each version is the WHERE clause on the dataset SQL. I tried
using a parameter and sending in the information but it doesn't seem to work.
Perhaps I am formatting it incorrectly. Any suggestions? Can I do this?
StephanieStephanie,
I hope, you do not want to pass T-SQL as a parameter. If you do, you should
have sql injection attack.
Try to do the following:
Open BIDS and create new Report project from file menu.
Add a new report item to your project.
Navigate to the data tab in the designer, then create a new dataset.
Choose command type - I recommend to use stored procedures, because of
security reason.
Type stored procedure name to the query string.
All of the stored procedure's parameters will be added automatically to your
parameter list in the report.
If you use command type text, then you should add manually the parameters if
BIDS does not do automatically.
You should find a really good step by step guide in the BOL under the SQL
Server 2005 Tutorials --> Reporting Services Tutorials --> Using a Dynamic
Query in a Report section.
I hope it will help for you.
Kind Regards,
Janos
"Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
news:4AE93DB5-D7B0-4C04-AA61-399062840200@.microsoft.com...
>I have a standard report that I would like to use over and over. The
> difference for each version is the WHERE clause on the dataset SQL. I
> tried
> using a parameter and sending in the information but it doesn't seem to
> work.
> Perhaps I am formatting it incorrectly. Any suggestions? Can I do this?
> Stephanie|||Janos,
Thanks for the help. I was able to find what I needed using the tutorial
you identified.
Stephanie
"BERKE Janos" wrote:
> Stephanie,
> I hope, you do not want to pass T-SQL as a parameter. If you do, you should
> have sql injection attack.
> Try to do the following:
> Open BIDS and create new Report project from file menu.
> Add a new report item to your project.
> Navigate to the data tab in the designer, then create a new dataset.
> Choose command type - I recommend to use stored procedures, because of
> security reason.
> Type stored procedure name to the query string.
> All of the stored procedure's parameters will be added automatically to your
> parameter list in the report.
> If you use command type text, then you should add manually the parameters if
> BIDS does not do automatically.
> You should find a really good step by step guide in the BOL under the SQL
> Server 2005 Tutorials --> Reporting Services Tutorials --> Using a Dynamic
> Query in a Report section.
> I hope it will help for you.
> Kind Regards,
> Janos
> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
> news:4AE93DB5-D7B0-4C04-AA61-399062840200@.microsoft.com...
> >I have a standard report that I would like to use over and over. The
> > difference for each version is the WHERE clause on the dataset SQL. I
> > tried
> > using a parameter and sending in the information but it doesn't seem to
> > work.
> > Perhaps I am formatting it incorrectly. Any suggestions? Can I do this?
> >
> > Stephanie
>