Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Advice is what we ask for when we already know the answer but wish we didn't
 
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!

16
March

How Do I use a parameter to control the visibility of an image in Crystal Reports?

A client recently asked "How does one use a parameter to display the correct company logo on a standard report in Crystal Reports?"

Solution:

  1. Create a parameter that lists all the company names

  2. Create a Group Header using the Company Name field

  3. Add a select criteria using the Company Name field:

       {Tablename.Fieldname} = {?Parameter Fieldname}

  4. Add all the required the images to the Group Header section

  5. Right click on image

  6. In the Format Editor dialog box, click on the General Tab

  7. Press the Conditional Format button of the Suppress option

  8. Enter the following formula:

      {Group Name Field} <> {?Parameter Fieldname}

  9. Press the Save and close button

  10. Press the OK button of the Format Editor dialog box

  11. Repeat steps 5 - 11 for all the other images

  12. Select all the images

  13. Align all images on top of each other

MAKE A COMMENT

Name *

Email Address *

Comment *

To prove you are human what is:

11 + 46 =