Hi. I need to exceute a SSRS 2005 report in batch with the SQL Server Agent. This report has some parameters. How can I do know to SQL Server Agent which are these parameters? I don't want to write the values in the settings of report subscription. Is it possible to do to read a table containing the report parameters or to save to a table the parameters when the user launches the report in the report manager? Many thanks

Hi, It is only possible to read parameters in a table when the report is executed on schedule, we can achieve this by using Data-Driven Subscription. For example, we can create a table include the fields of user E-mail address and each parameter. After the data-driven subscription is configured, the report will be send to each user by using the corresponding parameters which stored in the same record. For the detailed steps about Creating a Data-Driven Subscription, you can refer to: http://msdn.microsoft.com/en-us/library/ms169673.aspx If you have any question, please feel free to ask. Thanks, Tony Chain

Hi Tony, but could a user fill this table by a SSRS report? Thanks

Hi, Reporting Services is designed to show end-user a report by retrieving data from database, so users could not fill data tables in database. If you also need to collect the parameters when users launch the report, I would suggest you creating a custom application by using the ReportViewer control. For more information, you can refer to http://msdn.microsoft.com/en-us/library/ms251669(v=VS.90).aspx Thanks, Tony Chain

Hi Tony, SSRS allows to use for a dataset a stored procedure. To this stored procedure it is possible to pass the report parameters and in the sp it is possible to write an INSERT or UPDATE statement. The stored procedure must terminate with the SELECT that returs the dataset data. Is it possible for a command text dataset specify an INSERT before the SELECT that returns dataset data without using a stored procedure? Or by using a stored procedure or a composite command text dataset for me it is possible to write the report parameter values in a SQL table. Many thanks

Hi, From my testing, it is possible to add INSERT before SELECT in command text to fill table in database. However, in this way, if the parameters of INSERT command have values, the INSERT command will be executed each time when report refreshes. Thanks, Tony ChainTony Chain

Oh, thanks. Also I have tested to add Insert before Select in the command text. Thanks