BOFocus – Crystal Reports Tips – Tricks – Tutorials

Crystal Reports - Design

Display parameter values that where chosen at run time

For string parameters with multiple discrete values:

Join(@Your_Parameter, chr(10) & chr(13));

For non-string parameters with multiple discrete values:

WhilePrintingRecords
;
Shared numberVar cnt;
Shared stringVar display;

for cnt := 1 to Count({?Your_Parameter}) do
(

display := display + ToText({?Your_Parameter}[cnt],0,”") + Chr(10);
);

display;

For date range parameters:

Totext(minimum({?Your_Parameter})) & ” to ” & Totext(Maximum({?Your_Parameter}));

For date/time range parameters:

Totext(minimum({?Your_Parameter})) & ” to ” & Totext(Maximum({?Your_Parameter}));

Tagged , ,

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

GET SOCIAL

QUICK TIP

The Left Outer Join includes all records in the primary table that have an exact match in the secondary table but also all records that don’t have a match in the secondary table. The Left Outer and Right Outer joins are useful when creating reports to find participants without information in their record.

ADVERTISMENT