Crystal Reports

SAP Business Objects an Dynamic Images in Crystal Reports

Recently one of our client wanted to display images dynamically in one of their Crystal Reports. The report(Purchase Order Report) had up to 3 Buyers for a single Purchase Order, and besides each Buyer Name they wanted a logo(image) specific to the Buyer. Based on the Buyer Name we need to choose one of the 3 images to print on the Purchase Order report. This can be accomplished using the following methods based on the version of the Crystal Reports.

Dynamic Images in Crystal Reports

Version 10 or less:

Here you create multiple (equal to the number of images) group headers, place each image within each header as shown below.

Right-click the first group header, go to section expert, click on the formula button to suppress it conditionally as shown below. In my case each image(logo) is configured to display only for the respective buyer. Repeat this step for all the group headers.

 

Note: In these versions you can’t set the image location graphically as there is no such option on the picture tab.

XI or later versions:
Here you can either use the above approach(using a formula and section expert to hide the image conditionally in the group headers) or by setting the location of the image graphically as follows:

Note: This is not available in version 10 or less.
Right-click the image, go to Format Graphic(or Format Editor), click on the Picture tab and then click the Graphic location conditional formula button. Create a formula that returns a string value equating to the location of the string.

Again, you can return two or more strings using a condition. I used the above approach as I was required to work with version 10.

Also See: Processing the Batch Input Session (SM35) 

Online Training Tutorials

  • Promoting Business ViewsHow to Promote Business Views in Business ObjectsPromoting Business Views from one environment to other is little tricky especially when you are not much familiar with how Import Wizard works. Business Views fall under the “repository […]
  • Sap Business Object Layer (BOL)What is Sap Business Object Layer (BOL)?The Sap Business Object Layer (BOL) stores data of business object such as business partners and sales order during run time.  This was done in order to separate Presentation layer of Web […]
  • SAP Business WorkflowAn Introduction to SAP Business WorkflowSAP Business Workflow is a tool to automate complex business processes where there is more than one user involved. SAP workflow maps the position in organization because SAP believes that […]
  • SAP Business ObjectsSAP Business Objects PartnersSAP Business Objects OEM Partners Drive New Business Opportunity  To stay competitive, you need to deliver innovation and value to your customers. You need a partner that can help you […]
  • SAP BPMSAP NetWeaver – Business Process Management (SAP BPM)Business Process Management (SAP BPM) Every Enterprise deals with multiple simple to complex business processes to run their operations. These processes may be automated or are managed by […]
  • Electronic Data InterchangeWhat is SAP Electronic data Interchange (EDI)?Electronic Data Interchange is here to stay. SAP has provided many tools to ease the integration to EDI subsystems and these, together with a methodology of how to implement EDI are […]
  • SAP FICO Interview QuestionsSAP FICO (Financial Accounting & Controlling) Interview QuestionsSAP FICO (Financial Accounting and Controlling) module can be integrated with all other SAP modules include Material Management, Sales and distribution, Production planning, Human resource […]
  • Reconciliation ledgerHow to do Reconciliation Ledger in SAP SystemIMG⇒ Controlling⇒ Cost Element Accounting⇒Reconciliation ledger⇒Activate/Deactivate Reconciliation Ledger Double Click on “Activate Reconciliation […]