March 19, 2009 at 2:40 pm
Hi all...
Wondering how I can deploy a report via SSIS and leave criteria blank for the user to specify when they go to run the report? Say if I had a query such as below, and have maybe a WHERE statement like WHERE LAST-NAME = ? or however so that person can put in their own variable and then run the report. Maybe "customizing the report" is how I can state this question? I'm not too sure on the verbiage here, so forgive me.
Lastly, is there a different way to do the above if the intent is to send it to Sharepoint or the reporting website? Thank you.
SELECT * FROM dbo.SQLtest1 where DATE >= '20090309' and DATE <= '20090317' AND TYPE = 'Q'
March 19, 2009 at 3:19 pm
This should provide you with all of the information you need to setup the reports to use SSIS and pass in parameters:
Configuring Reporting Services to Use SSIS Package Data
Using a parameterized SSIS package as a data source for SQL Reporting Services
I used the SSIS setup with SSRS using SSAS data and did a posting here:
Using Reporting Services (SSRS) with SSAS data
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
March 20, 2009 at 7:36 am
Dan, thank you so much. Are the same steps valid for 2005? I should have specified I don't have 2008.
March 20, 2009 at 8:03 am
Here is the Configuring Reporting Services to Use SSIS Package Data link. This will work with 2005.
The other links I had sent were referencing 2005.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
March 20, 2009 at 8:06 am
Thank you so much, Dan. This was a huge help!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply