I have the following sceneria

 

A customer bought various items from a store on different days and there is a cashiers who sold it.So I need this to be group by user,line# gives the order which he bought particlar items.I just put line# 2,4 for laptops but in reality it might be any number.Lets go the details

 

Customer #	Purchase date	Line	Item	Cashier
C100	12/1/2011	1	Bag	John
C100	12/2/2011	2	Laptop	John
C100	12/29/2011	3	Keyboard	Michelle
C100	12/30/2011	4	Laptop	Peter
C150	12/30/2011	1	Mouse	Michelle
C150	12/30/2011	2	Laptop	Michelle

 

I want the list of all the columns where the item is "Laptop".In this scenerio customer "C100" bought laptop twice but it doesnt mean he bought laptop twice may be some kind of exchange or minor repairs so I am interested only when he made his first purchase

 

Ex 1:

If I ran a report for the dates 12/29 thru 12/30 I should only see the following result

 

C150

12/30/2011

2

Laptop

Michelle

 

In my report I did it like this way I grouped it by cashier,customer#in record selection : Item = "laptop" & Purchase Date in 12/29 to 12/30

Group Selection : Line = minimum(line,customer#) but I am getting the following data

 

C100	12/30/2011	4	Laptop	Peter
C150	12/30/2011	2	Laptop	Michelle

 

Ex2:

 

If I ran this same report for date 12/1 to 12/30 I shld get something like this

 

C100	12/2/2011	2	Laptop	John
C150	12/30/2011	2	Laptop	Michelle

 

Can someone able to help me out.I hope this make sense

 

Not that I am against formulas for grouping, since I use them all the time for exactly that purpose...it just seems like a bit more work than is needed.

 

and now you have at least 2 ways to do the same things, and new tools for future reports.

 

supressing the detail section is still valid, as you want the group header to display...not the details

 

HTH

so he would have

gh1 customer          suppress

gh2 item                 suppress

gh3 purchase date   show  (suppress if not laptop)

 

 

Otherwise, I am fine will both the logic and the reasoning

 

ps After a bit of looking at CR and thinking about how I write reports, your methodology makes alot of sense.