Bursting same report but different content to multiple emails

[oscarca]

Hello Cognoise,

I am looking to burst a report which consist of 3 columns;  Shipment, supplier nr and departure date.
Every supplier is linked to a couple of shipments. What I am trying to accomplish is to burst the report to different mail addresses with a list of that suppliers shipments i.e different content to different mail addresses. I have a second query that consist of supplier nr and mail address. Has anyone done this and how ?

Best regards oscar

[oscarca]

******Solved******

[Nikhil Shenoy]

Do share your solution. Might help solve someones future queries. :)

Regards,
Nikhil

[oscarca]

Hey Nikil,

First step:
I created three different queries(Burst_Data, Distribution list, Burst_Report)
Burst_Data: Containing the data that the report will use including an ID column in this case supplier nr to be joined with the Distribution list.

Distribution list: Containing two columns i.e supplier nr and Email address

Burst_Report: left join between Burst_Data and Distribution list (the list being displayed in the report is based on this query)

Second step:
Setup the burst by going to the burst option and choose burst groups query = Burst_Report and Label = Supplier nr and Groups = Suppler nr and for Burst recipient choose query Distribution list, Data item = Mail address and then master details relationship between Supplier nr.

Third step:

Create a schedule for the report

[oscarca]

Something that would be interesting is, if it is possible to burst a report on different hours, depending on what country it is being sent to. For exempel let say we have two people who wants to receive the same report, but they are located in different countries with different time zones (US and UK). So the Person A (London) wants the report to be sent 12 pm which would be 4 am for Person B (Los Angeles), therefore the report has to be sent at 12 pm to Person A and 8 pm to US since there is a 8 hour time difference.

Is this possible to accomplish with burst table ? (case when 'London' then this time or when 'Los Angeles' then this time)

[MFGF]

Something that would be interesting is, if it is possible to burst a report on different hours, depending on what country it is being sent to. For exempel let say we have two people who wants to receive the same report, but they are located in different countries with different time zones (US and UK). So the Person A (London) wants the report to be sent 12 pm which would be 4 am for Person B (Los Angeles), therefore the report has to be sent at 12 pm to Person A and 8 pm to US since there is a 8 hour time difference.

Is this possible to accomplish with burst table ? (case when 'London' then this time or when 'Los Angeles' then this time)

Hi,

This isn't how bursting works, unfortunately. Think of bursting as being where the report executes once, and delivers multiple outputs from that one execution.

If you wanted to deliver report outputs at different times, you should probably look at report views instead of a burst report. You can author a report once, add prompts (eg for time zone), save the report, then create as many report views as there are time zones. Each view can have a separate scheduled time, and can have different defined prompt values.

Cheers!

MF.

[oscarca]

Hey MFGF,

I see your point, the problem is if you have 100 people living in different places you would like to automate this somehow so that it iterates through a list so it knows when to be sent out. So for everyone located in London then 12pm, for everyone located in Los Angeles then 8pm local server tim etc..

I assume this is not possible, since it seems rather complex.