Adam,
Thank you for the reply.
To simplify the matters I just mentioned 4 records, but it may have as many
as 20 inv. numbers.
I am almost done with writing a Visual Basic program to pull the customer
invoices that are shipped to Canada the same day. The program works with up
to 12 inv.# on "Canada Customs Invoice - CI1" form. If more than 12 it will
print to the next page and that's when things get complicated.
After doing some research I think using a subreport or running total is the
answer. Just wanted to verify it with the group if I was on the right track.
Mike Tonoyan / All American Products Co.
e-mail: miket@...
Thank you for the reply.
To simplify the matters I just mentioned 4 records, but it may have as many
as 20 inv. numbers.
I am almost done with writing a Visual Basic program to pull the customer
invoices that are shipped to Canada the same day. The program works with up
to 12 inv.# on "Canada Customs Invoice - CI1" form. If more than 12 it will
print to the next page and that's when things get complicated.
After doing some research I think using a subreport or running total is the
answer. Just wanted to verify it with the group if I was on the right track.
Mike Tonoyan / All American Products Co.
e-mail: miket@...
----- Original Message -----
From: "Adam Ellis" <aellis@...>
To: "Vantage Mailing List" <vantage@yahoogroups.com>
Sent: Tuesday, February 24, 2004 9:00 AM
Subject: Re: [Vantage] [OT] Crystal Reports - Page Footer
> Mike,
>
> On Mon, 2004-02-23 at 15:12, Mike Tonoyan wrote:
> > I am wondering if there is easy a way to do the following in
> > Crystal Reports.
> > In the detail area Invoice numbers are shown as a list:
> > Detail section: 285445
> > 285986
> > 285987
> > 285988
> > In the page footer area need to append them and break them down into
> > two lines of text
> > Page Footer:
> > line_1: 285445; 285986
> > line_2: 285987; 285988
> >
> > I am using the following formula, which is showing the entire list
> > as one line:
> > Stringvar Inv_Num;
> > Inv_Num := Inv_Num + "; " + ToText({CustInfo_Table.InvoiceNum});
>
> Could you just format the detail sections with multiple columns (4 inches
wide, print across then down)? If it needs to be in the footer, then maybe
use a subreport? If either of those options are good for you, you can
always just store carriage returns in string variables like so:
>
> Inv_Num := Inv_Num + "; " + ToText({CustInfo_Table.InvoiceNum}) +
> Chr(13);
>
> Hope this helps,
> --
> Adam Ellis <aellis@...>
> SaberLogic
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
>
>
>
>