Conditional Grouping
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=22266
Printed Date: 24 Apr 2024 at 10:32am
Topic: Conditional Grouping
Posted By: Dee37
Subject: Conditional Grouping
Date Posted: 16 Mar 2017 at 6:50am
Hi
I have a financial report which is grouped by Sales Year, then by Sales Period. In each period Invoices and Credits are displayed in numerical order irrespective of whether each begins with INV for invoice or CRE for Credit Note. Within the Sales Year Group and then the Sales Period Group, I would like to separate the invoices into one group and the credit notes into another (so that I can display and total each type separately). Any help would be much appreciated.
Many thanks
Dee
|
Replies:
Posted By: Dee37
Date Posted: 16 Mar 2017 at 7:02am
Oh, I think I've just cracked it!
Insert / Group / Common Tab: Records will be sorted & grouped by: {table.invoice}/ In specified order / Named Group: Invoices / New / table.invoice / startswith / INV / Add / OK
and then do the same for Credit notes CRE.
|
|