Crystal Reports Job Traveler

Hi,

The date formula works, but this is what happens on this one. I admit to
not having much experience on Crystal. Any help you can give me?

Thanks

Ellen





________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jennifer
Sent: Monday, April 25, 2011 8:37 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Reports Job Traveler







Ellen,
Since it's the header it will only pick up the first oper unless you use
WhilePrintingRecords;

Sample:

WhilePrintingRecords;
CStr([joboper.oprseq],0,"") & "<BR>" & CStr([joboper.startdate],
"M/dd/yy")

You may need to play with the format on the date to get it the way you
want. I don't believe you need to include CDate since the start date is
stored as datetime.

If you use the <BR> command for a new line (rather then 2 separate
formulas on different rows) you will need to format the paragraph Text
Interpretation as HTML.

Jenn

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Ellen Lensing" <ellen.lensing@...> wrote:
I am trying to modify the job traveler. All I want to do is have a row
on the job header the shows the job oper num and start date. Ok two
rows. It just repeats the first operation on each page, when I copy and
paste each formula. Tech support doesn't know, I was wondering if anyone
in the group had any experience with editing Crystal reports
Thanks
Middle West Manufacturing Corp.

Ellen Lensing
Accounting Manager
Phone 262-251-8760
Fax 262-251-8769





[Non-text portions of this message have been removed]
I am trying to modify the job traveler. All I want to do is have a row
on the job header the shows the job oper num and start date. Ok two
rows. It just repeats the first operation on each page, when I copy and
paste each formula. Tech support doesn't know, I was wondering if
anyone in the group had any experience with editing Crystal reports

Thanks





Middle West Manufacturing Corp.

Ellen Lensing

Accounting Manager

Phone 262-251-8760

Fax 262-251-8769





[Non-text portions of this message have been removed]
Ellen,
Since it's the header it will only pick up the first oper unless you use WhilePrintingRecords;

Sample:

WhilePrintingRecords;
CStr([joboper.oprseq],0,"") & "<BR>" & CStr([joboper.startdate], "M/dd/yy")

You may need to play with the format on the date to get it the way you want. I don't believe you need to include CDate since the start date is stored as datetime.

If you use the <BR> command for a new line (rather then 2 separate formulas on different rows) you will need to format the paragraph Text Interpretation as HTML.

Jenn


--- In vantage@yahoogroups.com, "Ellen Lensing" <ellen.lensing@...> wrote:
I am trying to modify the job traveler. All I want to do is have a row on the job header the shows the job oper num and start date. Ok two rows. It just repeats the first operation on each page, when I copy and paste each formula. Tech support doesn't know, I was wondering if anyone in the group had any experience with editing Crystal reports
Thanks
Middle West Manufacturing Corp.

Ellen Lensing
Accounting Manager
Phone 262-251-8760
Fax 262-251-8769
Jenn

Thanks so much.... I will give this a try. I would think the Epicor
support should know this.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jennifer
Sent: Monday, April 25, 2011 8:37 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Reports Job Traveler







Ellen,
Since it's the header it will only pick up the first oper unless you use
WhilePrintingRecords;

Sample:

WhilePrintingRecords;
CStr([joboper.oprseq],0,"") & "<BR>" & CStr([joboper.startdate],
"M/dd/yy")

You may need to play with the format on the date to get it the way you
want. I don't believe you need to include CDate since the start date is
stored as datetime.

If you use the <BR> command for a new line (rather then 2 separate
formulas on different rows) you will need to format the paragraph Text
Interpretation as HTML.

Jenn

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Ellen Lensing" <ellen.lensing@...> wrote:
I am trying to modify the job traveler. All I want to do is have a row
on the job header the shows the job oper num and start date. Ok two
rows. It just repeats the first operation on each page, when I copy and
paste each formula. Tech support doesn't know, I was wondering if anyone
in the group had any experience with editing Crystal reports
Thanks
Middle West Manufacturing Corp.

Ellen Lensing
Accounting Manager
Phone 262-251-8760
Fax 262-251-8769





[Non-text portions of this message have been removed]