Crystal Reports and Sequence Num Printer

Yahoo Archive
1
You should be able to use a running total field and set it to 'count'
instead of 'sum' (or whatever the default is).

On Fri, May 25, 2012 at 7:48 PM, Miguel Santillan <msantillan@...>wrote:

> **
>
>
> Maybe someone can help.
>
> I have a BAQ Report Designer and I need to print 30 labels. But I want
> each label to print the label # it is. 30 is the Prod Qty
>
> Example:
>
> Label 1
> {
> Printed#1
> JobNumA PartNumA
> MtlPartNumA RevA
> }
>
> Label 2
> {
> Printed#2
> JobNumA PartNumA
> MtlPartNumA RevA
> }
>
> Label 29
> {
> Printed#29
> JobNumA PartNumA
> MtlPartNumA RevA
> }
>
> Label 30
> {
> Printed#30
> JobNumA PartNumA
> MtlPartNumA RevA
> }
>
> [Non-text portions of this message have been removed]
>
>
>



--
*John Driggers*
*High End Dev, System Design, Profit Drinking*
*
**:: 904.404.9233*
*:: waffqle@...*
*:: NO FAXES*

*

*


[Non-text portions of this message have been removed]
2
I'm looking to see if anyone knows how to nest 2 subreports within a primary report.

What I'm trying to do in Vantage 6.1. I want to create an invoice and print the Job Operation and Material data in a tree indented view.

Example:
Invoice line 1 detail
Job Operation 10 Detail
Job Material 10 Detail related to Job Operation 10
Job Material 20 Detail related to Job Operation 10
Job Material 30 Detail related to Job Operation 10
Job Operation 20 Detail
Job Operation 30 Detail
Job Material 10 Detail related to Job Operation 30
Job Material 20 Detail related to Job Operation 30
Job Material 30 Detail related to Job Operation 30
Job Operation 40 Detail

Thanks
Joe Sanders
Wipaire, Inc.
jsanders@...


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

You cannot have nested subreports. (subreport that calls a subreport)
YOu can get around this by calling the same table and writing a formula or writing an SQL statement and filtering.

For example I wrote a report that pulls all the material for a job that was several BOM levels deep. To do this i linked the jobasm table to itself several times and then filtered.

Some questions based on what your asking.... Are you assuming there will only be 1 invoice for the job? if there are multiple invoices do you just want to print the same operation/detail on every invoice? Are you using only 1 assembly or do you need to pull data from several BOM levels deep?




--- In vantage@yahoogroups.com, Vantage <vantage@...> wrote:
>
> I'm looking to see if anyone knows how to nest 2 subreports within a primary report.
>
> What I'm trying to do in Vantage 6.1. I want to create an invoice and print the Job Operation and Material data in a tree indented view.
>
> Example:
> Invoice line 1 detail
> Job Operation 10 Detail
> Job Material 10 Detail related to Job Operation 10
> Job Material 20 Detail related to Job Operation 10
> Job Material 30 Detail related to Job Operation 10
> Job Operation 20 Detail
> Job Operation 30 Detail
> Job Material 10 Detail related to Job Operation 30
> Job Material 20 Detail related to Job Operation 30
> Job Material 30 Detail related to Job Operation 30
> Job Operation 40 Detail
>
> Thanks
> Joe Sanders
> Wipaire, Inc.
> jsanders@...
>
>
> [Non-text portions of this message have been removed]
>
4
Maybe someone can help.

I have a BAQ Report Designer and I need to print 30 labels. But I want each label to print the label # it is. 30 is the Prod Qty

Example:

Label 1
{
Printed#1
JobNumA PartNumA
MtlPartNumA RevA
}

Label 2
{
Printed#2
JobNumA PartNumA
MtlPartNumA RevA
}


Label 29
{
Printed#29
JobNumA PartNumA
MtlPartNumA RevA
}

Label 30
{
Printed#30
JobNumA PartNumA
MtlPartNumA RevA
}



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