BOFocus – Crystal Reports Tips – Tricks – Tutorials

Tag Archives

Wildcard parameters

Greatly increase the flexibility and effciency of your reports by using a wildcard parameter. This nifty trick  can be quite useful when..

April 5, 2012 with 2 Comments

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..

April 4, 2012 with 0 Comments

How to pass a date range to a subreport using a parameter

Displaying data from a subreport based on a date range can be a bit tricky.  Many people choose to simply hardcode the date range within..

April 4, 2012 with 8 Comments

Assign a default value or add another value to a dynamic parameter

Crystal Reports – Dynamic Parameters aren’t very dynamic By design, you can cannot assign a default value or add another value to a..

March 26, 2012 with 0 Comments

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