Print Page | Close Window

Latest Date 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=21810 Printed Date: 04 May 2024 at 1:02am Topic: Latest Date Posted By: slam786 Subject: Latest Date Date Posted: 15 Dec 2015 at 8:53am Very new to writing. My database will pull multiple rows when I ask for persons with charges in the LastFullMonth. I just want to know IF they had a charge. I don't need to know how many or the dates. But I get multiple rows when I use that as a selection. What can I write to only get one row per person if they have any charge for that timeframe? Thank you in advance ------------- slmeyers Replies: Posted By: hilfy Date Posted: 23 Dec 2015 at 8:51am Try this: - Group by person - either name or concatenate name and person id (if there can be more than one person with the same name). - Put the data in the person group header. - Suppress the details section and the person group footer section. -Dell ------------- Proviti, Data & Analytics Practice http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Print Page | Close Window