Dynamic output file name for scheduling a BIP report
575405May 18 2008 — edited Oct 19 2008Hi All,
I have a BI Publisher report. It has Department as prompt. we need to run the report for each department. I need to schedule the report such that, for each department i need to FTP the output with file name as department_INFO.pdf in the one folder (i.e. if dept is ABC, then i need to store the output with file name as ABC_INFO.pdf and ftp to the folder). Folder will be created already in the server.
We have around 40 departments, so i need to manually schedule this report 40 times with 40 files names and ftp the output to the folder in the server.
Can we dynamacally give the output file name based on the prompt we are using to run, instead of manually scheduling for each department.
Please help me ASAP..we cant move further due to this problem.
Regards,
Satti