Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Cross Tab Maximum Date Selection Post Reply Post New Topic
Author Message
esther31
Groupie
Groupie


Joined: 19 Dec 2011
Online Status: Offline
Posts: 50
Quote esther31 Replybullet Topic: Cross Tab Maximum Date Selection
    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
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet 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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.039 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.