Closed jobs

Yahoo Archive
1
Sorry about my last post, I am using Crystal Reports. If you are
using Progress Report Builder then I beleive the correct syntax is:

Jobhead.jobclosed="closed"
or
Jobhead.jobclosed="open"

The best way to find out what Vantage expects to see in a formula is
to print a simple report using the fields from the formula to see
what Vantage has used in the DB. The data dictionary is not always
accurate.

-----Original Message-----
From: Marites Marlar [mailto:mmarlar@s...]
Sent: Monday, November 13, 2000 3:33 PM
To: vantage@egroups.com
Subject: [Vantage] Closed jobs


Hello, I have made a report using Report Builder and my boss doesn't
want
any close jobs to be shown on the report. I have filtered
Jobhead.jobclosed=No but it still keeps pulling up the close jobs. Can
anyone help?

Marites Marlar
MIS Department
SPS Non-Ferrous
(702) 262-9922 ext. 118
2
Hello, I have made a report using Report Builder and my boss doesn't want
any close jobs to be shown on the report. I have filtered
Jobhead.jobclosed=No but it still keeps pulling up the close jobs. Can
anyone help?

Marites Marlar
MIS Department
SPS Non-Ferrous
(702) 262-9922 ext. 118
3
OK, I'LL bite this time, job closed s/b=yes to eliminate closed jobs from your report.

----- Original Message -----
From: Marites Marlar
To: vantage@egroups.com
Sent: Monday, November 13, 2000 3:32 PM
Subject: [Vantage] Closed jobs


Hello, I have made a report using Report Builder and my boss doesn't want
any close jobs to be shown on the report. I have filtered
Jobhead.jobclosed=No but it still keeps pulling up the close jobs. Can
anyone help?

Marites Marlar
MIS Department
SPS Non-Ferrous
(702) 262-9922 ext. 118



eGroups Sponsor


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.)



[Non-text portions of this message have been removed]
4
Please disregard my previous message. I was thinking of something else, sorry.
----- Original Message -----
From: Marites Marlar
To: vantage@egroups.com
Sent: Monday, November 13, 2000 3:32 PM
Subject: [Vantage] Closed jobs


Hello, I have made a report using Report Builder and my boss doesn't want
any close jobs to be shown on the report. I have filtered
Jobhead.jobclosed=No but it still keeps pulling up the close jobs. Can
anyone help?

Marites Marlar
MIS Department
SPS Non-Ferrous
(702) 262-9922 ext. 118



eGroups Sponsor


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.)



[Non-text portions of this message have been removed]
5
I think you have to Jobhead.jobclosed=false

-----Original Message-----
From: Marites Marlar [mailto:mmarlar@...]
Sent: Monday, November 13, 2000 3:33 PM
To: vantage@egroups.com
Subject: [Vantage] Closed jobs


Hello, I have made a report using Report Builder and my boss doesn't want
any close jobs to be shown on the report. I have filtered
Jobhead.jobclosed=No but it still keeps pulling up the close jobs. Can
anyone help?

Marites Marlar
MIS Department
SPS Non-Ferrous
(702) 262-9922 ext. 118




eGroups Sponsor
<http://click.egroups.com/1/9642/5/_/411782/_/974151374/>


<http://adimg.egroups.com/img/9642/5/_/411782/_/974151374/TargetInvestments4
68x602F.gif>

We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
<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.)
6
Try using

Use Jobhead.jobclosed=1

Vantage used numbers to represent closed and open jobs.
0=open 1=closed

The best way to find out what Vantage expects to see in a formula is
to print a simple report using the fields from the formula to see
what Vantage has used in the DB. The data dictionary is not always
accurate.

-----Original Message-----
From: Marites Marlar [mailto:mmarlar@...]
Sent: Monday, November 13, 2000 3:33 PM
To: vantage@egroups.com
Subject: [Vantage] Closed jobs


Hello, I have made a report using Report Builder and my boss doesn't
want
any close jobs to be shown on the report. I have filtered
Jobhead.jobclosed=No but it still keeps pulling up the close jobs. Can
anyone help?

Marites Marlar
MIS Department
SPS Non-Ferrous
(702) 262-9922 ext. 118