October 13, 2010 at 1:37 pm
Hi,
i have taken empoyee code as input parameter and generating a report employee wise and we need it in PDF.
can we have all report generated and send it in seperate or same pdf file for all employee code i pass it.
we are using sql 2005 and it's reporting services.
Kindly help. any suggestion helps.
thanks in advance.
Regards
Durai Nagarajan
October 14, 2010 at 7:11 am
If you are talking about running the report multiple times with a single value as an input parameter, accumulating in a PDF document so that the PDF document shows all the versions of the report, I don't think that is possible. If it is, that is something I would like to learn.
You might consider however, making it a multi valued parameter, in which case your PDF would contain a single report containing data for all values of the input parameter.
October 14, 2010 at 7:28 am
Hi,
if i select the input parameter as multi value then if i pass all the employee code for which the report needs to be generated.
will it run.
thanks for your reply and help me with this also.
Regards
Durai Nagarajan
October 14, 2010 at 9:03 am
Sure, why wouldn't it? You might need to change your stored procedure/query around a bit to work with multiple values, but it wouldn't be a big deal.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply