OraFAQ Forum: Reports & Discoverer » ORACLE REPORT PLACEHODER COLUMN (merged 2)

Home » Developer & Programmer » Reports & Discoverer » ORACLE REPORT PLACEHODER COLUMN (merged 2) (D2K 6i, Oracle Database 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORACLE REPORT PLACEHODER COLUMN (merged 2) [message #558235]

Wed, 20 June 2012 06:29

parthiv_t
Messages: 15
Registered: July 2011
Location: ahmedabad

Junior Member

Hello expret
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.???

Thank You.

Report message to a moderator

Re: ORACLE REPORT PLACEHODER COLUMN [message #558255 is a reply to message #558235]

Wed, 20 June 2012 07:14

cookiemonster
Messages: 13958
Registered: September 2008
Location: Rainy Manchester

Senior Member

If you don't want to display the records where deptcode =2 and you don't want to include their values in the summary, why are you selecting them at all?

EDIT: wrong deptcode

[Updated on: Wed, 20 June 2012 07:16]

Report message to a moderator

Re: ORACLE REPORT PLACEHODER COLUMN [message #558320 is a reply to message #558255]

Wed, 20 June 2012 15:40

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Additionally: if you know - in advance - which DEPTCODES you'll want to display in a report (how? Via parameter!), then you could include that condition into the WHERE clause. If it is rather complex - no problem either - use lexical variable.

Report message to a moderator

Re: ORACLE REPORT PLACEHODER COLUMN [message #558335 is a reply to message #558320]

Wed, 20 June 2012 23:02

parthiv_t
Messages: 15
Registered: July 2011
Location: ahmedabad

Junior Member

Actully Deptcode=1 is only for example

in My Report the formula function named Revice_service which is return

12-11
23-130

in lots of cases its null

now I had created a parameter in Report builder named 'P_reap'

now P_reap = 'Service' or P_reap ='Non-service'

if I Select P_reap='Service' then in report
shows records only for Revice_service function which values is not null

its showing successfully with the help of conditional formatting of Repeating Frame.

but at summary there is no CS (summary column).

but it is a placeholder column which is based on calculation.

Now when i choose P_reap = 'Service' then report shows record only for
Revice_service function which values is not null.

but in summary it calculate all record
of P_reap = 'Service' and P_reap ='Non-service'

Report message to a moderator

Re: ORACLE REPORT PLACEHODER COLUMN [message #558337 is a reply to message #558335]

Thu, 21 June 2012 00:55

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'm afraid you didn't understand what I was saying.

Although you hid some records based on some conditions (and you did that in Format Trigger), these values still exist. Any calculation you do must have the same WHERE condition - otherwise, how can you expect it to return correct value?

You mentioned "revice_service function" and I got a feeling that you think that it is a cause of your problems. What prevents you to put that function into the WHERE clause? You can use functions there, don't you know that?

Report message to a moderator

Re: ORACLE REPORT PLACEHODER COLUMN [message #558343 is a reply to message #558337]

Thu, 21 June 2012 02:07

parthiv_t
Messages: 15
Registered: July 2011
Location: ahmedabad

Junior Member

Ok...

THANKS
Littelfoot

Report message to a moderator

Previous Topic:	Create Report From Cursor
Next Topic:	Columns don't align on 10g Reports off Reports Server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 01:55:15 CST 2024