Home » Developer & Programmer » Reports & Discoverer » page item (disc 10.1.2)
page item [message #315761] Tue, 22 April 2008 12:26 Go to next message
aarti81
Messages: 235
Registered: December 2007
Location: USA
Senior Member
Hi All
I have a cross tab report and on the left axis , i have a field "county" and on the top axis i have two fields "month income" year income".I have to show only counties which have "month income".My question how can i create a new page item which has "No"
"Yes"
"All"
In the drop down box, so that the end useer can choose .Please any kind of help is greatly appreciated.
Thanks
Re: page item [message #315926 is a reply to message #315761] Wed, 23 April 2008 04:41 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
What do you want the choices to be? I mean, if a user chooses yes (or no), what should happen?
Re: page item [message #315994 is a reply to message #315926] Wed, 23 April 2008 07:54 Go to previous messageGo to next message
aarti81
Messages: 235
Registered: December 2007
Location: USA
Senior Member
When they choose yes

it will show all the counties with the monthly income

choose no
shows the counties with yearly income

all shows
all monthly/yearly

THANKS
Re: page item [message #316028 is a reply to message #315994] Wed, 23 April 2008 09:09 Go to previous message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
Okay. You might do something like:
create a calculation on the resultrows with a decode (or case when) statement which determines if a certain county has yearly or monthly figures (or both). Then move that calculation to page item.
Previous Topic: Non Unique
Next Topic: unable to pass flexfield values from report wrapper to oracle applications seeded report
Goto Forum:
  


Current Time: Thu Dec 08 18:11:39 CST 2016

Total time taken to generate the page: 0.06467 seconds