Creating a range for Name Field

[luvtitans50]

I have a report that returns over 12,000 records. Exporting out to PDF takes forever. How can I have the report broken down by lastname. For example:

{Command.LastName} between 'A and Bo'

Need to be able to run the report by lastname to decrease the export time.

Thanks!!

 

[lbass]

You can use:

{table.LastName} between 'A' and 'Bp'

...to return all last names starting with A through Bo. Or set this up as a parameter:

{table.LastName} between '{?StartingLetter}' and
'{?EndingLetter}'

You should implement this within the command for speed (and this uses command syntax in both cases). Just remember that the ending value will only be included up through the specified letters, so if you choose "Bo", you would only see values like this:

Barker
Berg
Bo

But not 'Borgan'.

-LB