alkodo
Member
When I run a report, I would like to dynamically rename a report's filename (like: <Reportname>-<Lot Number>-<Date>-<Time>.
Is that even possible?
Is that even possible?
Rayxue
Well Known Member
If I understand the question... use P.O value as report name to show on PDF.
78aspide78
VIP Member
Hi,
if you want to rename the filename under the prinqueue....
1)Find the original report name at the end of the job execution (search the list for this)
2)Executa a BSFN on an external program to rename the old file with the new name.
3) update the job submitted table withe the new name so can view the pdf from jde
If you need some help feel free to ask me.
Reagrds
Bruno Condemi
if you want to rename the filename under the prinqueue....
1)Find the original report name at the end of the job execution (search the list for this)
2)Executa a BSFN on an external program to rename the old file with the new name.
3) update the job submitted table withe the new name so can view the pdf from jde
If you need some help feel free to ask me.
Reagrds
Bruno Condemi
alkodo
Member
Thanks for your response!
I would like more detail on your solution:
One wrinkle: I am using BI Publisher and want to rename the PDF (RD output).
1) How do I programatically find the RD filename?
2) Is there a BSFN or do I have to write it?
3) How do I update the queue to allow users to open the PDF?
I would like more detail on your solution:
One wrinkle: I am using BI Publisher and want to rename the PDF (RD output).
1) How do I programatically find the RD filename?
2) Is there a BSFN or do I have to write it?
3) How do I update the queue to allow users to open the PDF?
srired
Active Member
Hi Bruno,
We are looking something similar to this, but it is a csv file.
We developed a custom report which writes into flat file. The flat file should be formatted(.csv extension) in the similar name how a normal CSV report does and place it in the printqueue so that User can read it from the Submitted Job screen.(when run on local and server).
Can you share the information or list of posts which will assists to arrive at this requirement.
Thanks in Advance,
Srired
E9
We are looking something similar to this, but it is a csv file.
We developed a custom report which writes into flat file. The flat file should be formatted(.csv extension) in the similar name how a normal CSV report does and place it in the printqueue so that User can read it from the Submitted Job screen.(when run on local and server).
Can you share the information or list of posts which will assists to arrive at this requirement.
Thanks in Advance,
Srired
E9
Zoltan_Gyimesi
Legendary Poster
Hi Srired,
First of all to Bruno - excuse me replying isntead of you.
[ QUOTE ]
Can you share the information or list of posts which will assists to arrive at this requirement.
[/ QUOTE ]
This issue had been discussed donzens times dozens on JDEList.
Why do you ask Bruno for "list of posts"????
FIRST USE THE SEARCH FACILTY YOURSELF.
Z
First of all to Bruno - excuse me replying isntead of you.
[ QUOTE ]
Can you share the information or list of posts which will assists to arrive at this requirement.
[/ QUOTE ]
This issue had been discussed donzens times dozens on JDEList.
Why do you ask Bruno for "list of posts"????
FIRST USE THE SEARCH FACILTY YOURSELF.
Z
78aspide78
VIP Member
</font><blockquote><font class="small">In risposta di:</font><hr />
1) How do I programatically find the RD filename?
[/ QUOTE ]
First af all you need to setup the xmlp file persistence on File System (on jde.ini), the you can search into the xmlp dir for the file (xmlp have a defined shema for file name according with the name of the originale job plus some id and template localization but I'll be more specific when you get the original report name
</font><blockquote><font class="small">In risposta di:</font><hr />
2) Is there a BSFN or do I have to write it?
[/ QUOTE ]
Follow Zoltan's suggestion and search the list for this too.
</font><blockquote><font class="small">In risposta di:</font><hr />
3) How do I update the queue to allow users to open the PDF?
[/ QUOTE ]
It's easy, copy the xmlp file into printqueue and rename it with the original pdf name
I hope this suggestions can guide you to the right way.
Bruno Condemi
1) How do I programatically find the RD filename?
[/ QUOTE ]
First af all you need to setup the xmlp file persistence on File System (on jde.ini), the you can search into the xmlp dir for the file (xmlp have a defined shema for file name according with the name of the originale job plus some id and template localization but I'll be more specific when you get the original report name
</font><blockquote><font class="small">In risposta di:</font><hr />
2) Is there a BSFN or do I have to write it?
[/ QUOTE ]
Follow Zoltan's suggestion and search the list for this too.
</font><blockquote><font class="small">In risposta di:</font><hr />
3) How do I update the queue to allow users to open the PDF?
[/ QUOTE ]
It's easy, copy the xmlp file into printqueue and rename it with the original pdf name
I hope this suggestions can guide you to the right way.
Bruno Condemi
78aspide78
VIP Member
Hi Srired,
this is the high implementation design:
Report A create the csv file
Report A run a dummy report B using BSFN or c API to get back the job number
Report B produce a blank pdf file on printqueu aand the entry on F986110 table
Report A build the Report B full file name and move and rename the csv file into printqueue dir with the name of Report B (replacing the Report B file).
Thats all.
Regards.
Bruno Condemi
this is the high implementation design:
Report A create the csv file
Report A run a dummy report B using BSFN or c API to get back the job number
Report B produce a blank pdf file on printqueu aand the entry on F986110 table
Report A build the Report B full file name and move and rename the csv file into printqueue dir with the name of Report B (replacing the Report B file).
Thats all.
Regards.
Bruno Condemi
Similar threads
