Report Design
 Crystal Reports Forum : Crystal Reports .NET 2003 : Report Design
Message Icon Topic: Multiple pages based on parameter Post Reply Post New Topic
Author Message
rusmanicai
Newbie
Newbie
Avatar

Joined: 14 Sep 2011
Location: United States
Online Status: Offline
Posts: 17
Quote rusmanicai Replybullet Topic: Multiple pages based on parameter
    Posted: 20 Aug 2013 at 5:07am
Hi,
I need to create a shipping label that shows box 1 of n along with other static and dynamic info that pulls from the order.
I created a parameter called "No of Boxes". I put my shipping label info in the Page Header and then I am using "Page Number" +text "of" + "No of Boxes", to account for what label goes to which box.
I currently don't have anything in my details section.
I did go to section expert, Details, Paging, "New Page Before" and typed "{?No of Boxes}>1 hoping that the report would create a new page if I have multiple boxes :)
I realize now that I probable need some kind of counter while printing records, but have no idea how to do that, or what section to declare it.
Please help. Thank you.

Edited by rusmanicai - 20 Aug 2013 at 5:10am
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 21 Aug 2013 at 11:41am

Is there a maximum number of boxes?  There are only two ways that I know of to do this:

 
1.  Have a query that returns a row of label data for each box.  Put the label in the details and suppress all other sections.  Turn on "New Page Before" on the details with "PageNumber > 1" in the New Page Before formula so that you don't get a new page on the first page.
 
2.  Create a set of details sections - one for each possible lable (this only works if you have a reasonable maximum number of lables!)  Copy the label format into each detail section.  Selectively suppress the sections based on the number of boxes in the parameter.  For example, for the second label, section you would put something like this in the suppress formula:
 
{?NoOfBoxes} < 2
 
For the third:
 
{?NoOfBoxes} < 3
 
etc.
You would also turn on "New Page Before" for each detail section except the first one.  A new page won't be generated for a section that is suppressed.
 
-Dell
IP IP Logged
rusmanicai
Newbie
Newbie
Avatar

Joined: 14 Sep 2011
Location: United States
Online Status: Offline
Posts: 17
Quote rusmanicai Replybullet Posted: 22 Aug 2013 at 3:38am
Hi Dell,
I tried version 1. I put everything in my details section and turned New Page Before on, with the formula.
I am not getting a new page though, not even a blank page.
I am not sure how to create a query that will return a new row with the label for every box.
Can you please help me?
IP IP Logged
Kdieder
Newbie
Newbie
Avatar

Joined: 13 Sep 2013
Online Status: Offline
Posts: 1
Quote Kdieder Replybullet Posted: 13 Sep 2013 at 8:23am
I have almost the same question.
It would be a count up function.
Could a formula be incorporated with how many copies you print?
...like a formula that would number the copies?
In that case if you had a large amount, it would be manageable.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 13 Sep 2013 at 8:58am
You would still have to have a separate section or subreport for each copy.  Crystal won't print copies of pages based on a parameter input to the report.
 
-Dell
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.