get report to ask how many records you want 1

[piovesan]

Hi;

I am using Crystal Xl and I have a report where I have a parameter set so the user can select from a list of Land Classification types. Most of the land classification types only relate to 100 or so parcels, but there are two classifications that relate to more than that.

Is there a way I can make it so if the user selects one of those two parameters, they get only the first 100 records, and then is prompted to go to the next 100 (or is asked if they want to see the next 100), and then asked again, etc., etc......
Thanks!

 

[lbass]

Crystal Reports doesn't work that way, but there might be a way of achieving this.

Is there a sequential field within the classification group that would allow you to group the records into ranges, e.g., parcel 001-100,101-200, or A to G, H to L, etc.? If so you could set up this group to appear and the details to suppress (using drilldowngrouplevel) only for those two classifications and then the user could drilldown into the groups of interest. If you think that might work for you, I could give you more guidance.

Another method would be to use on-demand subreports with only certain ranges of data included in each, but this would be more resource-intensive.

-LB

 

[piovesan]

Hi;

The option to Group is one I would explore.... I do have a sequential field called LandID that I may be able to use..... can you help me through how I would set up a group like that for just those two classifications??
Thanks!!

 

[lbass]

Create a formula like this (if LandID is a string, put quotes around the numbers for each case):

if not({table.classification} in ["ParcelA","ParcelB"]) then
"" else
(
select {table.LandID}
case 0 to 99: "000" to "099"
case 100 to 199 : "100 to 199"
case 200 to 299 : "200 to 299" //etc.
default : '300+'
)

Insert a group on this so that it is Group #2, with Classification being Group #1. Then go into the section expert->Group #2 header->check "suppress blank section."
Suppress the Group #2 footer. Then select the detail section->suppress->x+2 and enter:

drilldowngrouplevel = 0 and
{table.classification} in ["ParcelA","ParcelB"]

...where ParcelA and B are the two parcels you want to be able to drill into.

Note that this will result in the details being displayed for other Parcels, and then for each range of ParcelA and B, when drilled into, a new window will open showing the details. If you want headers to show up in the new windows, you should go into file->report options->show group headers upon drilldown.

-LB

 

[piovesan]

Thank you for your detailed response!! I got this to work the way I like........