Dynamic Reports needed send via scheduled report

[Saib1]

Hi all,

Is there a way that we can create Dynamic reports and that reports can send via scheduled reports

For Example Dynamic Report

if API Source = AIB or API Source = Siebel

Scheduled Report will be sending to each each source individually based on the data in one report.

For Siebel -  only the Siebel data should be send to Siebel Point of contact

For AIB - Only the AIB data should be send to AIB Point of Contact 

Is that possibel ?

[Ankur Bawiskar]

@Saib1 

you can update the filter condition and then trigger the report.

you need to do this one by one 1st for Siebel and then for AIB

[Saib1]

Hi Ankur 

Yes in reports i will put the condition .

what about reports how that will send to user .

I have 2 scheduled reports ,

First scedule -  need to pickup only the data contains AIB and send to user? .

Second scedule - need to pick up only the data contains Siebel and send to user?

[Ankur Bawiskar]

@Saib1 

just before the scheduled report runs have scheduled job and update the filter condition via script to contain data for AIB

then have another scheduled job which runs just before 2nd scheduled report and update the filter condition to contain data for Siebel

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Saib1]

@Ankur Bawiskar 

Do we need to glide the record? from the table - api_integration_source_data

Can you give me the code?