Crystal Reports question

Yahoo Archive
1
I hope this is a simple question for a Crystal Guru. I'm using the Quote
form from Vantage with only minor cosmetic changes. I want the section
called " Page Header f " to start the second page instead of starting to
print on the bottom of the first page. I thought I could just specify "New
Page Before" under section formatting but I don't get that option. Is that
because it's a page header section? What am I missing?

Greg Clauser
Lakin General Corporation
gclauser@... <mailto:gclauser@...>
2
OOPS - for got to mention - version 4.00.904, Crystal 7


I hope this is a simple question for a Crystal Guru. I'm using the Quote
form from Vantage with only minor cosmetic changes. I want the section
called " Page Header f " to start the second page instead of starting to
print on the bottom of the first page. I thought I could just specify "New
Page Before" under section formatting but I don't get that option. Is that
because it's a page header section? What am I missing?

Greg Clauser
Lakin General Corporation
3
Greg:

Do you want the section "PHf" to start on page 2 because it's being broken apart and you want the whole thing on page 2? Why would the header print on the bottom of page 1? The default form has no "PHf", so is your layout radically different?

I'm asking all this to try and give you a simple solution.

Rick Gors
MR/MMIS
Osco

Greg Clauser wrote:

> I hope this is a simple question for a Crystal Guru. I'm using the Quote
> form from Vantage with only minor cosmetic changes. I want the section
> called " Page Header f " to start the second page instead of starting to
> print on the bottom of the first page. I thought I could just specify "New
> Page Before" under section formatting but I don't get that option. Is that
> because it's a page header section? What am I missing?
>
> Greg Clauser
> Lakin General Corporation
> gclauser@... <mailto:gclauser@...>
>
>
> To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


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

O.K. - I took another look at this. Yes - "PHf " is being broken apart and
that's why I want it to start on page 2. After reading what you said, I
revisited the standard Vantage quoteform. You're right, it does not have
that many PH sections...the one that's "PHf "on mine is "GH1b "on the
standard form. I think things got screwed up when I went to version 4.0
and verified the database in Crystal. I'm even having trouble starting over
with Vantage's standard form. It does not want to verify within Crystal
properly and some of the print previews look like packing slips. It's
starting to look like I'm going to have to go back to square one but I'm not
even sure how.

Greg

Greg:

Do you want the section "PHf" to start on page 2 because it's being broken
apart and you want the whole thing on page 2? Why would the header print on
the bottom of page 1? The default form has no "PHf", so is your layout
radically different?

I'm asking all this to try and give you a simple solution.

Rick Gors
MR/MMIS
Osco

Greg Clauser wrote:

> I hope this is a simple question for a Crystal Guru. I'm using the Quote
> form from Vantage with only minor cosmetic changes. I want the section
> called " Page Header f " to start the second page instead of starting to
> print on the bottom of the first page. I thought I could just specify
"New
> Page Before" under section formatting but I don't get that option. Is
that
> because it's a page header section? What am I missing?
>
> Greg Clauser
> L
5
Greg:

If you want, I can email directly to you my original and cutomized versions of the quotation form. The custom is in CR v8 however.

Please advise...

Rick

Greg Clauser wrote:

