Crystal Report XI Array Help Needed

Yahoo Archive
1
Jennifer,

I have implemented your fix. You are awesome! Thank you so much for this help. I owe you big!

Respectfully,

Rob

--- In vantage@yahoogroups.com, "Lisser, Jennifer" <Jennifer.Lisser@...> wrote:
>
> Rob,
>
> It sounds like you have JobNum as your top group with your op codes as
> individual records beneath JobNum. In order to have them appear in 1
> string you'll have to use a variable and 'while printing records'. If
> the report can contain several job numbers, then you'll have to reset
> the string too.
>
>
>
> CREATE LIST - put at the same level as OpCode variables appear
>
> whileprintingrecords;
>
> stringVar Item:= {TABLE.OpCode} ;
>
> stringVar Chain;
>
> NumberVar ChCnt;
>
>
>
> if Chain = '' then
>
> chain := 'Job: ' + {TABLE.JobNum} + 'Process: ' + Item
>
> else
>
> chain := chain + '-' + Item
>
>
>
> DISPLAY LIST - Put where you want this to display, needs to go after all
> the OpCodes would be defined (e.g. footer section)
>
> WhilePrintingRecords;
>
> StringVar Chain
>
>
>
> RESET LIST - Put in the section after the display (e.g. job num group
> header so it resets with each new job num)
>
> WhilePrintingRecords;
>
> StringVar chain := '';
>
> Jennifer Lisser
> Business Analyst
> Dorner Mfg. Corp.
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
2
I want to display my JobOper.OpCode in a single field location so that it can create a process code from me. For instance:

Grouped by JobNum
Where AssemblySeq = 0

varl= (OpCode = S)
var2= (OpCode = L)
var3= (OpCode = U)
var4= (OpCode = T)
var5= (OpCode = O)

Would like it to display as this: Job: 1234 Process: U-S-O

I can make a list no problem, but need help getting it in this order.

Email me at rob@...

Thanks! :-)

Rob
3
Just drag the fields into a text box, add text as needed



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
robrodriguez_livoniatool
Sent: Tuesday, March 16, 2010 11:01 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Report XI Array Help Needed





I want to display my JobOper.OpCode in a single field location so that it
can create a process code from me. For instance:

Grouped by JobNum
Where AssemblySeq = 0

varl= (OpCode = S)
var2= (OpCode = L)
var3= (OpCode = U)
var4= (OpCode = T)
var5= (OpCode = O)

Would like it to display as this: Job: 1234 Process: U-S-O

I can make a list no problem, but need help getting it in this order.

Email me at rob@... <mailto:rob%40livoniatool.com>

Thanks! :-)

Rob





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

Maybe I'm missing your point, but I believe that would pull in the first variable only since they all are coming JobOper.Opcode field. What I'd like to do is list all of these job operation codes in a list like this: "U-D-S-O"

instead of
U
D
S
O

I'd like to embed this into an existing report to help my production staff.

Rob

--- In vantage@yahoogroups.com, "Sean McDaniel" <smcdanie@...> wrote:
>
> Just drag the fields into a text box, add text as needed
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> robrodriguez_livoniatool
> Sent: Tuesday, March 16, 2010 11:01 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal Report XI Array Help Needed
>
>
>
>
>
> I want to display my JobOper.OpCode in a single field location so that it
> can create a process code from me. For instance:
>
> Grouped by JobNum
> Where AssemblySeq = 0
>
> varl= (OpCode = S)
> var2= (OpCode = L)
> var3= (OpCode = U)
> var4= (OpCode = T)
> var5= (OpCode = O)
>
> Would like it to display as this: Job: 1234 Process: U-S-O
>
> I can make a list no problem, but need help getting it in this order.
>
> Email me at rob@... <mailto:rob%40livoniatool.com>
>
> Thanks! :-)
>
> Rob
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
5
Rob,

