Need Help showing the records in single line 1

[vega83]

Friends,
Here is my sample data

Store Locn TYPE PO DATE DATE2 Tot
13 A1 R 341 9/15/2008 Null 2
13 A1 T 542 8/15/2008 7/23/2008 3

I want to show this as
Store Locn TYPE PO R DATE1 T Date DATE2 Tot
13 A1 R 341 9/15/2008 8/15/2008 7/23/2008 5

I want to show this in a single line. In above data data ia m getting as min date. and coressponding records are associated to min data. I will showing only one record each for store.

Any ideas friends.

Thanks a lot,
vega

 

[lbass]

Are you saying you are already using a group selection formula or conditional suppression? If so, you need to show the formula(s). It might also help to see what the detail level data looks like before applying group selection or suppression.

-LB

 

[vega83]

LB,
I am not using any formlas at all i have a written a query in commnad statement. I am not using any supress formula on crystal side.

Only problem is I will have two records each time as I have two types T and R for each store . i want to merge them into single line.

 

[lbass]

I'm not sure about the possible variation in your data, but based on what you've shown, you could insert a group on store+location and then drag your type, po, and date1 field into the group header. Then insert a maximum on date2 and insert a sum on tot and drag them into the group header. Also create a formula:

if {table.type} = "T" then {table.date}

Insert a maximum on this and drag it to the group header. Then suppress the detail and the group footer.

-LB

 

[vega83]

But LB, My other PO will be missing as in the Header it will grab only 1st field. I want to get both the PO'side by side. Sorry I forgot to include that .

 

[lbass]

You can use the same method:

if {table.PO} = "T" then {table.PO}

Then insert a maximum on it and drag it into the group header.

-LB

 

[vega83]

LB, you are right works like charm. I found i can do this in SQL command too inserting a case statement. Thanks a ton