Crystal Traveller Question

Yahoo Archive
1
Firstly - thanks to you all - what a great group.

I managed to crack the problem today. A big thanks for all the different ideas.

In the end:

I used a userinteger1 field on the part master table to store the quantity of each sub lot.

I added another grouping level based on the table I used to generate the duplicate data (thanks for the idea), added some extra fields to new tables that contained the data I needed and linked these to the existing tables to provide a better split of the record data.

Then added some formula fields and conditional suppression.

Then Hey Presto. I have a job traveller report that prints 1 material request and multiple sequenced travellers number ordered with corrected operation quanities - just need to tidy it up and document how I made it in case I have to go back - It was pretty intense for a newbie!!

Thanks everyone


--- In vantage@yahoogroups.com, "Mark Wonsil" <mark_wonsil@...> wrote:
>
> Chris wrote:
> > Are you open to changing your job structure? I was just
> > thinking if you set your job up putting your final part in as
> > subassemblies multiple times, you could just have it print
> > each assembly on a different page and achieve the desire
> > result without any fancy CR magic. I haven't tested so unsure
> > if it would work but might be worth a try if the extra BOM
> > layer change would work in your process.
> >
> > e.g.
> > Asm 0: PartX Batches (whatever you want to call it) Qty: 1 Asm 1:
> > PartX Qty: 100 Asm 2: PartX Qty: 100
> > etc...
> >
>
> I was thinking the same way as Chris. Do all parts ship together or in
> batches as well?
>
> Mark W.
>
2
Calling all Crystal Gurus.

I wish to make a batch of 1000 components, however, I move the components around the shop floor in piles of 100.

I would like to have a traveller for each pile, and a numbering system on the traveller that reflects the order in which the batch has been manufactured.

So each traveller would say traveller 1 of 10, traveller 2 of 10, etc.

I would like this to be automatic so I just print the job traveller report once and the report looks at how many items I am producing, and prints and marks the corresponding number of travellers.

I realise I will need a custom field to store a value I shall call for now, a "lot partition" or lotpart. So total qty / lotpart = no of required travellers.

How do I get crystal to produce what is effectively the same traveller multiple times with the previously mentioned order of manufacture indicator - 1 of 10, 2 of 10 etc???
3
This is a bit of a snafu, but it will work.

Get your query together and then join in a table, like employee, that you
know will have a good number of rows, but not too many (because we
essentially want to create duplicates on purpose).

Now, figure out how many duplicate pages you want to print and suppress
anything with PageNumber > <number of duplicates>

The page number <page n of m> should take care of your naming convention.
You'll also have to do a calculation for the number of parts in the event
the total number isn't evenly divisible.



Any other ideas?

--Sean



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
sbser2000
Sent: Tuesday, August 04, 2009 1:10 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Traveller Question





Calling all Crystal Gurus.

I wish to make a batch of 1000 components, however, I move the components
around the shop floor in piles of 100.

I would like to have a traveller for each pile, and a numbering system on
the traveller that reflects the order in which the batch has been
manufactured.

So each traveller would say traveller 1 of 10, traveller 2 of 10, etc.

I would like this to be automatic so I just print the job traveller report
once and the report looks at how many items I am producing, and prints and
marks the corresponding number of travellers.

I realise I will need a custom field to store a value I shall call for now,
a "lot partition" or lotpart. So total qty / lotpart = no of required
travellers.

How do I get crystal to produce what is effectively the same traveller
multiple times with the previously mentioned order of manufacture indicator
- 1 of 10, 2 of 10 etc???





[Non-text portions of this message have been removed]
4
Today I added the tables I needed to the report data definition and generated the XML which contained suitable data.

However, being a crystal novice, the design of the standard job traveller is quite complex.

I generated duplicate operation records as per your suggestion.

Now I need separate the repeated operations onto a new page each time, currently they just start again immediately after the last operation until the page is full.

All ideas gratefully accepted.

