?
Solved

Crystal Reports 2011 (Subscript/array required)

Posted on 2012-03-29
2
Medium Priority
?
434 Views
Last Modified: 2012-03-29
I've got a parameter that allows for multiple selections.

A
B
C
D
E

If the user selects "A" from the group, I have a formula that prints "A" as the title of the report.

However, if the user selects A, B, C all at once, I'd like the formula to print all three on the report title.

Currently my formula is:

if {?GROUP} = "A" then "A" else
if {?GROUP} = "B" then "B" else  (and so on for each individual choice)

But here is where I get stuck..

If {?GROUP} = "A" and "B" and "C" then (what does my formula need to look like to print all?)
0
Comment
Question by:wshcraft70
2 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 2000 total points
ID: 37782600
Create a formula field....


local stringvar result;
result:=join({?group},", ");
result

This will display for example..

a, b, c
0
 
LVL 1

Author Closing Comment

by:wshcraft70
ID: 37782734
Perfect..  THANK YOU VERY much!!!  :D
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

749 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