Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: formual to specify within same field Post Reply Post New Topic
Author Message
Paula J
Groupie
Groupie
Avatar

Joined: 22 Aug 2011
Location: United States
Online Status: Offline
Posts: 51
Quote Paula J Replybullet Topic: formual to specify within same field
    Posted: 24 Apr 2013 at 6:49am
I have a report that I need to pull accounts that contain services done together but only list those 2 services and not any other service on the account.  The way I have it written now it will do that but also list other accounts because those others contain one of the services I have in the criteria.  How can I modify my criteria and/or exclude the unwanted accounts?
 
{TRX_SERV_DT} in DateTime (2013,01,01) to DateTime (2013,01,03) and
({TRX_PROC_NO}=2418655 or
{TRX_PROC_NO}=240840)
 
acct#                     service code    date of service
111                        2418655          2013 01 01
111                        2402840          2013 01 01
222                        2418655          2013 01 02
333                        2418655          2013 01 03
444                        2402840          2013 01 03
 
This is my results on the above criteria/formula and I only want acct 111 to list on the report (accts in red should not appear on the report)
Paula J
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet Posted: 24 Apr 2013 at 6:54am
Hi

Insert a group on acct# and insert a count on acct#.

Now go in Report--Record Slection Formula--Group then filter like ..

@Count > 1

This will give you only records where you have multipul service code records.

Thanks,
Sastry
IP IP Logged
Paula J
Groupie
Groupie
Avatar

Joined: 22 Aug 2011
Location: United States
Online Status: Offline
Posts: 51
Quote Paula J Replybullet Posted: 24 Apr 2013 at 9:17am
This worked...thanks
Paula J
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.031 seconds.