calling report with desformat prt file
145561Aug 1 2006 — edited Aug 7 2006Hello.
First some background:
According to forms and reports documentation, when you want to call a character mode report (MODE=Character) when DESTYPE=FILE and DESNAME=filename using a printer definition file (prt file) you set DESFORMAT=name_of_prt_file
I assumed that this is done from forms with:
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESFORMAT,'prt_file')
examples of possible values for prt_file : hpl, hplwide, dec, decwide, decland, dec180, dflt, wide, etc.
This works fine.
Now the problem:
The report is run in a secure reports server using the default security, that is, Portal security.
In this configuration, the reports fails with a security error:
"Cannot access the output format:rep_ind"
(rep_ind is the name or the prt file)
According to Portal documentation, you must set the Format to "Character" and define DESFORMAT=name_of_prt_file.
Does it mean that Format defined in Portal is not the same that DESFORMAT?
If i try from forms
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESFORMAT,'CHARACTER');
the security error is gone but i obtain instead:
"Unable to open printer definition file 'CHARACTER'"
If i try the above SET_REPORT_OBJECT_PROPERTY and also set REPORT_OTHER 'DESFORMAT=rep_ind'
the security error shows again.
That is logical since the call to SET_REPORT_OBJECT_PROPERTY
was "overriden" by setting REPORT_OTHER.
The question is: how do you set Format (as understood by portal) to "Character" and DESFORMAT to name_of_prt_file?
I think this question is not in the wrong forum since it is related to forms, although it depends strongly in Portal idiosyncracies.
Any comments are welcome.
Thanks.