Categories
Crystal Reports Crystal Reports Formulas Ripplestone Tips

Delimited Crystal Reports Parameter Values

We have a Ripplestone client that has a report with a string value parameter that had values that were delimited so it could be any of the listed values.  This was then used within the Selection with a IN clause.

The values were surrounded with double quotes and then had brackets around the quoted values.  Below is an example:

 

["40","41"."43","44","45"]

 

The problem was that the double quotes would not work within Ripplestone since the double quotes would not work with the HTML Dropdown Box.  All that would be returned in the HTML would be the bracket (“[“) and nothing else.

We found with some testing that we could remove the Brackets AND the double quotes and the report would still work.  Below is the delimited list without the brackets and the double quotes.

40, 41, 42, 43, 44, 45

 

This worked in both the Crystal Reports designer and also when published to Ripplestone.

.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: consolas, “Courier New”, courier, monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
{
background-color: #f4f4f4;
width: 100%;
margin: 0em;
}
.csharpcode .lnum { color: #606060; }

By jlyon12

I'm a partner at TechSol Consulting and we make a software application called Ripplestone that is used to publish, manage, distribute and schedule Crystal Reports. We also create custom websites for ecommerce sites.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s