Re: calculated columns in Discoverer

I'm afraid there are only work-arounds or tricks.

With Discoverer 3.0.8 you must created a view in your database which contains the SQL-statement. After this, you can create a folder in a business area, which will be based on the database view. In the user edition you can make a workbook based on this folder.

With Discoverer 3.1 you can create a custom folder (insert - folder - custom), which will let you enter almost any valid select-statement. Enter your select-statement and create a workbook in the user edition based on this custom folder.

Hope this helps

Jac.

kslea_at_my-dejanews.com wrote in message <734cuo$2g6$1_at_nnrp1.dejanews.com>...
>I'm trying to produce a cross-tab report in Discoverer and I am not sure
how
>to do a couple of column calculations. The report has customer name/number
>down the left hand side (the row headings), years acrossthe top (the column
>headings), and sales $ as the data points. What I need is to calculate the
>variance between various years. So the resulting report would look
something
>like:
>
> 1995 %+/- 1996 %+/- 1997 %+/- 1998
>cust1
>cust2
>
>
>I can create this report in SQL with no problem, but can it be done
directly
>in Discoverer?
>
>I'd appreciate any ideas.
>
>--Kristi
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Nov 20 1998 - 22:52:22 CET