Crosstab Report - Delete any columns over one page

[lauriebizz]

Not sure if this can be done, but I have a crosstab report that spans several pages. I only need the 1st page to print and discard any addtional columns, is there a way to supress colums after the 1st page? The dates are dynamic, so I can not specify a cut-off date. I'm working with Crystal 9 and SQL server.
Thanks-
Laurie

Example:

Item Date Date Date Date | Page Break | Date Date Date

Desired Results:

Item Date Date Date Date

 

[synapsevampire]

In a fashion you might.

If you know how many columns fit on a page, then create a record selection formula of:

{table.datefield} < minimum({table.datefield})+<number of dates that you want>

The downside of this approach is that you assume that you have successive dates.

You might use SQL to do this in a View/SP or by using a Crystal database Command object, wherein you do something like:

select top <how many dates you want>
datefield, otherfields
from table
order by datefield asc

This assumes that you want the oldest (ASC).

-k

 

[lauriebizz]

Thanks! The record selection worked great!

Laurie

 

[synapsevampire]

If you learn that you're missing dates and hence do get enough columns, go with the second solution, it resolves that.

-k

 

[lbass]

Thread149-943207 offers some other approaches to this issue.

-LB