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: BI + Analytics conference: Aug 9.

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
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.0241 seconds using 17 queries. (SQL 0.0172 Parse 0.0002 Other 0.0067)
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