One uses the custom calc'd field called Report-Filter with calculation
REPORT-FILTER() in order to print filters at the top of a report. How do
you print custom calculations? I have browsed everything (that I thought
was) applicable in Help, but to no avail. Any "professional" report
builders out there?

Dan Maddox
Pactiv Corp
Specialty Products Group-Molded Fibre Engineering
(207) 756-6448

How do you print the expression itself? There are about a dozen calculated
fields in a report I'm working on. One looks like this:

iif(JobAsmbl.AssemblySeq = 0 and LLAtot > 0 , round((TLAMS + LLAMS) /
JobOper.QtyCompleted,5) , round(TLAMS / JobOper.QtyCompleted,5))

I have found it necessary to join another table, but in doing so, I have to
change the join order, and therefor have to start from scratch with the
calcs. If I can't figure out a way to have the expressions print
(somewhere), then I'll have to copy/paste every one of them to a clipboard.

At 04:42 PM 10/17/2000 -0400, you wrote:

>Hi Dan,
>
>I'm not sure what you mean by 'custom calculations'. If you make a
>calculated field, you just give the field a name and add your calc in the
>expression part. And then you just add that field to the report. Is there
>something else you are talking about?
>
>Sarah
>

Dan -

From the Report menu - choose print.
On the Print dialog window there is an option to print the
Report Specification. The report specification will detail
your calculated fields, however you will need to recreate
these when you have completed the restructuring of the
joins.

Calvin

----- Original Message -----
From: Dan Maddox <dmaddox@...>
To: <vantage@egroups.com>
Sent: Wednesday, October 18, 2000 6:40 AM
Subject: RE: [Vantage] Report Builder Question General

> How do you print the expression itself? There are about a dozen
calculated
> fields in a report I'm working on. One looks like this:
>
> iif(JobAsmbl.AssemblySeq = 0 and LLAtot > 0 , round((TLAMS + LLAMS) /
> JobOper.QtyCompleted,5) , round(TLAMS / JobOper.QtyCompleted,5))
>
> I have found it necessary to join another table, but in doing so, I have
to
> change the join order, and therefor have to start from scratch with the
> calcs. If I can't figure out a way to have the expressions print
> (somewhere), then I'll have to copy/paste every one of them to a
clipboard.
>
> At 04:42 PM 10/17/2000 -0400, you wrote:
> >Hi Dan,
> >
> >I'm not sure what you mean by 'custom calculations'. If you make a
> >calculated field, you just give the field a name and add your calc in the
> >expression part. And then you just add that field to the report. Is
there
> >something else you are talking about?
> >
> >Sarah
> >
>
>
>
>
> We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go
to www.egroups.com, login and be sure to save your password, choose My
Groups, choose Vantage, then choose Files. If you save the password, the
link above will work the next time you try it.)

In Report Builder you can print a Report Specification. This will include
all of the joins, filters, formulas, etc. contained in the report. To do
so, go to Report on the menu, select Print and in the Print drop down box,
select Report Definition.

Hope this helps,

Ted Kitch
tedkitch@...

On Wed, 18 Oct 2000 07:40:31 -0400, vantage@egroups.com wrote:

> How do you print the expression itself? There are about a dozen
calculated
> fields in a report I'm working on. One looks like this:
>
> iif(JobAsmbl.AssemblySeq = 0 and LLAtot > 0 , round((TLAMS + LLAMS) /
> JobOper.QtyCompleted,5) , round(TLAMS / JobOper.QtyCompleted,5))
>
> I have found it necessary to join another table, but in doing so, I have
to
> change the join order, and therefor have to start from scratch with the
> calcs. If I can't figure out a way to have the expressions print
> (somewhere), then I'll have to copy/paste every one of them to a
clipboard.
>
> At 04:42 PM 10/17/2000 -0400, you wrote:
> >Hi Dan,
> >
> >I'm not sure what you mean by 'custom calculations'. If you make a
> >calculated field, you just give the field a name and add your calc in
the
> >expression part. And then you just add that field to the report. Is
there
> >something else you are talking about?
> >
> >Sarah
> >
>
>

Ted Kitch
tedkitch@...

_______________________________________________________
Say Bye to Slow Internet!
http://www.home.com/xinbox/signup.html

Bless you, Calvin.

At 07:37 AM 10/18/2000 -0500, you wrote:

>Dan -
>
> From the Report menu - choose print.
>On the Print dialog window there is an option to print the
>Report Specification. The report specification will detail
>your calculated fields, however you will need to recreate
>these when you have completed the restructuring of the
>joins.
>
>Calvin