Home > Default > Prob with formula column plz help!!!!!

Prob with formula column plz help!!!!!

November 30Hits:0
Advertisement
hi
iam working on a finance report
where there is a need for opening balance and closing balance colum, i have designed the column the out put comes but the prob is after displaying the opening balance closing balance it again displays a nil opening balance and closing balance for all the values given as input
its liek this
opening balance=0.00
closing balance=0.00
i have attached the formula which i have written pls help me wats wrong in the formula column
for opening balance
function CF_total_dr1Formula return Number is
begin
IF :cf_total_dr - :cf_total_cr > 0 THEN
RETURN(:cf_total_dr - :cf_total_cr);
ELSE
RETURN( 0 );
END IF;
end;
similarly for closing balance too

Answers

cf_total_dr is again calculated using a formula.. similarly cf_total_dr
i have specified the formula below, again this debit balance is a formula column
function CF_total_drFormula return Number is
v_bal NUMBER;
BEGIN
v_bal := debit_balance(:p_from_date);
RETURN(v_bal);
END;

Read other 8 answers

Tags:

Related Articles

  • Prob with formula column plz help!!!!!November 30

    hi iam working on a finance report where there is a need for opening balance and closing balance colum, i have designed the column the out put comes but the prob is after displaying the opening balance closing balance it again displays a nil opening

  • Function not callable in formula column..November 30

    Hi, I am getting one strange problem..when i call one function in a sql statment in report builder 6i from a formula column, it gives error that this function can not be called from sql but when i run the same sql from plsql dev, it runs fine..Oracle

  • Can we use formula column in lexical parameter in sql query ...October 11

    hi can we use formula column in lexical parameter in sql query ... as example i want to give select * from & c_table forumula function c_table if :p_sort = 1 then return 'dept' else return 'emp' end; c_table formula column is this possible ... i have

  • How to make an order on repeating frame using Formula Column?October 11

    Hi All, I have a repeating frame dependent on some query, how to make an order on this repeating frame using a formula column defined in its group and dependet on values from the query? Note: I'm using Reports 6iPlace your formula column at the top o

  • Formula Columns are not working in Reports 10gOctober 11

    Hi, We converted the reports developed in Reports 6i to Reports 10g. When we run the report in Reports 10g Builder everything works fine. But when we deploy the same report in Oracle Application Server and invoking the report the formula columns are

  • How to display a Sum field for a formula column?October 11

    Hi, I need to display a sum for a formula column at the end of report. for example: my formu_col=col_1-col_2 col_1 col_2 formu_col 3 1 2 6 5 1 total:sum(col_1) sum(col_2) sum(formu_col) now i have sum(col_1) and sum(col_2), but i don't have sum(formu

  • Using PL/SQL in a formula column in Oracle Reports Builder.October 11

    Hi, I need to SUM two record from the result of an SQL interrogation. Here's what it looks like function CF_1Formula return Number is nTot1 NUMBER :=0; nTot2 NUMBER :=0; begin      select sum(:TOT1) into nTot1 from table(Q1) ;      select sum(:TOT2)

  • How to add a formula column in a reportOctober 11

    Hi I have made a report based on a query. There are 3 columns in the query and all the 3 are displayed. Now I want to add a new column (fomula column) to the report. I want to write a query inside the formula column. To execute the query col1, col2 a

  • Formula Column help please - URGENTOctober 11

    I'm trying to create a formula column as follows: function NO_REPLIESFormula return Number is NOREPLY number; begin SELECT COUNT(reply) INTO NOREPLY FROM letters WHERE reply = 'N' GROUP BY ltrtype, batch; RETURN (NOREPLY); end; This PL/SQL compiles f

  • Formula Columns are not appearing in pdf formatOctober 11

    hi all, i have a report that contains some formula columns, the report is running correctly in the report builder, but when running the report through the web as .pdf format all report field appear except those formula columns, is there anyone who ca

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.598 s.