I have test in the main section of the layout in forms. I want to print the footer on the first page only. If I go to properties and select print object on first page, it still prints the footer in all pages. How can I force the footer on the first page only.
View 1 Repliesi have generate a report using report wizard but i want to know how join main section and head section , what ever you do in report wizard impact in main section ,i have done some head section ,when i run report, head section run first and main section in next page .. how to join both sections in single page output..
View 2 Replies View RelatedI understand when I decrease the width or height of the paper layout, it may cause this error if any of the objects in my report may not fit in the new layout.
But for me this error occurs even when I increase the size of my report paper layout!
I made a report that has a report wizard option 'Paper Layout only'. As I finished that, suddenly I realized that I must have to run it also in web. So I must have choose the options both 'paper layout and web layout'.
How can I do that or is it possible to do that without repeating everything that I have done?
i am using reports 6i .
i want to Print Multiple copies of report
1 - Customer copy
2- Department copy
3- Finance Copy
Setting the number of copies to 3 will print 3 copies of the report. But i want for each report , the footer should differ.
I have a problem here.Normally, we use &p_where inside a sql script in condition sectione.g :
select name from member where name like 'a%' &p_where order by name;
may i use this kind of parameter in table section?e.g :
select name from &p_table where name like 'a%' and status = 'a' order by name;
the reason i need to do is there are 2 different server. but i need retrieve same info.server ABC have table A but don't have table B and server DEF have table B but don't have table A.
Is there any other method to solve this problem?
Currently am facing a strange issue with reports 10g.I modified the existing report in the server by removing all the exisitng layout fields(10) and adding only one field.
I deployed this in the server and tried to execute the report from UI(OTM). I can see the report is getting called(observed this by adding new SRW messages). but showing the old layout only with 10 fields in it.
I have made a report with the layout in report it self only.but its showing error
REP-1219: 'F_27' has no size -- length or width is zero.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1219: 'F_27' has no size -- length or width is zero.
if have tried to solve this but it showing error for other field a same error. i am sending a my rdf .
I have Report in RB 10g , it is showing the logo in PRINT View but when I am running the report in the paper layout it does not showing the logo over there
View 1 Replies View RelatedI have a report with matrixs group, when I try to add a new group in a new level, I get this message :
REP-1108 : Cannot fit default layout even in region extending to page boundaries.
How can I increase the layout in 10g?
I am working on modifying various existing reports that other developers have created in the past. I noticed that on some of the layouts I am able to move frames and other objects by very small increments.
Yet in other reports if I try to move something just a tiny but up or down for example, it moves it by a very large increment. Is there some way, or some setting I need to set, in order to be able to move objects by smaller increments?
Im using forms & reports 6i and 10g. I migrated a form from 6i to 10g.The form is working fine, But Im facing problem in report output.When i try to run the report in oracle 10g web layout. It shows error message.
Terminated with error: <br>REP-1247: There exist uncompiled program unit(s). REP-1247: Report contains uncompiled PL/SQL.
When i already compiled the report so many times.
ctrl+k
ctrl+shift+k
ctrl+s
But still got the same error message.
I created a report ...whcih i complied and run on paper layout form.. it shown me on correct dta..but i change change layout size and postion on that viewer..
is it avoidable....if yes, then how ?? I wantto lock these object while previewing...
I want to create a report by using one field and one text as columns name in layout but display the all the columns. I mention the 5 column names in query.how can I write function in summary column.
View 4 Replies View RelatedApplication developed in form builder 6i.Now I want to create main menu for calling forms and reports.
Should I use buttons or drop down menu?
how to Run a Discoverer Reports in a Forms Menu.
View 2 Replies View RelatedIs it possible to link to Discoverer Viewer from Forms without requiring the user to log in again. If so, can I then link to a specific Workbook within Discoverer?
View 2 Replies View RelatedWhen running my query in sql developer, I have to execute the command apps.fnd_global.apps_initialize(user_id, resp_id, resp_appl_id) in order to show the result of my query. Without this, the query returns nothing. The problem is I am using this query as a custom query for my Discoverer report and my report does not show any record.
View 3 Replies View RelatedI need to copy my discoverer report from dev to prod. How should I do this? Are the items created using calculation in the report can also be copied? These items are not present in the folder in discoverer admin.
View 1 Replies View RelatedWhen I try to manage the report the Discoverer application frozen.
View 5 Replies View RelatedMy user would like to have a way to attach files to database records. For simplicity, we'll say that each employee in the database could have 0-many file attachments associated with them. I know how to make this part work using Oracle Forms.
So that's the easy part for me. The tough part is that they want to be able to run an Oracle Report on our application server (displays as a PDF, also downloadable as a PDF) and have links on this report to the attachments that they uploaded using the forms process above.
For the idea of storing the files on a folder somewhere, I simply created a text object on the report that had it's hyperlink property pointing to the file location. Done.. opens fine.
However, I want to be able to have the option of storing these files in the database instead, just in case we can't go with the shared folder idea. I'm not sure how to make this work. I can store a blob in the database.. but how do I link to that blob on the report for them to be able to download it? Is this even possible?
how to create a download link on the Oracle Report that let's them download a file out of the database.
I have a doubt; can we format a particular word in oracle reports at runtime..?
Ex:-
A text filed contains data Quote:We request #BANK# to finance the same Bill as per agreed interest rate and other terms and conditions agreed on the above addendum and immediately remit the proceeds to our account A/c no. #ACCOUNTNO#, held with your Bank.
We need to make #BANK#, #ACCOUNTNO# are bold at runtime, Is there any method to format characters at runtime..?
Currently some jobs created in WBT scripting need to converted into oracle,plsql.There is one job in WBT scripting, which will invoke the oracle reports inside and generate the PDF files in the destination path as follows:
a = runhide("c:Program FilesInternet Exploreriexplore.exe", "http://pscm9722:7778/reports/rwservlet?USERID=%LOGONINFO%+server=rep_pscm9722+destype=file+desname=D:ORACLE10G\%CCALLRptName%+desformat=PDF+PARAMFORM=no+report=PCCALL.RDF")
a = runhide("c:Program FilesInternet Exploreriexplore.exe", "http://pscm9722:7778/reports/rwservlet?
[code]...
Now, i want to convert this into oracle,plsql? Is it possible or not?
I am trying to put a report footer on a report that has a title.
However, when I specify the REPFOOTER under the title specification, I get the text after every row in the report. If I put it before the TTITLE definition, I get the TTITLE text before and after the report and the REPFOOTER text after the report.
How do I get the TTITLE to appear only before the report and the REPFOOTER text to appear only after the same report?
For example, if I specify
REPFOOTER 'footer text'
TTITLE 'title text'
the above text prints the TTITLE text before and after the report. and the REPFOOTER text after the report. Is there a way to only have the TITLE text come before the report and the REPFOOTER text after?
[Message #1] how to get a unapplied receipts for ageing report? and RMA(credit and debit note)columns ?
Which tables should be refered for Ageing reports.
[Message #2] How to create an ageing report in discoverer?
Which tables should be refered for a Ageing reports.
Ageing report colums customer name, customer id,location,segment, credit note and debit note in different column,unapplied amount and applied amount in a different colum.Already i got a due remaning date and total amount I want a linked table names.
I need the below output in oracle reports 6i.
this is a testing string retrieved from database.
now what i need is that to make bold the specific words in a string came from database.
I migrated a Oracle 6i Report to Oracle Report 9i so I'm trying to execute a this report in the Run Web Layout, but this doesn't bring me any information, how can i run this reports in the Web layout?
When i run this report en the Paper Layout it's bring me data. When a run the report just bring me a blank web page.
how to create Oracle Reports with Java Barcodes.
View 8 Replies View RelatedWhile accessing the reports i am getting the following error
Rep - 51002 : Bind to Reports Server rep_wwubh01ap45 failed.
I have checked the file $ORACLE_HOME/reports/conf rwservelet.properties. The parameter SERVER=rep_wwubh01ap45 was present in that file.
We have a reports proces which we want to produce a report where the browser windows doest not display, or if it does, quickly closes after the report is completed.We are using Forms Version 10.1.2.0.2, Oracle Database 10g Release 10.2.0.4.0, OS is Windows XP Pro SP3
We have tried the below, but the primary application window closes, not the report server window.
- http - removed due to form message:You cannot use links until you have posted more than 5 messages.
WEB.SHOW_DOCUMENT(://'|| :global.Report_Server_Name ||
'/reports/rwservlet?cmdkey=ky10i&report='||v_rep_object||'.rdf' ||
'¶mform=no&desformat=pdf&destype=file&desname='||v_file_dir||
'&P_VOU_ID='||'883100000000000005565047129970'||
[code]...
We have modified the forms trigger to produce the report as shown below, but get the error:
FRM-41213: Unable to connect to the Report Server
Current theory is the connection to the database is lacking the user id and password since the cmdkey is not specified. How can we specify the cmdkey when using the run_report_object?
= = = = = = = = = = = = = = = = = = = = = =
DECLARE
v_rep_tx VARCHAR2(100);
v_RepStatus VARCHAR2(2000) := '';
v_rep_idREPORT_OBJECT;
v_repVARCHAR2(100);
[code]...