1215186 - How to dynamically change the table name using a parameter in Crystal Reports?

• Dynamic table name.
• How to dynamically change the table the report uses?
• How do prompt for a table using a parameter in Crystal Reports?
  
  
• For example: A database has a Sales table for each year from 2000 to 2002 named Sales2000, Sales2001, and Sales2002.
    
  Each table has the same fields and these fields have the same structure. Only the data is different. When the report is refreshed, a prompt is required to allow the user to choose to which table the report will connect. How can it be done?
    
     
• Note: Images and data in this SAP Knowledge Base Article is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

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

CR , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To