--- In vantage@yahoogroups.com, "Sean McDaniel" <smcdanie@...> wrote:
>
> This is a bit of a snafu, but it will work.
>
> Get your query together and then join in a table, like employee, that you
> know will have a good number of rows, but not too many (because we
> essentially want to create duplicates on purpose).
>
> Now, figure out how many duplicate pages you want to print and suppress
> anything with PageNumber > <number of duplicates>
>
> The page number <page n of m> should take care of your naming convention.
> You'll also have to do a calculation for the number of parts in the event
> the total number isn't evenly divisible.
>
>
>
> Any other ideas?
>
> --Sean
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> sbser2000
> Sent: Tuesday, August 04, 2009 1:10 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal Traveller Question
>
>
>
>
>
> Calling all Crystal Gurus.
>
> I wish to make a batch of 1000 components, however, I move the components
> around the shop floor in piles of 100.
>
> I would like to have a traveller for each pile, and a numbering system on
> the traveller that reflects the order in which the batch has been
> manufactured.
>
> So each traveller would say traveller 1 of 10, traveller 2 of 10, etc.
>
> I would like this to be automatic so I just print the job traveller report
> once and the report looks at how many items I am producing, and prints and
> marks the corresponding number of travellers.
>
> I realise I will need a custom field to store a value I shall call for now,
> a "lot partition" or lotpart. So total qty / lotpart = no of required
> travellers.
>
> How do I get crystal to produce what is effectively the same traveller
> multiple times with the previously mentioned order of manufacture indicator
> - 1 of 10, 2 of 10 etc???
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
5
Hi,

If you can send me your XML data file and RPT, I'd be happy to take a look.

I imagine that you need to go into the section expert on one of your groups
and check the "New page After/Before" checkbox.

smcdaniel@...

--Sean



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
sbser2000
Sent: Wednesday, August 05, 2009 4:11 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Traveller Question - the next problem for the
Crystal Gurus





Today I added the tables I needed to the report data definition and
generated the XML which contained suitable data.

However, being a crystal novice, the design of the standard job traveller is
quite complex.

I generated duplicate operation records as per your suggestion.

Now I need separate the repeated operations onto a new page each time,
currently they just start again immediately after the last operation until
the page is full.

All ideas gratefully accepted.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Sean
McDaniel" <smcdanie@...> wrote:
>
> This is a bit of a snafu, but it will work.
>
> Get your query together and then join in a table, like employee, that you
> know will have a good number of rows, but not too many (because we
> essentially want to create duplicates on purpose).
>
> Now, figure out how many duplicate pages you want to print and suppress
> anything with PageNumber > <number of duplicates>
>
> The page number <page n of m> should take care of your naming convention.
> You'll also have to do a calculation for the number of parts in the event
> the total number isn't evenly divisible.
>
>
>
> Any other ideas?
>
> --Sean
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
> sbser2000
> Sent: Tuesday, August 04, 2009 1:10 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Crystal Traveller Question
>
>
>
>
>
> Calling all Crystal Gurus.
>
> I wish to make a batch of 1000 components, however, I move the components
> around the shop floor in piles of 100.
>
> I would like to have a traveller for each pile, and a numbering system on
> the traveller that reflects the order in which the batch has been
> manufactured.
>
> So each traveller would say traveller 1 of 10, traveller 2 of 10, etc.
>
> I would like this to be automatic so I just print the job traveller report
> once and the report looks at how many items I am producing, and prints and
> marks the corresponding number of travellers.
>
> I realise I will need a custom field to store a value I shall call for
now,
> a "lot partition" or lotpart. So total qty / lotpart = no of required
> travellers.
>
> How do I get crystal to produce what is effectively the same traveller
> multiple times with the previously mentioned order of manufacture
indicator
> - 1 of 10, 2 of 10 etc???
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
6
Go into the report, section expert...Find the detail section (if that is
where you are printing each record) and check the box for new page
after...



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of sbser2000
Sent: Wednesday, August 05, 2009 3:11 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Traveller Question - the next problem for
the Crystal Gurus





