As a complete beginner to Crystal Reports I hope I am not asking stupid questions of what looks like a very technical and knowledgeable forum...if I am please feel free to direct me elsewhere!
I am trying to select records using several Tables but filtered from a 'Transactions Table' but only want the last dated record (ie the last dated record is equal to [input date range]. In Access I would use a query asking for 'LastOf...[field name] - but I don't know how to select the LastOf in Crystal Reports. I have stumbled around the Help for ages...can anybody please advise me on what I am sure is a simple question!
Many ThanksOne way would be to group by the table.column you're interested in and add the 'lastof' clause into the group selection formula:
{table.column} = Maximum ({table.column})|||If you use Access query for that, then design report based on that query and supply that value as parameter
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment