Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Nested report structure Post Reply Post New Topic
<< Prev Page  of 2
Author Message
lowspark
Newbie
Newbie
Avatar

Joined: 27 Nov 2019
Location: United States
Online Status: Offline
Posts: 20
Quote lowspark Replybullet Posted: 30 Dec 2019 at 10:31am


Edited by lowspark - 30 Dec 2019 at 10:32am
Nothing left to do but Smile, Smile, Smile.
IP IP Logged
lowspark
Newbie
Newbie
Avatar

Joined: 27 Nov 2019
Location: United States
Online Status: Offline
Posts: 20
Quote lowspark Replybullet Posted: 30 Dec 2019 at 10:31am
So after adding this to as a new formula:
DistinctCount ({WORKORDER.WORKORDERID},{@Department})

I get this error:
"There must be a group that matches this field."

I created the Formula by typing in "DistinctCount" then adding in by double clicking {WORKORDER.WORKORDERID} then type in + the Double Click @Department. not sure what i am still doing wrong.
Nothing left to do but Smile, Smile, Smile.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 30 Dec 2019 at 10:35am
Whatever field you are grouping on for group one needs to go into the formula.
If you are grouping by the original field use it, if you are grouping by your formula field use it. The resulting formula needs to be placed in the group header or footer for it to display the correct value.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 30 Dec 2019 at 10:42am
Group 1 Department
use DistinctCount ({WORKORDER.WORKORDERID},group 1 field here)
Group 2 Status
use DistinctCount ({WORKORDER.WORKORDERID},{WORKORDER.STATUS})

Also you can just use the insert summary button (Sigma button) and
pick the field as WorkerID
Type as DistinctCount
location = Group 1 (repeat for group 2).
This will insert a summary field into each group footer that you select. You can drag it into the header group header.
IP IP Logged
lowspark
Newbie
Newbie
Avatar

Joined: 27 Nov 2019
Location: United States
Online Status: Offline
Posts: 20
Quote lowspark Replybullet Posted: 31 Dec 2019 at 4:22am
That was it ,, Thank you so much for working through this with me, I truly appreciate it!!!


Type as DistinctCount
location = Group 1 (repeat for group 2).
This will insert a summary field into each Group footer that you select. You can drag it into the header group header.

These are the two parts that i was having trouble with or did not even know they were that important!. Thanks so much

Edited by lowspark - 31 Dec 2019 at 4:24am
Nothing left to do but Smile, Smile, Smile.
IP IP Logged
<< Prev Page  of 2
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.031 seconds.