Print Page | Close Window

Cross Tab Maximum Date Selection

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20186
Printed Date: 08 Apr 2025 at 5:57pm


Topic: Cross Tab Maximum Date Selection
Posted By: esther31
Subject: Cross Tab Maximum Date Selection
Date Posted: 03 Nov 2013 at 11:03pm
Hello
 
I am trying to create a report that lists the status of each customer account. I have a table that creates a record for each action completed for that customer. How can I select the maximum date and time for the customer number and display the data in a cross tab?
 
Basically I want the following:
 
Customer Number 12345678 Date 01/10/2013 Time 13:00
Customer Number 12345678 Date 03/10/2013 Time 16:00
Customer Number 12345678 Date 03/10/2013 Time 17:00
 
For this customer I just want to display data relating to the 3rd entry.
 
Thanks
Esther


Replies:
Posted By: lockwelle
Date Posted: 07 Nov 2013 at 9:07am
i am not much of a crosstabs user, but can't you select the type of aggregate for each column in the crosstab expert?

I am assuming that the date and time are together in 1 field, otherwise the results may be misleading.

HTH


Print Page | Close Window