Report Builder?

Yahoo Archive
1
My join only went to JobNum and that was it. It worked. Thank you
for your help!!!

--- In vantage@yahoogroups.com, <sarah.vareschi@...> wrote:
>
> What are your joins to jobOper?
>
> I believe you should join from LaborDtl -> JobOper on Company,
JobNum,
> AssemblySeq and OprSeq
>
> <DIV><font size="1.5" face="Bookman Old
Style">______________________________________________________________
____________________________________________________
>
> This email may contain material that is confidential, privileged
and/or attorney work product for the sole use of the intended
recipient. Any review, reliance or distribution by others or
forwarding without express permission is strictly prohibited. If you
are not the intended recipient, please contact the sender and delete
all copies.
>
_____________________________________________________________________
_____________________________________________<DIV><FONT>
>
2
I'm hoping someone can help me out with this one. I am trying to calculate
the number of days between two dates on my report, in report builder. Does
anyone out there know how to accomplish this?

Kathy Hambleton
Electron Energy Corporation
3
Kathy,

I think you just have to create a calculated field with and expression of
Date1 - Date2.

Sarah
4
THANK YOU!!!!! So simple and I was making so complicated!

Kathy Hambleton
Electron Energy Corporation



-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, September 22, 2000 4:31 PM
To: vantage@egroups.com
Subject: RE: [Vantage] Report Builder ?



Kathy,

I think you just have to create a calculated field with and expression of
Date1 - Date2.

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.)
5
I am running a report generating work center efficiencies. My only
database joins are Labordtl and Jobhead. Everything is working great
except one field. I am trying to get the JobOper.ProdStandard to pull
in but everytime I join to JobOper my records repeat themselves. I
have no Grouping or Sorting. Any suggetions would be greatly
appreciated.
6
What are your joins to jobOper?

I believe you should join from LaborDtl -> JobOper on Company, JobNum,
AssemblySeq and OprSeq

<DIV><font size="1.5" face="Bookman Old Style">__________________________________________________________________________________________________________________

This email may contain material that is confidential, privileged and/or attorney work product for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies.
__________________________________________________________________________________________________________________<DIV><FONT>