I would like to know how can i add a column in existing report. I try to change SQL by doing this it does add that new column into group but when i try to run report i can not see that changes . then i try to do some changes in paper layout but i am not able to bring the changes in out put. i am new to this FORMS Reports . do i have to create a group again i am how can i change the layout in that report.
View 4 Replies
I'm using Report Builder 9.0.4.0.33.
I am creating a report which generates the data to a PDF/CSV based on users Input.When I create the report using Report Builder and execute the report,Delimited data appears in a PDF layout.
But if I add the below code in After Parameter Form trigger,the column headers keeps repeating with the data.
function AfterPForm return boolean is
begin
IF :P_DESTYPE = 'CSV' THEN
:MODE :='DEFAULT';
:DESFORMAT:='DELIMITED';
Elsif :P_DESTYPE = 'PDF' THEN
:DESTYPE := 'CACHE';
:DESFORMAT:='PDF';
END IF;
return (TRUE);
end;
[code]....
But the PDF output seems fine where the header is shown only once.I could see many posts regarding this in Oracle reports 6i wherein delimited_hdr=no is used in Command Line but I would like to know the work around in Oracle reports 10g.
While calling a report I am getting the following error.
REP-546: Warning: The value of restricted LOV parameter TOPROFIT is not among the selectable values.
When I call the same report through another PC it displays parameter form.
I am using Report Builder 10g.
In the parameter form in my report I want to give user the facility of browsing the location where he/she wants to store the report. how can I accomodate the same?
View 1 Replies View RelatedI want to show closing balance as opening balance by using place holder column
example
Date opbal sale closing bal
01-jun-2013 0 10000 10000
02-jun-2013 10000 5000 15000
how to do this
When a creating a pdf report in reports 6, under oracle 10g, the error message displayed is: The file is damaged and could not be repaired. If I change the report definition from a pdf to a txt file, the error does not display, but the output has the margings distorted.. It only happens when using reports 6
View 2 Replies View RelatedI am adding a parameter to the parameter form of existing reports based on a select statement and has two columns. That part is fine. However, Oracle reports is adding a dash between the two values. Still fine, but I am also adding a UNION with ALL in case the user wants to run the report for all values. In the Parameter form it looks like this:
ALL -
RBC - 111
RRG - 234
TEB - 445
How do I get rid of the dash for "ALL" since I did not physically add it? Below is my select statement for the parameter I created:
SELECT code,
code_num
FROM codes
WHERE code_num <> 0
UNION
SELECT 'ALL', ' '
FROM dual
ORDER BY 1;
i am facing another problem with 11g database. i am using 6i forms and reports and recently shifted database to 11g 64 bit version. as its 6i forms so i use run_product to call reports. suppose my code for runproduct is in a button, once i press the button to get the print i am getting the logon_screen. if i enter login data again its giving the report.
View 1 Replies View RelatedI receive the error,
REP-1241 Circular column dependency originating with column 'cenvat_opening'
I have the following return statement for a column total_credit;
function total_creditFormula return Number is
begin
Return (return nvl(:cf_cenvat_closing ,0) - nvl(:cf_duty_on_goods_ed,0);
end;
Now i am using this total_creditFormula for the error formula column 'cenvat_opening'
function cenvat_openingFormula return Number is
f_num_opn number(14,2);
begin
SELECT NVL(Amount,0) INTO F_NUM_OPN
[code]...
here the formula column 'total_credit' has the following return statements;
RETURN Nvl(:cenvat_opening,0) + Nvl(:cenvat_credit_manu,0)
so how can i use this formula column? is there any other option to return the value in the same column.
i have two questions.
(1) how can i fill some value in a table column based on some existing column value automatically without user intervention. my actual problem is i have 'expiry date' column and 'status'. the 'status' column should get filled automatically based on the current system date. ex: if expiry date is '25-Apr-2011' and current date is '14-May-2011', then status should be filled as 'EXPIRED'
(2)hOw can i build 'select' query in a report (report 6i) so that it will show me list of items 'EXPIRED' or 'NOT EXPIRED' or both expired and not expired separately in a single report based on user choice. 'EXPIRED' & 'NOT EXPIRED' can be taken from the above question no. 1.
This is what i want to do:
I have a basic report looking like this:
<Column name>
value 1
value 2
value 3
.
.
.
value n
Since the column is small it can fit in a page more then one time. I know how to make it print more then once: i switch the repeating frame to print down and across and i modify the frame that contains it so the horizontal elasticity is variable.
After these changes my report looks like this:
<Column name>
value 1-----------------------value n+1-----------------------value m+1
value 2-----------------------value n+2-----------------------value m+2
value 3-----------------------value n+3-----------------------...
.------------------------------- .
.------------------------------- .
.------------------------------- .
value n-----------------------value m
What i want is my report to look like this:
<Column name>-------<Column name>------------<Column name>
value 1-----------------------value n+1-----------------------value m+1
value 2-----------------------value n+2-----------------------value m+2
value 3-----------------------value n+3-----------------------...
.------------------------------- .
.------------------------------- .
.------------------------------- .
value n-----------------------value m
I am trying to select multiple values from a parameter form based on a select statement.
I created the parameter and write the select statement under list-of-value property However what I want is to let users choose multiple values from the select statement not only one value.
I have developed report in reports9i and executing this report at application server but the parameter form is not displaying as its displayed in report builder.
parameter form isn't in descriptive format like you can check the department field. how to create parameter form in descriptive format or I am doing any mistake?
I am calling a report from Form 6i by using RUN_PRODUCT.After pressing the call button from Form 6i, report is showing box for enterning user id and password.
View 5 Replies View RelatedI need to change the font face from following lov value for parameter form, How?
SELECT DISTINCT CODE_ENTRY.VILLAGE_NAME, CODE_ENTRY.UNIONN_NAME
FROM CODE_ENTRY
if i have two reports one of them is that you enter the office name and it will show you list of employee. the second one i want to show the information that is related to that employee by putting beside each employee button that if pressed i will go to other report that show me information about that employee.How i could link the two form and pass the employee name to the next form
View 4 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 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 want to create matrix report with 2 column
we can assign one column in matrix report my req is to assign 2 column .
example
Row Is FND
columns are Cdate & Ldate
Cells are Crate & Lrate
CDATE CDATE CDATE CDATE LDATE LDATE LDATE
FND 01-MAR 02-MAR 03-MAR 04 MAR 28-FEB 31-JAN 31-DEC
-------------------------------------
ABC CRATE CRATE CRATE CRATE LRATE LRATE LRATE
ABC CRATE CRATE CRATE CRATE LRATE LRATE LRATE
ABC CRATE CRATE CRATE CRATE LRATE LRATE LRATE
XYZ CRATE CRATE CRATE CRATE LRATE LRATE LRATE
XYZ CRATE CRATE CRATE CRATE LRATE LRATE LRATE
XYZ CRATE CRATE CRATE CRATE LRATE LRATE LRATE
display values in descending order( as got from fomula column). i put that field in above group and got properly. now i want to sum these values at the end of report. its going to some distinct values, while i want all values to be sum.
View 1 Replies View RelatedHow can i stretch field dynamically as per the requirement.
i use horizontal elasticity and also format trigger on the field but cant find the expected output.... How can i achieve the same...
1 problem regarding to oracle report 6i.
I have to hide a repeating frame based on different condition
like DEPTCODE = 1 THEN
return('true');
else
return('true');
end if;
there is 4 record when we select DEPTCODE = 1 and there is 25 records when we select DEPTCODE = 2
now my problem is when I choose DEPTCODE=1 the summary of that report like sum of sal, avg of comm is calculated based in all 29 records.
it happen because of all the summary column is placehoder column not CS.
the calculation of all placehoder column is complex I cant convert it in simple CS.
so how can it possible when i choose DEPTCODE=1 and it shows me summary of only 4 records.???
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 RelatedI want to design a report in different numeral(English,Arabic). I am using application server as a middle tier.
Like
empno name salary english salary arabic
34232 John 5000 in arabic digits
45454 Clark 6500 in arabic digits
I have already change environment as a parameter Eng to Arb or vice versa. but i need both language digits at a time.
I have wrote this code behind a formula column which take the image from a server. The name of the image and location is carried out from database. When ever there is new record new name of the image is posted in this formula column. But when the file is not present in the location it gives error. When the error occur i cant able to view the report. The error says 'You cant run the report without layout'. When all images are present in the directory then report runs fine.
function CF_QID_IMAGE return Char is
l_file_exists BOOLEAN;
l_file_len NUMBER;
l_blocksize BINARY_INTEGER;
image_link varchar2(50);
[code]...
I am facing a problem in leave_form report! want to show employee's previous leaves detail (leavedate,leavetype), i don't want to show leavetype 'PPP' repeating frame type is Across/Down, there are 22 records of leavetype 'PPP' and one record of leavetype 'CL'
problem is report is showing 22 records of leavetype 'CL' of same leavedate!
i want that report should show the actual leavedate and leavetype records.using 9i database 6i developer server2003
For leavetype
FUNCTION Cf_1formula
RETURN CHAR
IS
v_leavetype CHAR(40);
BEGIN
SELECT LT.description
INTO v_leavetype
FROM hrm_attendance L,
hrm_leavetype LT,
hrm_employees E
[code]....
