Print Page | Close Window

report alternate page

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4913
Printed Date: 27 Apr 2024 at 8:43pm


Topic: report alternate page
Posted By: webfranc
Subject: report alternate page
Date Posted: 02 Dec 2008 at 10:19am
Good evening,
I work on crystal reports 10, I have a report named invoice and I want GCS printed in both sides of the report.
how can I do to alternate odd page: invoice page , and CGV in even page?
in fact my report can exceed 1 page.




Replies:
Posted By: hilfy
Date Posted: 02 Dec 2008 at 11:06am
What do you mean by "GCS" and "CGV"?
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Posted By: webfranc
Date Posted: 02 Dec 2008 at 11:29am
GCV : general condition of sale


Posted By: hilfy
Date Posted: 02 Dec 2008 at 1:15pm

Got it.

Here's what I think will work....
 
- Create a special detail section that contains the GCV text.  In the Section Expert for this section, turn on "New Page After" and in the Suppress formula for that section put the following:
 
PageNumber\2 > 0
 
Note that I used a backslash '\' instead of the slash '/' that you use for regular division.  The backslash gives you the modulus (or remainder) of a division operation.
 
In the suppress formula for ALL other sections, put the following:
 
PageNumber\2 = 0
 
This uses the same modulus operator again.
 
So, these suppression formulas will suppress GCV section when the page number divided by 2 has a remainder (is an odd page) and all of the sections except the GCV when the page number divided by 2 is 0 (even page.)
 
If it doesn't work in the details section, you may have to use the Group Header section with the same suppression criteria and with "Repeat Header on every page" turned on for the group.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Posted By: Atori
Date Posted: 22 Jul 2015 at 4:58am
Hello
I up the subject, because, it's my problem today ;)

I want insert my gcv, but without header/footer of my report, a page full GCV.
But it's doesn't work, i've always the header or the footer, and the details ...

Where i must put my GCV in my report for to have a full page please ?

thanks


Posted By: hilfy
Date Posted: 22 Jul 2015 at 5:05am
You can use the technique I explained above to suppress the page header and page footer sections on the even numbered pages while showing the GCV in the detail section on them.

-Dell

-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Posted By: Atori
Date Posted: 27 Jul 2015 at 4:45am
hello, in my detail section and in my group header, i've already a tab :/
in page number 2, the tab appears with my GCV in the tab.

thanks


Posted By: Atori
Date Posted: 11 Aug 2015 at 4:54am
Hi
do you have a solution for me ? Cry



Print Page | Close Window