Home » Developer & Programmer » Reports & Discoverer » years of data
years of data [message #196701] Fri, 06 October 2006 10:25 Go to next message
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 Go to previous message
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member

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.

Previous Topic: Strange Problem on Printing
Next Topic: problem in removing spaces
Goto Forum:

Current Time: Thu Aug 17 10:30:40 CDT 2017

Total time taken to generate the page: 0.11980 seconds