Need help with the Maximum function

I'm unsure how to get this function to work correctly in crystal reports, however, I can clearly get this work from a query directly from sql.

Anyhow, I have multiple links setup in crystal reports the very last table that's link is where the data becomes duplicated, because of how are web application is storing the data.  Where this data may become unique is using the "CreationTimeStamp" field from that table.  But I can't get crystal to show to only show the results based of the most recent time stamp created.  Also I not viewing the creationTimeStamp anywhere on the report.  I'm just using to suppress or filter out the data that I want.
ldcrayAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
MIKEConnect With a Mentor Software Solutions ConsultantCommented:
In my experience you can do it within the SELECTION FORMULAS >> GROUP....but for what you are doing...I would simply ...just ADD the SQL SCRIPT to the ADD COMMAND LINE at the datasource IN CRYSTAL.

Again,...this would immediately create a virtual table for immediate linking and use. NO view in SQL would be needed.......
0
 
MIKESoftware Solutions ConsultantCommented:
Just take the SQL Script that creates the table in the format that you desire and ADD that SQL Script to the DATASOURCE... ADD COMMAND line....this will generate an VIRTUAL TABLE....something like a VIEW in Crystal...so that you can link it up just like any other table.

Hope it helps.
Mike
0
 
ldcrayAuthor Commented:
Yeah, but I was wandering how would you do it specifically in Crystal, otherwise I would created a view.
0
 
MIKESoftware Solutions ConsultantCommented:
Add the TABLE(s) in question...then go to REPORT >>> SELECTION FORMULAS >>> GROUP

then type in your MIN or MAX logic there....

0
 
MIKESoftware Solutions ConsultantCommented:
Glad to be of service....
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.