Crystal Reports Query..

[Poolybit]

Hey,

Hoping that there is someone who has played around with Crystal a fair bit..I've been handed it to create a report and most of it is fine I'm just having issues with one part which I'm sure should be a lot more simple than I am making it!

I am trying to retrieve a number of records from a DB to create an average from. To do this I am retrieving a number of different fields which is fine but I want to limit the number of records retrieved to 100. I've tried using the Group Sort Expert TopN functon but that doesn't work and I've also tried to do a details supression (RecordNumber >= 101) within Section Expert. The detail supression works for visible records but because it is still retrieving all of the records, any formulas that I create are calculating on all of the records, not just the visible ones. Is there some way of doing this? I've tried to create a 'do while' loop in a formula field to only calculate a sum for 100 iterations but that doesn't work either. Is there an easy way around this as I'm tearing my hair out at the minute!

Thanks in advance!

 

[fez]

Do you wish to limit the number of records from the database to 100 or are you trying to limit it once you have all the data?

 

[Poolybit]

I'd prefer to limit the number of records retrieved from the DB as I don't need to have any more than those 100 records to do the formulas that I want to create!

 

[wonder_lander]

Where are you getting the data from? Can you limit the record selection in the underlying query?

I don't have crystal installed at home so can't offer much practical assistance.