September 14, 2007 at 12:31 pm
I need to add a parameter to the existing report which has already some parameters. I m very new to SS Reporting services and I need advice how to get to that.
September 16, 2007 at 4:43 pm
Hi Satish,
It really depends on the type of report query you're using (SQL, MDX, ??) and what you want to use the parameter for.
You can find Report Parameters under the Report menu in BIDS. You can add parameters here, though there's more to it if you want to add the parameter to your query. There are some good tutorials here which may help:
http://msdn2.microsoft.com/en-us/library/aa337432.aspx
Sam
September 16, 2007 at 5:55 pm
Thanks so much for your response. The report is using SQL query. But I just installed SQL Server 2005 on my office machine and I know that report can be opened and edited for adding parameters from Visual studio 2005 or BI Dev studio. But I'm not sure how to retrieve the report for editing. Can you please tell me from Visual studio, the steps to retrieve a report for editing ? When I connect to the instance on my server, all I see are the database, tables etc. I was told that the report is published on web and the hyper link for accessing that.
Any help is greatly appreciated.
Regards,
Satish
September 16, 2007 at 7:20 pm
Satish,
You'll have an IIS-based installation of reporting services somewhere in your organisation. It will have a /ReportServer directory, from which you can download the report definition. You also need to connect your Visual Studio project to this report server to upload your changes (though you can also do this manually through the Report Server). There is some information on this here, though it may not be *exactly* what you're after: http://msdn2.microsoft.com/en-us/library/aa337424.aspx
Sam
September 16, 2007 at 9:56 pm
Thank you so much. This is the information I m looking for.
Regards,
Satish
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply