Page 1 of 1

One report for n documents (pdf) with scheduler

Posted: Thu Jun 01, 2017 12:21 pm
by sdrouet
Hello,

I'm evaluating Reports.Server.
I'd like to produce multiple PDF files based on 1 report with a daily frequency.
1 file = 1 customer (same report template for all customers).
The sqlsource to produce a file is a query with a variable like : select name, address, amountdue from customer where id = {customerid}

I'd like to process all customer from table, with 1 PDF file on each time.
How can I achieve this ?

Thank's for help.

Re: One report for n documents (pdf) with scheduler

Posted: Fri Jun 02, 2017 10:52 am
by HighAley
Hello.

Yes, we have such feature.

You can create a Mailing list. Please, look at the images.
image_2017-06-02_13-42-09.png
image_2017-06-02_13-42-09.png (59.42 KiB) Viewed 7313 times
image_2017-06-02_13-42-19.png
image_2017-06-02_13-42-19.png (59.81 KiB) Viewed 7313 times
Thank you.

Re: One report for n documents (pdf) with scheduler

Posted: Tue Jun 06, 2017 9:55 am
by sdrouet
Hello,

I was looking for documentation, but the function is not documented here : https://www.stimulsoft.com/en/documenta ... create.htm

I don't understand the usage of the function mailing as solution.
Can you show me a usage sample ?

Is it possible to produce files only (do not send email).
In datasource I only see Tables from my DB. Can I have Views too ?

Thanks for help

Re: One report for n documents (pdf) with scheduler

Posted: Fri Jun 09, 2017 8:29 am
by HighAley
Hello.

Unfortunately, it's impossible to save files without mailing them. You could add there any dummy email.
You could add Tables and Views and any other data sources for the mailing.
photo_2017-06-09_11-28-42.jpg
photo_2017-06-09_11-28-42.jpg (59.94 KiB) Viewed 7292 times
Thank you.

Re: One report for n documents (pdf) with scheduler

Posted: Tue Jun 20, 2017 1:39 pm
by sdrouet
Ok, I have test mailing part and I think I can do the job with dummy email.

In your road map, do you plan to add a mass production of exported reports with a parameter which come from a datasource like in the mailing function ?

Thank's for your help.

Re: One report for n documents (pdf) with scheduler

Posted: Wed Jun 21, 2017 12:14 pm
by HighAley
Hello.

Today will be available our next build.
In this build you should not add a email address. There will be no error.

Thank you.