Selecting First Record by Formula 1

[jercisneros]

Hi all, I have a table that contains all the order information. I want to create a report that tracks new stores entered into the system ({Customer.Date_Created}). Then I want to be able to show the first two shipments only since the creation of the customer. There might be more than two shipments on this table from the same customer. How do I create a formula to do this?

Thanks in advance,
-J

 

[synapsevampire]

Group by the Customer.

Create a 3 part formula:

Customer group header:
whileprintingrecords;
numbervar reccount :=0;

Details section:
whileprintingrecords;
numbervar reccount := reccount+1;

In the details suppression formula, use
whileprintingrecords;
numbervar reccount;
reccount > 2

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Reebo99]

Hey k,

This solution seems alot better than mine in thread767-486173.
J I'm assuming both threads were the same question?
Anyway, I'm going to use your solution synapsevampire, I suggest you do the same J. Reebo
Scotland (Going mad in the mist!)

 

[jercisneros]

Thank you both for your input!

Reebo, yes they were the same question, I just figured that if I refrased it, that then someone else might look at it from a different point of view.

K, I took your solution and works excellent.

Thanks again!

-J