I believe the best way to do this is creating a formula field in
Crystal. There are a couple of different ways to do it by either
writing an "if" statement or a case statement. Place the result of this
formula field into a text box on the report.



Tim Dines

Information Technology

Steel Parts Manufacturing, Inc.

801 Berryman Pike

Tipton, IN 46072

Direct: 765-675-5201

Cell: 765-437-1402



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of robrodriguez_livoniatool
Sent: Tuesday, March 16, 2010 11:53 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Report XI Array Help Needed





Sean,

Maybe I'm missing your point, but I believe that would pull in the first
variable only since they all are coming JobOper.Opcode field. What I'd
like to do is list all of these job operation codes in a list like this:
"U-D-S-O"

instead of
U
D
S
O

I'd like to embed this into an existing report to help my production
staff.

Rob

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Sean McDaniel" <smcdanie@...> wrote:
>
> Just drag the fields into a text box, add text as needed
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
> robrodriguez_livoniatool
> Sent: Tuesday, March 16, 2010 11:01 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Crystal Report XI Array Help Needed
>
>
>
>
>
> I want to display my JobOper.OpCode in a single field location so that
it
> can create a process code from me. For instance:
>
> Grouped by JobNum
> Where AssemblySeq = 0
>
> varl= (OpCode = S)
> var2= (OpCode = L)
> var3= (OpCode = U)
> var4= (OpCode = T)
> var5= (OpCode = O)
>
> Would like it to display as this: Job: 1234 Process: U-S-O
>
> I can make a list no problem, but need help getting it in this order.
>
> Email me at rob@... <mailto:rob%40livoniatool.com>
>
> Thanks! :-)
>
> Rob
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





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

It sounds like you have JobNum as your top group with your op codes as
individual records beneath JobNum. In order to have them appear in 1
string you'll have to use a variable and 'while printing records'. If
the report can contain several job numbers, then you'll have to reset
the string too.



CREATE LIST - put at the same level as OpCode variables appear

whileprintingrecords;

stringVar Item:= {TABLE.OpCode} ;

stringVar Chain;

NumberVar ChCnt;



if Chain = '' then

chain := 'Job: ' + {TABLE.JobNum} + 'Process: ' + Item

else

chain := chain + '-' + Item



DISPLAY LIST - Put where you want this to display, needs to go after all
the OpCodes would be defined (e.g. footer section)

WhilePrintingRecords;

StringVar Chain



RESET LIST - Put in the section after the display (e.g. job num group
header so it resets with each new job num)

WhilePrintingRecords;

StringVar chain := '';

Jennifer Lisser
Business Analyst
Dorner Mfg. Corp.







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

I believe you have hit on my request exactly.

Thank you very much!

Rob

--- In vantage@yahoogroups.com, "Lisser, Jennifer" <Jennifer.Lisser@...> wrote:
>
> Rob,
>
> It sounds like you have JobNum as your top group with your op codes as
> individual records beneath JobNum. In order to have them appear in 1
> string you'll have to use a variable and 'while printing records'. If
> the report can contain several job numbers, then you'll have to reset
> the string too.
>
>
>
> CREATE LIST - put at the same level as OpCode variables appear
>
> whileprintingrecords;
>
> stringVar Item:= {TABLE.OpCode} ;
>
> stringVar Chain;
>
> NumberVar ChCnt;
>
>
>
> if Chain = '' then
>
> chain := 'Job: ' + {TABLE.JobNum} + 'Process: ' + Item
>
> else
>
> chain := chain + '-' + Item
>
>
>
> DISPLAY LIST - Put where you want this to display, needs to go after all
> the OpCodes would be defined (e.g. footer section)
>
> WhilePrintingRecords;
>
> StringVar Chain
>
>
>
> RESET LIST - Put in the section after the display (e.g. job num group
> header so it resets with each new job num)
>
> WhilePrintingRecords;
>
> StringVar chain := '';
>
> Jennifer Lisser
> Business Analyst
> Dorner Mfg. Corp.
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>