Home » Developer & Programmer » Reports & Discoverer » How to do this - Newbie ??
How to do this - Newbie ?? [message #88945] Mon, 30 June 2003 08:53 Go to next message
michelle
Messages: 19
Registered: August 1999
Junior Member
I have a table that has one record for each month.

My report will show this month's data, this month a year ago and YTD data. In a table type format.

What is the best way to do this? I've managed to get myself quite confused.
Thanks
Re: How to do this - Newbie ?? [message #88953 is a reply to message #88945] Mon, 07 July 2003 01:48 Go to previous message
sujit
Messages: 94
Registered: April 2002
Member
hi,
you can do it by using self-join query. alternative way is to use formula columns(easier way), but i do believe that the use of formula columns will slow up data. Try it your own.
Sujit
Previous Topic: problem with system parameters
Next Topic: sum a varchar2 field in report builder
Goto Forum:
  


Current Time: Fri Apr 19 11:11:34 CDT 2024