Solved

create a record selection formula from multiple values of a parameter

Posted on 2004-08-31
4
561 Views
Last Modified: 2011-10-03
Hi Experts

In Crystal 9 . I am using a parameter where you can add multiple values.
i have to generate a record selection formula in crystal report.

table.fieldname = parameter[i] or table.fieldname = parameter[2]


Something like the code below.

for i=1 to ubound(multipleParam)
(      
      If i=1 Then
            table.fieldname = multipleparam[i]
      Else
            or
            (
                  table.fieldname = multipleparam[i]
            )      

)
0
Comment
Question by:PradeepYadhav
  • 2
  • 2
4 Comments
 
LVL 28

Accepted Solution

by:
bdreed35 earned 250 total points
ID: 11941645
You are going to kick yourself when yo usee how easy this was.

{Table.fieldname} in {?multiparam}

That is all you need instead of the for loop.
0
 
LVL 13

Expert Comment

by:vidru
ID: 11941659
You should just be able to use this as your record selection formula:

{Table.FieldName} In {?MultiValueParameter}

-dave
0
 
LVL 28

Expert Comment

by:bdreed35
ID: 11941707
Dave, I see you found your way over here too!
0
 
LVL 13

Expert Comment

by:vidru
ID: 11943141
Hey Brian...

Yep, there are a lot of familiar handles in here ;)

-dave
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now