> Rick,
>
> O.K. - I took another look at this. Yes - "PHf " is being broken apart and
> that's why I want it to start on page 2. After reading what you said, I
> revisited the standard Vantage quoteform. You're right, it does not have
> that many PH sections...the one that's "PHf "on mine is "GH1b "on the
> standard form. I think things got screwed up when I went to version 4.0
> and verified the database in Crystal. I'm even having trouble starting over
> with Vantage's standard form. It does not want to verify within Crystal
> properly and some of the print previews look like packing slips. It's
> starting to look like I'm going to have to go back to square one but I'm not
> even sure how.
>
> Greg
>
> Greg:
>
> Do you want the section "PHf" to start on page 2 because it's being broken
> apart and you want the whole thing on page 2? Why would the header print on
> the bottom of page 1? The default form has no "PHf", so is your layout
> radically different?
>
> I'm asking all this to try and give you a simple solution.
>
> Rick Gors
> MR/MMIS
> Osco
>
> Greg Clauser wrote:
>
> > I hope this is a simple question for a Crystal Guru. I'm using the Quote
> > form from Vantage with only minor cosmetic changes. I want the section
> > called " Page Header f " to start the second page instead of starting to
> > print on the bottom of the first page. I thought I could just specify
> "New
> > Page Before" under section formatting but I don't get that option. Is
> that
> > because it's a page header section? What am I missing?
> >
> > Greg Clauser
> > L
>
> To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


[Non-text portions of this message have been removed]
6
I am trying to use a custom AP check form that prints the invoices being
paid on each stub of a 3 part laser check. It prints perfectly from Crystal
listing the invoices paid on each stub. In Vantage, I changed the default AP
check to the new file but when I print the check in Vantage, no detail is
printed on the stubs. Am I missing a step?

Also, when paying a vendor for 20 invoices, is there a way to print a
certain number of invoices on the first check stub, void the check, and
continue printing the remaining invoices on the next check stub, then print
the check?

Thank you in advance for any help,

Karen Brodniak
Accounting Manager
Phone: 425-742-7011 x44
Fax: 425-353-8945
karen.brodniak@...
7
Could the first check be the "live" one and the subsequent pages have the
check voided? This would be a lot easier since you would always have at
least one check. Page numbers greater than 1 would be the trigger for
conditional printing of a voided statement across the other check(s).
-Todd C.

-----Original Message-----
From: Karen Brodniak [mailto:karen.brodniak@...]
Sent: Wednesday, May 08, 2002 11:12 AM
To: Vantage Group (E-mail)
Subject: [Vantage] Crystal Reports question


I am trying to use a custom AP check form that prints the invoices being
paid on each stub of a 3 part laser check. It prints perfectly from Crystal
listing the invoices paid on each stub. In Vantage, I changed the default AP
check to the new file but when I print the check in Vantage, no detail is
printed on the stubs. Am I missing a step?

Also, when paying a vendor for 20 invoices, is there a way to print a
certain number of invoices on the first check stub, void the check, and
continue printing the remaining invoices on the next check stub, then print
the check?

Thank you in advance for any help,

Karen Brodniak
Accounting Manager
Phone: 425-742-7011 x44
Fax: 425-353-8945
karen.brodniak@...




Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=226014.2032696.3508022.1829184/D=egroupweb/S=17050071
83:HM/A=1000239/R=0/*http://ads.x10.com/?bHlhaG9vaG0xLmRhd=1020873976%3eM=22
6014.2032696.3508022.1829184/D=egroupweb/S=1705007183:HM/A=1000239/R=1>


<http://us.adserver.yahoo.com/l?M=226014.2032696.3508022.1829184/D=egroupmai
l/S=1705007183:HM/A=1000239/rand=764813461>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
8
Karen,
Did you start the AP form using the existing APFORM or did you start from Scratch?

Troy

----- Original Message -----
From: Karen Brodniak
To: Vantage Group (E-mail)
Sent: Wednesday, May 08, 2002 12:11 PM
Subject: [Vantage] Crystal Reports question


I am trying to use a custom AP check form that prints the invoices being
paid on each stub of a 3 part laser check. It prints perfectly from Crystal
listing the invoices paid on each stub. In Vantage, I changed the default AP
check to the new file but when I print the check in Vantage, no detail is
printed on the stubs. Am I missing a step?

Also, when paying a vendor for 20 invoices, is there a way to print a
certain number of invoices on the first check stub, void the check, and
continue printing the remaining invoices on the next check stub, then print
the check?

Thank you in advance for any help,

Karen Brodniak
Accounting Manager
Phone: 425-742-7011 x44
Fax: 425-353-8945
karen.brodniak@...



Yahoo! Groups Sponsor
ADVERTISEMENT




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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
9
Troy,
I am using an AP form that was e-mailed to me from the group so I don't know
if it is from scratch. I suspect the reason that the check does not print
the detail in Vantage is that something is not connecting properly. I am
fairly new to Crystal Reports and just don't know what to look for. I will
try starting from the original form. Thanks for your input.

Thanks to Todd also for the tip on voiding checks when the detail uses more
than one check stub.

Karen Brodniak
Accounting Manager
Phone: 425-742-7011 x44
Fax: 425-353-8945
karen.brodniak@...

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Wednesday, May 08, 2002 4:32 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Crystal Reports question

Karen,
Did you start the AP form using the existing APFORM or did you start from
Scratch?

Troy

----- Original Message -----
From: Karen Brodniak
To: Vantage Group (E-mail)
Sent: Wednesday, May 08, 2002 12:11 PM
Subject: [Vantage] Crystal Reports question


I am trying to use a custom AP check form that prints the invoices being
paid on each stub of a 3 part laser check. It prints perfectly from
Crystal
listing the invoices paid on each stub. In Vantage, I changed the default
AP
check to the new file but when I print the check in Vantage, no detail is
printed on the stubs. Am I missing a step?

Also, when paying a vendor for 20 invoices, is there a way to print a
certain number of invoices on the first check stub, void the check, and
continue printing the remaining invoices on the next check stub, then
print
the check?

Thank you in advance for any help,

Karen Brodniak
Accounting Manager
Phone: 425-742-7011 x44
Fax: 425-353-8945
karen.brodniak@...



Yahoo! Groups Sponsor
ADVERTISEMENT




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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



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




Yahoo! Groups Sponsor
ADVERTISEMENT
Click Here!
<http://rd.yahoo.com/M=194081.2021092.3499911.1829184/D=egroupweb/S=17050071
83:HM/A=1036975/R=0/*http://www.ediets.com/start.cfm?code=3225>


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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .


[Non-text portions of this message have been removed]
10
You might be able to use the structure of the report you received from the group, but you need to make sure you are connect with the correct tables that Vantage exports during the running of the report. Starting with the original APForm and then bringing in the subreports or whatever will help insure that things will work smoothly. The linking from the main report to any subreports is pretty key, so don't forget to double-check those.


Troy Funte
Liberty Electronics

----- Original Message -----
From: Karen Brodniak
To: vantage@yahoogroups.com
Sent: Thursday, May 09, 2002 12:04 PM
Subject: RE: [Vantage] Crystal Reports question


Troy,
I am using an AP form that was e-mailed to me from the group so I don't know
if it is from scratch. I suspect the reason that the check does not print
the detail in Vantage is that something is not connecting properly. I am
fairly new to Crystal Reports and just don't know what to look for. I will
try starting from the original form. Thanks for your input.

Thanks to Todd also for the tip on voiding checks when the detail uses more
than one check stub.

Karen Brodniak
Accounting Manager
Phone: 425-742-7011 x44
Fax: 425-353-8945
karen.brodniak@...

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Wednesday, May 08, 2002 4:32 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Crystal Reports question

Karen,
Did you start the AP form using the existing APFORM or did you start from
Scratch?

Troy

----- Original Message -----
From: Karen Brodniak
To: Vantage Group (E-mail)
Sent: Wednesday, May 08, 2002 12:11 PM
Subject: [Vantage] Crystal Reports question


I am trying to use a custom AP check form that prints the invoices being
paid on each stub of a 3 part laser check. It prints perfectly from
Crystal
listing the invoices paid on each stub. In Vantage, I changed the default
AP
check to the new file but when I print the check in Vantage, no detail is
printed on the stubs. Am I missing a step?

Also, when paying a vendor for 20 invoices, is there a way to print a
certain number of invoices on the first check stub, void the check, and
continue printing the remaining invoices on the next check stub, then
print
the check?

Thank you in advance for any help,

Karen Brodniak
Accounting Manager
Phone: 425-742-7011 x44
Fax: 425-353-8945
karen.brodniak@...



Yahoo! Groups Sponsor
ADVERTISEMENT




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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



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




Yahoo! Groups Sponsor
ADVERTISEMENT
Click Here!
<http://rd.yahoo.com/M=194081.2021092.3499911.1829184/D=egroupweb/S=17050071
83:HM/A=1036975/R=0/*http://www.ediets.com/start.cfm?code=3225>


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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .


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


Yahoo! Groups Sponsor
ADVERTISEMENT




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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
11
Here is the problem, I am editing the quote form and need to add one
full page of sales conditions to the end to the form. I only want the
sales condition on this page and nothing else. Does anyone know how I
can do this?

Thanks in advance!
12
In the design tab, if you right click on the section you placed the sales
conditions, a window will pop up. Check the "new page before" and "new page
after".

Liz

-----Original Message-----
From: howelllabs [mailto:nhutchins@...]
Sent: Friday, August 12, 2005 07:48 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports question


Here is the problem, I am editing the quote form and need to add one
full page of sales conditions to the end to the form. I only want the
sales condition on this page and nothing else. Does anyone know how I
can do this?

Thanks in advance!




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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>




SPONSORED LINKS
Technical
<http://groups.yahoo.com/gads?t=ms&k=Technical+support&w1=Technical+support&
w2=Vantage&w3=Database&w4=Database+management+software&w5=Membership+databas
e+software&w6=Church+database+software&c=6&s=148&.sig=D_JdAFeHAoeH6OugOKk1Yg
> support Vantage
<http://groups.yahoo.com/gads?t=ms&k=Vantage&w1=Technical+support&w2=Vantage
&w3=Database&w4=Database+management+software&w5=Membership+database+software
&w6=Church+database+software&c=6&s=148&.sig=8zJYQk3edGWFMUVgup9jKw>
Database
<http://groups.yahoo.com/gads?t=ms&k=Database&w1=Technical+support&w2=Vantag
e&w3=Database&w4=Database+management+software&w5=Membership+database+softwar
e&w6=Church+database+software&c=6&s=148&.sig=PnI9nhHllVsjEbHxRXs1IQ>
Database
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Technic
al+support&w2=Vantage&w3=Database&w4=Database+management+software&w5=Members
hip+database+software&w6=Church+database+software&c=6&s=148&.sig=fKR9gtx-Yh-
u9MWSh0_-hA> management software Membership
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Technic
al+support&w2=Vantage&w3=Database&w4=Database+management+software&w5=Members
hip+database+software&w6=Church+database+software&c=6&s=148&.sig=Nu4StMQZ8LT
26M5TzRGQlg> database software Church
<http://groups.yahoo.com/gads?t=ms&k=Church+database+software&w1=Technical+s
upport&w2=Vantage&w3=Database&w4=Database+management+software&w5=Membership+
database+software&w6=Church+database+software&c=6&s=148&.sig=UAiQi3Ftbp7Qnq6
ys_yZxg> database software

_____

YAHOO! GROUPS LINKS



* Visit your group " vantage <http://groups.yahoo.com/group/vantage>
" on the web.


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .


_____




[Non-text portions of this message have been removed]
13
I have this formula that looks at a field and prints out a text if the criteria is true.

if {bolhead.FRTCHRGS} = 'PREPAID' then 'X' else ' '

The bolhead.FRTCHRGS field is a string field. When I try to run this, I get this error:

'The formula result must be a boolean'

What am I doing wrong?

Thanks,

Jasper





[Non-text portions of this message have been removed]
14
When we print out our PO's we sometimes have issues with the amount of verbage on it. We usually place material requirements in the header comments field.

This causes problems because if it gets really long and we are unable to print it.

Is there a way to setup the crystal report so that a second page ALWAYS prints with the PO that has the comments on it?

Thanks,
Jasper



[Non-text portions of this message have been removed]
15
Have you thought about printing your comments in the Report Footer?
This could force a new page and could print even after the totals.

--- In vantage@yahoogroups.com, Jasper Recto <jrecto@...> wrote:
>
> When we print out our PO's we sometimes have issues with the amount
of verbage on it. We usually place material requirements in the
header comments field.
>
> This causes problems because if it gets really long and we are
unable to print it.
>
> Is there a way to setup the crystal report so that a second page
ALWAYS prints with the PO that has the comments on it?
>
> Thanks,
> Jasper
>
>
>
> [Non-text portions of this message have been removed]
>
16
Is it possible to have the report footer print on it's on new page?

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of charles06072006
Sent: Friday, May 02, 2008 3:43 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Reports question



Have you thought about printing your comments in the Report Footer?
This could force a new page and could print even after the totals.

--- In vantage@yahoogroups­.com<mailto:vantage%40yahoogroups.com>, Jasper Recto <jrecto@...> wrote:
>
> When we print out our PO's we sometimes have issues with the amount
of verbage on it. We usually place material requirements in the
header comments field.
>
> This causes problems because if it gets really long and we are
unable to print it.
>
> Is there a way to setup the crystal report so that a second page
ALWAYS prints with the PO that has the comments on it?
>
> Thanks,
> Jasper
>
>
>
> [Non-text portions of this message have been removed]
>







[Non-text portions of this message have been removed]
17
Yes it is. You just have to specify "New Page Before" in the section
expert. Also remember, there can be multiple sections in the report
footer.

--- In vantage@yahoogroups.com, Jasper Recto <jrecto@...> wrote:
>
> Is it possible to have the report footer print on it's on new page?
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On
Behalf Of charles06072006
> Sent: Friday, May 02, 2008 3:43 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Crystal Reports question
>
>
>
> Have you thought about printing your comments in the Report Footer?
> This could force a new page and could print even after the totals.
>
> --- In vantage@yahoogroups­.com<mailto:vantage%40yahoogroups.com>,
Jasper Recto <jrecto@> wrote:
> >
> > When we print out our PO's we sometimes have issues with the
amount
> of verbage on it. We usually place material requirements in the
> header comments field.
> >
> > This causes problems because if it gets really long and we are
> unable to print it.
> >
> > Is there a way to setup the crystal report so that a second page
> ALWAYS prints with the PO that has the comments on it?
> >
> > Thanks,
> > Jasper
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
18
Yes,
Go into design view, right click on report footer, then format section
and then check the box next to "force new page before".

Chris

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jasper Recto
Sent: Friday, May 02, 2008 12:53 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Re: Crystal Reports question

Is it possible to have the report footer print on it's on new page?

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]On
Behalf Of charles06072006
Sent: Friday, May 02, 2008 3:43 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Crystal Reports question

Have you thought about printing your comments in the Report Footer?
This could force a new page and could print even after the totals.

--- In vantage@...<mailto:vantage%40yahoogroups.com>,
Jasper Recto <jrecto@...> wrote:
>
> When we print out our PO's we sometimes have issues with the amount
of verbage on it. We usually place material requirements in the
header comments field.
>
> This causes problems because if it gets really long and we are
unable to print it.
>
> Is there a way to setup the crystal report so that a second page
ALWAYS prints with the PO that has the comments on it?
>
> Thanks,
> Jasper
>
>
>
> [Non-text portions of this message have been removed]
>

[Non-text portions of this message have been removed]
19
I noticed that when we put the comments in the footer, it comes out blank. Any idea why?

Thanks,
Jasper

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Chris Crosta
Sent: Friday, May 02, 2008 3:57 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Crystal Reports question



Yes,
Go into design view, right click on report footer, then format section
and then check the box next to "force new page before".

Chris

-----Original Message-----
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Jasper Recto
Sent: Friday, May 02, 2008 12:53 PM
To: 'vantage@yahoogroups.com<mailto:%27vantage%40yahoogroups.com>'
Subject: RE: [Vantage] Re: Crystal Reports question

Is it possible to have the report footer print on it's on new page?

-----Original Message-----
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ]On
Behalf Of charles06072006
Sent: Friday, May 02, 2008 3:43 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Crystal Reports question

Have you thought about printing your comments in the Report Footer?
This could force a new page and could print even after the totals.

--- In vantage@...<mailto:vantage%40yahoogroups.com>,
Jasper Recto <jrecto@...> wrote:
>
> When we print out our PO's we sometimes have issues with the amount
of verbage on it. We usually place material requirements in the
header comments field.
>
> This causes problems because if it gets really long and we are
unable to print it.
>
> Is there a way to setup the crystal report so that a second page
ALWAYS prints with the PO that has the comments on it?
>
> Thanks,
> Jasper
>
>
>
> [Non-text portions of this message have been removed]
>

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







[Non-text portions of this message have been removed]
20
What version of Vantage and Crystal Reports are you using? I don't think it
makes a difference; just asking.



I am not sure why you are having the problem either. I tried it just to
make sure what we were telling you is correct and indeed does work. I did
the following:



I added a section below the current report footer.

I opened the section expert and checked the "force new page before" for that
section.

I then drug the Order Comments into that section.



I printed the report and the comments did print on a new page following the
current report footer as expected.



The report I was using was a customization of the Vantage SOA with our
company logo added to it. Not much else on the report was customized.



There is one requirement for this: it does require that the SOA only be run
for a single order. If you have a special customization that can print
multiple orders then it will not work correctly. I do have one such
customization. This would require a totally different approach since the
report itself would consist of many orders of which only the comments for
the last order would print.

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jasper Recto
Sent: Friday, May 02, 2008 3:00 PM
To: 'vantage@yahoogroups.com'
Subject: RE: RE: [Vantage] Re: Crystal Reports question



I noticed that when we put the comments in the footer, it comes out blank.
Any idea why?

Thanks,
Jasper

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com]On
Behalf Of Chris Crosta
Sent: Friday, May 02, 2008 3:57 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Re: Crystal Reports question

Yes,
Go into design view, right click on report footer, then format section
and then check the box next to "force new page before".

Chris

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>
.com<mailto:vantage%40yahoogroups.com> [mailto: vantage@yahoogroups
<mailto:vantage%40yahoogroups.com> .com<mailto:vantage%40yahoogroups.com>]
On Behalf
Of Jasper Recto
Sent: Friday, May 02, 2008 12:53 PM
To: 'vantage@yahoogroup <mailto:%27vantage%40yahoogroups.com>
s.com<mailto:%27vantage%40yahoogroups.com>'
Subject: RE: [Vantage] Re: Crystal Reports question

Is it possible to have the report footer print on it's on new page?

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>
.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>
.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
]On
Behalf Of charles06072006
Sent: Friday, May 02, 2008 3:43 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>
.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Crystal Reports question

Have you thought about printing your comments in the Report Footer?
This could force a new page and could print even after the totals.

--- In vantage@...<mailto:vantage%40yahoogroups.com>,
Jasper Recto <jrecto@...> wrote:
>
> When we print out our PO's we sometimes have issues with the amount
of verbage on it. We usually place material requirements in the
header comments field.
>
> This causes problems because if it gets really long and we are
unable to print it.
>
> Is there a way to setup the crystal report so that a second page
ALWAYS prints with the PO that has the comments on it?
>
> Thanks,
> Jasper
>
>
>
> [Non-text portions of this message have been removed]
>

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

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





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