Intellicus Enterprise Reporting and Business Insights 19.1

Data

0 views June 28, 2020 0

A crystal report may have fields that are coming from one or multiple databases. An Intellicus report can get data only from one data connection.

If the report being imported has fields coming from multiple databases, the report will get imported and the fields that have lost connection with their database in Intellicus, will behave as labels. For more information on labels, refer to the section ‘Label’ below.

If the crystal report has one or more tables and no stored procedures, report layout as well as SQL part will be imported. If crystal report has stored procedure, the import process has the following limitations:

  • If the crystal report has both – table and stored procedure, then only the report layout will be imported and the SQL part will not be imported.
  • If the crystal report has a stored procedure (that does not have parameter(s)), only the report layout will be imported and the SQL part will not be imported.
  • If the crystal report has only stored procedure with one or more parameters, the report layout as well as the SQL part will be imported.
  • If the crystal report has multiple stored procedures, only the report layout will be imported and the SQL part will not be imported.
  • In case of MS Access data source, the query will not be converted accurately.
  • If the Record Selection Formula is specified in the crystal report, then during conversion, the record selection formula is appended in SQL query as is. You have to convert it into a proper SQL syntax at a later stage.
  • If the crystal report is designed using linking manager and the record selection formula is specified in the crystal report, then the imported SQL in IRL should be validated. This validation is because the record selection formula can have any SQL script syntax that can be different from the SQL script syntax in IRL.