Report bursting to many Folders

[PRIT AMRIT]

Hi Guru's

I have a report bursting requirement. I have 200 USERS and having their own folders(200 folders) with their name.
I have 200 reports(each belong to 1 user) needs to be scheduled daily basis and burst under the respective folder the User belong to.

Is it possibel and how? Thanks.

Regards,
Prit

[charon]

hey Prit,

as far as i know its NOT possible directly to burst them in different folders based on the bursting data item. however, after bursting into one folder you can create a job that distribute the files into the correct folder. google will help you to find nice introduction in creating these jobs...let me know when you succeeded.

gl :)
cheerz :P

[vasudev_chavan]

Its can be archived.

Steps:

1.Need to burst the report to cm.out location
2.When ever a report is burst it comes with 2 files file descriptor and file output.
   file descriptor is a XML file which contain all the information about report.
   file output the output file in whatever format we have burst it.
Example: 111abcxyc.xml.
                111abcxyc.pdf.

In the above example we can find a 2 output file for one burst report

trick is .

Read the XML file and get the burstkey and use the bustkey and report name to rename the output file.

once the rename is completed we need to run a script to move the file based on bustkey to the different folder.

Best practice is burstkey should be username and even the folder which can help you in moving the file to the respective folder.

Thanks,
Vasudev

[PRIT AMRIT]

How I have done is, Scheduled the report for all the 200 Users with their names. Then bursting these entries to a file location. Now file location has all the 200 excel output belonging to each User with their name e.g. User1_ReportName.excel...... User200_ReportName.excel

Now, I have created a .bat script to copy the reports by checking the User name and putting it in the respective User folders. This works.

Thanks
Prit

[olivierh]

How I have done is, Scheduled the report for all the 200 Users with their names. Then bursting these entries to a file location. Now file location has all the 200 excel output belonging to each User with their name e.g. User1_ReportName.excel...... User200_ReportName.excel

Now, I have created a .bat script to copy the reports by checking the User name and putting it in the respective User folders. This works.

Thanks
Prit

Can you elaborate on how you achieved this?

I am looking for a similar solution, but I only bursted to recipients before. So I am a bit in the dark.
See my original question here

Thanks!