Connecting Tech Pros Worldwide Help | Site Map

Oracle Reprots

Familiar Sight
 
Join Date: Jun 2007
Posts: 151
#1: Nov 12 '07
hi all



Can anyone help me out how to convert a text based report into PDF. Just by changing it inAPPs, will that work or do i need to do something even in the report builder.



thank you

vamsi
amitpatel66's Avatar
Moderator
 
Join Date: Mar 2007
Location: Hyderabad, India
Posts: 2,192
#2: Nov 12 '07

re: Oracle Reprots


Quote:

Originally Posted by vamsioracle

hi all



Can anyone help me out how to convert a text based report into PDF. Just by changing it inAPPs, will that work or do i need to do something even in the report builder.



thank you

vamsi

When you register a concurrent program, you need to select the format as PDF for the output format type.
Familiar Sight
 
Join Date: Jun 2007
Posts: 151
#3: Nov 12 '07

re: Oracle Reprots


hi


the report had been registered long time back. it is in text mode, now can i change it to PDF. when i try to change it in apps , it throws an error Oracle Tool kit error. Pleaqse suggest me with a solution


thank you
vamsi
amitpatel66's Avatar
Moderator
 
Join Date: Mar 2007
Location: Hyderabad, India
Posts: 2,192
#4: Nov 12 '07

re: Oracle Reprots


Quote:

Originally Posted by vamsioracle

hi


the report had been registered long time back. it is in text mode, now can i change it to PDF. when i try to change it in apps , it throws an error Oracle Tool kit error. Pleaqse suggest me with a solution


thank you
vamsi

Where are you making a change in oracle apps?
Familiar Sight
 
Join Date: Jun 2007
Posts: 151
#5: Nov 12 '07

re: Oracle Reprots


In application developer we open the concurrent program details and there output format is specified as PDF

Thank you
amitpatel66's Avatar
Moderator
 
Join Date: Mar 2007
Location: Hyderabad, India
Posts: 2,192
#6: Nov 12 '07

re: Oracle Reprots


Quote:

Originally Posted by vamsioracle

In application developer we open the concurrent program details and there output format is specified as PDF

Thank you

Change the system profile at user level:

ICX Report Format: default will be HTML at site level. Change it to PDF at user level and check if it works!!
Familiar Sight
 
Join Date: Jun 2007
Posts: 151
#7: Nov 12 '07

re: Oracle Reprots


sorry

i didnot get where exactly is system profile and report format


please help me out



thank you
vamsi
amitpatel66's Avatar
Moderator
 
Join Date: Mar 2007
Location: Hyderabad, India
Posts: 2,192
#8: Nov 12 '07

re: Oracle Reprots


Quote:

Originally Posted by vamsioracle

sorry

i didnot get where exactly is system profile and report format


please help me out



thank you
vamsi

Follow below steps:

1. Login to Oracle Applications
2. Select System Administrator Responsibility
3. Navigate through Profile -> System.
4. In the profile window, check the box "User" and enter the User login ID
5. In the same window, enter the profile name in find profile text box as "%format%".
6. Click on FIND button.

This will open another window with all the profiles whose name contains the word "format". Check for ICX Report format profile option and set that to PDF at user level.
amitpatel66's Avatar
Moderator
 
Join Date: Mar 2007
Location: Hyderabad, India
Posts: 2,192
#9: Nov 12 '07

re: Oracle Reprots


Few more steps to generate PDF output:

You can also directly generate PDF output from Reports builder 6i by navigating through File -> Generate -> PDF

You can go to property palatte of the RDF. Then click on Distribution button and enter the different types of output you want (Eg: HTML,PDF etc) at single point of time
Reply


Similar Oracle Database bytes