Today I added the tables I needed to the report data definition and
generated the XML which contained suitable data.

However, being a crystal novice, the design of the standard job
traveller is quite complex.

I generated duplicate operation records as per your suggestion.

Now I need separate the repeated operations onto a new page each time,
currently they just start again immediately after the last operation
until the page is full.

All ideas gratefully accepted.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Sean McDaniel" <smcdanie@...> wrote:
>
> This is a bit of a snafu, but it will work.
>
> Get your query together and then join in a table, like employee, that
you
> know will have a good number of rows, but not too many (because we
> essentially want to create duplicates on purpose).
>
> Now, figure out how many duplicate pages you want to print and
suppress
> anything with PageNumber > <number of duplicates>
>
> The page number <page n of m> should take care of your naming
convention.
> You'll also have to do a calculation for the number of parts in the
event
> the total number isn't evenly divisible.
>
>
>
> Any other ideas?
>
> --Sean
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
> sbser2000
> Sent: Tuesday, August 04, 2009 1:10 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Crystal Traveller Question
>
>
>
>
>
> Calling all Crystal Gurus.
>
> I wish to make a batch of 1000 components, however, I move the
components
> around the shop floor in piles of 100.
>
> I would like to have a traveller for each pile, and a numbering system
on
> the traveller that reflects the order in which the batch has been
> manufactured.
>
> So each traveller would say traveller 1 of 10, traveller 2 of 10, etc.
>
> I would like this to be automatic so I just print the job traveller
report
> once and the report looks at how many items I am producing, and prints
and
> marks the corresponding number of travellers.
>
> I realise I will need a custom field to store a value I shall call for
now,
> a "lot partition" or lotpart. So total qty / lotpart = no of required
> travellers.
>
> How do I get crystal to produce what is effectively the same traveller
> multiple times with the previously mentioned order of manufacture
indicator
> - 1 of 10, 2 of 10 etc???
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
7
Are you open to changing your job structure? I was just thinking if you set your job up putting your final part in as subassemblies multiple times, you could just have it print each assembly on a different page and achieve the desire result without any fancy CR magic. I haven't tested so unsure if it would work but might be worth a try if the extra BOM layer change would work in your process.

e.g.
Asm 0: PartX Batches (whatever you want to call it) Qty: 1
Asm 1: PartX Qty: 100
Asm 2: PartX Qty: 100
etc...


--- In vantage@yahoogroups.com, "sbser2000" <ian.stockbridge@...> wrote:
>
> Calling all Crystal Gurus.
>
> I wish to make a batch of 1000 components, however, I move the components around the shop floor in piles of 100.
>
> I would like to have a traveller for each pile, and a numbering system on the traveller that reflects the order in which the batch has been manufactured.
>
> So each traveller would say traveller 1 of 10, traveller 2 of 10, etc.
>
> I would like this to be automatic so I just print the job traveller report once and the report looks at how many items I am producing, and prints and marks the corresponding number of travellers.
>
> I realise I will need a custom field to store a value I shall call for now, a "lot partition" or lotpart. So total qty / lotpart = no of required travellers.
>
> How do I get crystal to produce what is effectively the same traveller multiple times with the previously mentioned order of manufacture indicator - 1 of 10, 2 of 10 etc???
>
8
Chris wrote:
> Are you open to changing your job structure? I was just
> thinking if you set your job up putting your final part in as
> subassemblies multiple times, you could just have it print
> each assembly on a different page and achieve the desire
> result without any fancy CR magic. I haven't tested so unsure
> if it would work but might be worth a try if the extra BOM
> layer change would work in your process.
>
> e.g.
> Asm 0: PartX Batches (whatever you want to call it) Qty: 1 Asm 1:
> PartX Qty: 100 Asm 2: PartX Qty: 100
> etc...
>

I was thinking the same way as Chris. Do all parts ship together or in
batches as well?

Mark W.