Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Conditional Grouping Post Reply Post New Topic
Author Message
Dee37
Newbie
Newbie
Avatar

Joined: 17 Feb 2016
Online Status: Offline
Posts: 8
Quote Dee37 Replybullet Topic: Conditional Grouping
    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
IP IP Logged
Dee37
Newbie
Newbie
Avatar

Joined: 17 Feb 2016
Online Status: Offline
Posts: 8
Quote Dee37 Replybullet 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.
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.047 seconds.