BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: Upcoming Events: SAP TechEd: Sep 28.

Crystal report - Finding partial matching string in Array


 
Search this topic... | Search Crystal Reports... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Crystal Reports  Previous TopicPrint TopicNext Topic
Author Message
taqvisaf
Forum Member
Forum Member



Joined: 12 Aug 2010

Posts: 4



PostPosted: Thu Jul 13, 2017 11:40 am 
Post subject: Crystal report - Finding partial matching string in Array

Hi

I am working on a crystal report and have a requirement to remove the duplicate(partial/like) match entries from a multiple list parameter.
So I have a multi value parameter which might contain below value

Accounts

ABC-12345-000
XYZ-56982-111
ABC-98090-222
UXY-12334-333

What I required to send a message to a user if there are partial duplicate before first '-' like in this case, there are two ABC entries users choose, and I need to display a message to a user to pick just one entry, lfrom similar account like below:

ABC-12345-000 OR ABC-98090-222
XYZ-56982-111
UXY-12334-333

Thanks, Saif
Back to top
sijaffe
Forum Member
Forum Member



Joined: 06 Jun 2017

Posts: 3



PostPosted: Tue Jul 18, 2017 9:24 pm 
Post subject: Re: Crystal report - Finding partial matching string in Ar

One way would be to use a for each for the accounts. Inside the loop build a list duplicates using the Regex to find the dups. then loop thru the original list and find the dups and combine the accounts to get a unique list.

Also, you can LINQ to aggregate the dups.
Back to top
surya.g
Principal Member
Principal Member



Joined: 24 Nov 2009

Posts: 400
Location: Pune


flag
PostPosted: Mon Jul 31, 2017 9:23 am 
Post subject: Re: Crystal report - Finding partial matching string in Ar

this cant be done in crystal but you can write LISTAGG function in sql to first get the values like this and then in crystal and send the information to user.
_________________
Thanks & Regards,
Surya G
Tech Lead (Crystal Reports)
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Crystal Reports  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0101 seconds using 17 queries. (SQL 0.0029 Parse 0.0002 Other 0.0069)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo