2292136 - How to display a specific Tool Tip for each summary in a Cross-Tab in Crystal Reports?

SAP Knowledge Base Article - Public

2292136 - How to display a specific Tool Tip for each summary in a Cross-Tab in Crystal Reports?

Symptom

  • Cross-Tab always shows the same tool tip information for each summary.
  • How to display a specific Tool Tip for each summary in a Cross-Tab in Crystal Reports?
  • On a large cross-tab, it is difficult to know to what row and column the summary is associated with. How to display the row and column name in the Tool Tip of a summary of a cross-tab?

Environment

  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

Reproducing the Issue

  1. In Crystal Reports, create a report off any data source.
         
  2. Insert a cross-tab and add at least one database fields for the:
    • Rows
    • Columns
    • Summaries
           
  3. When viewing the report, and moving the mouse above each summaries of the cross-tab, the Tool Tip always displays the same text like: "Sum of Customer.Last Year's Sales"
      
      Tool Tip - 01.png 
          
      
      
    How to display a specific Tool Tip for each summary in a Cross-Tab in Crystal Reports?
    So it displays a different Tool Tip for each summary like: "Sales for Argentina in 1996"
      
      
    Tool Tip - 02.png

Cause

  • A cross-tab is an object that summarize information in a rows and columns format, and when viewing the cross-tab, it will always show the same tooltip for all the summaries, because it all comes from one object. Therefore, it is normal for the Tool Tip to always display the same information.

Resolution

  • To change the Tool Tip on a Cross-Tab to display the name of the row and column the summary is associated with, or any other information, create a formula for the Tool Tip to use functions like:
    • GridLabelAt
    • CurrentRowIndex
    • CurrentFieldValue
    • Or any other Grid Value functions, depending on what you will actually want the tool tip to display.
         
  • Below are the general steps on how to customize the Cross-Tab Tool Tip for a summary:
       
    1. Right click on one of the cross-tab summary, and select "Format Field..."
    2. In the "Format Editor", under the tab "Common", click on the "X-2" button for the option "Tool Tip Text"
        
       Tool Tip - 03.png   
        
        
    3. In the "Formula Workshop", create a formula using the functions: GridLAbelAt, CurrentColumnIndex, or any other Grid functions depending on the desired outcome. Below is an example of displaying the row name, and column name in the tool tip for a summary:
        
           "Sales for " + 
           GridLabelAt ("myRowName",CurrentRowIndex) + " for the week of" +
           GridLabelAt ("myColumnName",CurrentColumnIndex)  
         

         
      Note: Many functions uses the rows and columns name as one of the arguments. The name of the cross-tab rows and columns are listed under the "Grid Value" functions, under "Row or Column Names"
         
           Tool Tip - 04.png
         
        
    4. Click "Save and close"
         
    5. Back to the "Format Editor", click "OK"
           
      Now, when viewing the report, and pointing the mouse over the cross-tab summaries, it will display a Tool Tip dynamically with the name of the row and column.
            
          
      Note: A sample report on which the Cross-Tab Tool Tip has been customized is available in the attachment sections of the SAP Knowledge Base Article.

Keywords

cr, CR, xtab, CrossTabs, Cross-tab , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016

Attachments

Cross-Tab - Tool Tip.rpt