June 18, 2009 at 1:57 pm
Hi,
I wonder if someone ever did that (without too much programming).
I have a table that contains actions per customer.
Can have more than one row per customer.
I would like pass over the table, picking up the information (5 columns) and map it on a document (word, pdf,...) with one document per customer... or at least one document per row.
By SSRS, I can map the ouput, but I will end up with one big document. right ?
Thanks
AL
June 23, 2009 at 1:45 am
We have something similar but we create one page per customer in SSRS. (Obviously multiple pages if they have more than one page of data). This is simple to do and allows you to set parameters in SSRS to filter to one customer or by whatever you fancy. We use it to generate client statements.
June 23, 2009 at 8:00 am
Hi Al,
Not really sure exactly what it is you are looking for. If you are looking to display a report that shows details of one customer, then, you could create the report and let the user select the customers name as a parameter. Or if you wanted to create a report that showed multiple customers reports that you could print out(page per customer) then you could use the list control.
----------------------------------------------------------------------------------------------
Struggling to find the question?
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
June 23, 2009 at 9:49 am
My problem is more than I wanted to create separate documents. one per customers.
I did a report in SSRS, but I ended up with one big report that include all customers info.
Al
June 24, 2009 at 1:06 am
I think I get it now, are you wanting SSRS to generate an individual web page per customer? Wow, well if anybody has managed to do that I would like to know as well. Maybe there is a guru or 2 out there that can assist.
----------------------------------------------------------------------------------------------
Struggling to find the question?
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
June 24, 2009 at 3:22 am
There will be others with experience in doing this and maybe better ideas but to my mind you would need to create a report that generates all customers in one report but has a parameter per customer. You would then have to generate a subscription per customer to pass the parameter value through and then export to PDF.
How many customers do you have? You may need some automation to set the subs for you.
Steve.
June 24, 2009 at 8:47 am
If you're running Enterprise you can set up a data driven subscription and run the whole customer list through a single-customer report that takes a customer identifier as a parameter. Just pile the output docs in a directory someplace with unique names and you should be fine.
[font="Arial"]Are you lost daddy? I asked tenderly.
Shut up he explained.[/font]
- Ring Lardner
June 24, 2009 at 8:50 am
You can't have one subscription generate multiple docs though could you?
June 24, 2009 at 9:01 am
Sure.
If your report just shows the data for a single customer and uses a customer ID parameter, then you can set up a data-driven subscription to run that report a zillion* times and save the output of each one. Just populate the customer parameter with a query against your customer table, choose your doc type, set an output folder and make sure you put a unique name on the output files. Of course, this is all predicated on having Enterprise Edition. If you're running Standard you don't get data-driven subscriptions and you're sunk.
* "zillion" is an adjective, not a number.
[font="Arial"]Are you lost daddy? I asked tenderly.
Shut up he explained.[/font]
- Ring Lardner
June 24, 2009 at 9:09 am
Aha, didn't know that. Thanks, might be useful going forward.
June 24, 2009 at 5:46 pm
Will try it and let you know... That's a good idea.
thanks
Al
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply