We help IT Professionals succeed at work.

Displaying Data - Single Date, multiple rows

cdemott33
cdemott33 asked
on
Hi All -

I'm looking to present records to my users this way.
gridview-dates.jpg
My challenge is this.  If there are multiple records for the same date I only want to display the date once.  

I'm stuck on a.) how to do this and b.) what would be the best tool to replicated my example above.   (ie. GridView, Repeater, or something else)

Can you help?
Comment
Watch Question

Ammar GaffarSoftware Engineer

Commented:
Hi,
Check this link for the same, using Crystal Reports

http://stackoverflow.com/questions/9529141/how-to-merge-rows-in-crystal-report

Good Luck
Senior SQL DBA
Commented:
The closest you can get to your example for a GUI object in your application would be to look at the GridView object.  Another option that I like using is the ListView object and use the dates as the Grouping within the ListView.  This would place the date just above all the associated items.

Author

Commented:
I decided to use a nested repeater to get my results, but thanks for the information.