Dynamic Parameters for report designed in SQL Server Reporting Services 2005
-
Hi all, I have designed an .rdl report in my server(SSRS). I have a client program which will render this report and export. How do I pass connection parameters to the report dynamically? I tried using report parameters. I can pass only server name and database name. I want to pass User id and password too. Please help Thanks in advance Senthil
-
Hi all, I have designed an .rdl report in my server(SSRS). I have a client program which will render this report and export. How do I pass connection parameters to the report dynamically? I tried using report parameters. I can pass only server name and database name. I want to pass User id and password too. Please help Thanks in advance Senthil
for user name,passward,servername, u can set using connection string.... and just using dataset....try this