Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Dynamic fields in multi pages CR Post Reply Post New Topic
Author Message
denhors
Newbie
Newbie
Avatar

Joined: 04 Jan 2011
Online Status: Offline
Posts: 20
Quote denhors Replybullet Topic: Dynamic fields in multi pages CR
     Posted: 04 Jan 2011 at 1:33am
I have a few questions for You:
1. I need to make multi-pages report, each page should contain a barcode (field), which is always on the same position (the number of pages of the report be changed depending on the number of data of each user, in my case the user = group)
2. I need to make a formula whose result is 1 on the last page of each group, otherwise 0 (this result is also part of the bar code)

Sorry for bad English...
ThxEmbarrassed
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 04 Jan 2011 at 3:45am
Does each of the bar codes include the page number?  You might be able to use something like this to set your 1/0:
 
If PageNumber = TotalPageCount then 1 else 0
 
This will work well if you don't have a lot of pages.  However, using either "TotalPageCount" or "Page N of M" cause a report to take longer to appear in the viewer.  This is because Crystal normally renders one page at a time.  However, these functions require Crystal to render every page in the report in order to know how many pages there are.
 
-Dell
IP IP Logged
denhors
Newbie
Newbie
Avatar

Joined: 04 Jan 2011
Online Status: Offline
Posts: 20
Quote denhors Replybullet Posted: 04 Jan 2011 at 4:47am
I use the Page number in the formula for the sequence in the bar code, if I set up reset Page number after each group, would lose sequence.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 04 Jan 2011 at 6:30am
Gotcha - Last page of each group....
 
If NextIsNull({table.user}) or {table.user} <> next {table.user} then 1 else 0
 
The problem is, this will only work if your bar code is in a group footer, which is not what it sounds like you're doing.
 
-Dell
IP IP Logged
denhors
Newbie
Newbie
Avatar

Joined: 04 Jan 2011
Online Status: Offline
Posts: 20
Quote denhors Replybullet Posted: 04 Jan 2011 at 7:29am
Yes, it would work to the barcode in the group footer, but not in this case because on the following pages should print the other information that the user (user = group). Barcode is in the details.
Is it possible to only certain fields in the detail defined as belonging to the Page Headers?
IP IP Logged
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