| page item [message #315761] |
Tue, 22 April 2008 12:26  |
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  |
skooman
Messages: 913
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 |
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 |
skooman
Messages: 913
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
