Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Analysis Server and Reporting Services (2005)  automatic PDF-reports with a datetime name

Author  Topic  Giri Starting Member 1 Post Posted - 2009-02-06 : 06:09:28 Hello everybody, I just entered in the world of the Reporting Services. So, I am really a Rookie. I hope that anybody can help me with my question. I would like to generate periodically a report using SQL Reporting Services. The report has to be saved in pdf (I know that this is possible), but I want to have a specific report naming convention, based upon its contents. The contents will have time related data for a selected period of time from a SQL Server table. For example: [A]_[B]_[C]_[D].pdf [A]: variable selected from the report table [B]: variable description selected from the report table [C]: start time of the selected period in the query that selects from the report table. Datetime format: YYMMDDHHMISS [D]: end time of the selected period in the query that selects from the report table. Datetime format: YYMMDDHHMISS Is there any way to do this? What tools would you suggest to create such a report?