One report for n documents (pdf) with scheduler

Stimulsoft BI Server discussion
Post Reply
sdrouet
Posts: 14
Joined: Wed May 24, 2017 8:32 am

One report for n documents (pdf) with scheduler

Post 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.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

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

Post 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 7266 times
image_2017-06-02_13-42-19.png
image_2017-06-02_13-42-19.png (59.81 KiB) Viewed 7266 times
Thank you.
sdrouet
Posts: 14
Joined: Wed May 24, 2017 8:32 am

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

Post 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
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

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

Post 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 7245 times
Thank you.
sdrouet
Posts: 14
Joined: Wed May 24, 2017 8:32 am

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

Post 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.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

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

Post 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.
Post Reply