| years of data [message #196701] |
Fri, 06 October 2006 10:25  |
PRGMER
Messages: 5
Registered: June 2006
|
Junior Member |
|
|
|
hi folks: new to discoverer...trying to write a discoverer report that prints current year and three previous years data..how do i tell discoverer what to do?after selecting fields from tables and creating conditions,what do i do next?do i create a calculation?how would i tell discoverer to get the three previous years.tax year is entered using a parameter..all help would be appreciated
|
|
|
|
| Re: years of data [message #197005 is a reply to message #196701] |
Mon, 09 October 2006 08:51  |
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
|
Senior Member |
|
|
Hi,
It depends a bit on the definition of the tax-year item, assuming that it's a varchar2, this should work:
- create a condition on tax-year
- enter for the condition:
tax-year between :p_taxyear - 3 and :p_taxyear
where p_taxyear is the exisiting parameter on tax year (if there is a condition using this parameter already, you should alter that like stated above, instead of creating a new one).
If tax year is date field, let me know, then there is another solution.
Regards,
Sabine
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
