Intellicus Enterprise Reporting and Business Insights 18.1

Working with Crystal Reports

0 views June 28, 2020 0

To import a crystal report layout in Intellicus Desktop studio,

  1. On the Desktop Studio screen, click File > Import > Crystal Report. The Open screen appears.
  2. Select a crystal report file to import. The Save As screen appears.
  3. Specify information required to save the report. The crystal report is imported and the Report Conversion History screen appears.
  4. On Conversion History screen, click OK to proceed. Click Save to save the conversion history in a file.

    Figure 1: Conversion history screen
  5. The report is imported in Intellicus Desktop Studio and is ready to be modified.

    Figure 2: Report in Crystal

    Figure 3: Report imported in Intellicus

The imported report is like any other report designed in Intellicus Desktop Studio. You will observe that many of the report components on crystal report layout are imported in the IRL along with their property values.

The below data will not be imported from a crystal report template to Intellicus report:

  • Connection Information
  • OLAP Grid Object
  • Blob Field Object
  • Cross-tab Object
  • Conditions
  • Conditional Formatting
  • Grid & Rules Settings
  • Picture
  • OLE
  • Notification

Formula fields with formula script are imported as is and needs to be re-written in JavaScript syntax.

For controls that are imported,

  • Properties that are available in crystal report but not in Intellicus report are not imported.
  • Properties that are available in Intellicus report but not in crystal report are imported with default value.
Scripting

Scripts are imported as is (in the form of comments) and can be viewed and edited using the Script Editor in Intellicus. Scripts are imported in respective sections on OnFormat event.

Imported script will have following structure:

<control name> <property name> <script code>

Page Settings

Supported page sizes are:  A4, B5, Letter and Legal. If the paper size specified in crystal report is other than any of these four, Default paper size will be set in the imported report.

Following page settings are imported from a crystal report layout to IRL:

Property Name (Crystal) Property Name (Studio)
Paper Size Paper Size
Orientation Orientation
Top Margin Top Margin
Left Margin Left Margin
Bottom Margin Bottom Margin
Right Margin Right Margin

Following properties existing in crystal reports are not imported in Intellicus report:

  • PaperSource
  • PrinterDuplex

Note: If the default printer is selected, then the default page setting specified in the default printer is considered and not the one specified in the report. Presently supported paper sizes are: PaperA4, PaperB5, PageLetter and PaperLegal.  Any other paper size will be considered as default paper size.

Now, you will learn the various components (sections, label, line etc.) of the reports and the properties imported or not imported while importing crystal reports.

Sections

All the sections available in crystal report layout are imported in Intellicus report. Dimension of sections and controls within sections are imported and placed as they were in crystal report layout.

Note: If the imported report has multiple section headers and footers, Intellicus merges all the section headers and footers into a single section and a single footer respectively.

A section has section properties. At the time of import, the properties of the first section (including formatting related properties) are imported. From other sections, only controls along with their respective properties are imported.

Following properties and their values are imported when a section is imported from crystal report to Intellicus report.

Property Name (Crystal) Property Name (Studio)
Suppress Visible
Print At Bottom of page
New Page Before NewPage
New Page After NewPage
Keep Together KeepTogether
Background Color Backcolor
SectionHeight Height
BackStyle

Following properties are not imported when a section is imported from crystal report to Intellicus report:

  • Suppress
  • ResetPageNumberAfter
  • SupressIfBlank
  • UnderlaySection
  • GroupCondition
  • HideForDrillDown
  • HorizontalGap
  • NumberOfTopOrBottomNGroups
  • RepeatPageNumberAfter
  • SortDirection
  • TopOrBottomNSortField
Data for the report

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.
Label

Following properties are imported along with their values when a label is imported from crystal report to Intellicus report:

Property Name (Crystal) Property Name (Studio)
Text Caption
Common
Suppress Visible
Horizontal Alignment Alignment
Maximum No. Of Lines Multiline
Border
Line Style Line Style
Drop Shadow Border Shadow
Border Color BorderTopColor
Background Color BackColor
ForeColor Forecolor
BackStyle BackStyle
RightLineStyle
Size
Height Height
Width Width
Top Top
Left Left
Font
Font Font

Following properties are not imported when a label is imported from crystal report to Intellicus report:

  • TextRotationAngle
  • Hyperlink
  • CanGrow
  • CharacterSpacing
  • CloseAtPageBreak
  • FirstLineIndent
  • Keeptogether
  • LeftIndent
  • Linespacing
  • LineSpacingType
  • SupressIfDuplicated
Field

When a field object is imported, properties are imported along with their values. This is applicable to data fields, parameter fields, formula fields, running total and SQL expression field.

Following properties are imported along with their values when a field is imported from crystal report to Intellicus report:

Property Name (Crystal) Property Name (Studio)
Text Text
Common
Suppress Visible
Horizontal Alignment Alignment
Can Grow CanGrow
Border
Line Style Line Style
Drop Shadow Border Shadow
Border Color BorderTopColor
Background Color BackColor
ForeColor Forecolor
BackStyle BackStyle
RightLineStyle
Size
Height Height
Width Width
Top Top
Left Left
Font
Font Font
Data
DataField DataField
(received from object model) DataSize
Output Format OutputFormat
Running Total Properties
FieldToSummarize DataField
Type of Summary Summary Func
Reset Never SummaryRunning
Reset on Change of Group Summary Running + Summary Group
Formula Properties, SQL Expression
Formula Expression Expression
Return Type Return Type
Parameter Properties
Prompting Text Prompt
Value Type Param Input Type
Allow Multiple Values Multi select default value
Default value Default Value
Special Field Properties
Data date, Print Date Data Field + Tag (Import as system fields)
Date Time, Print Time Data Field + Tag (Import as system fields)
Page Number Summary Type + Summary Running + Tag
Total Page Count Summary Type + Summary Running + Tag

Following properties are not imported when a field is imported from crystal report to Intellicus report:

  • AmPmType
  • CharecterSpacing
  • CloseAtPageBreak
  • CurrencyPositionType
  • CurrencySymbol
  • DateCalendarType
  • DateEraType
  • DateFirstSeperator
  • DatePrefixSeperator
  • DateSecondSeperator
  • DateSuffixSeperator
  • DateWindowsDefaultType
  • DecimalSymbol
  • DisplayReverseSign
  • HourMinuteSeperator
  • HourType
  • Hyperlink
  • LeadingDayPosition
  • LeadingDaySeperator
  • LeadingDayType
  • RoundingType
  • ThousandsSeperator
  • ThousandSymbol
  • Timebase
  • UseLeadingZero
  • FirstLineIndent
  • EnableTightHorizontal
  • KeepTogether
  • LeftIndent
  • LineSpacing
  • LineSpacingType
  • RightIndent
  • RightLineStyle
  • SuppressIfDuplicated
  • TextRotationAngle
  • UseOneSymbolPerPage
  • UseSystemDefaults
  • MaxNumberOfLines (Multiline)
  • ZeroValueString

Following are the summary fields imported from crystal report to Intellicus report:

  • STAverage
  • STCount
  • STDistinctCount
  • STDMedian
  • STDMode
  • STMaximum
  • STMinimum
  • STPopStandardDeviation
  • STPopVariance
  • STSampleStandardDeviation
  • STSampleVariance
  • STSum

Following are the summary fields available in crystal reports, but not supported in Intellicus reports:

  • STDCorrelation
  • STDCovariance
  • STDNthLargest
  • STDNthMostFrequent
  • STDNthSmallest
  • STDPercentage
  • STDPercentile
  • STDWeightedAvg

Following are the special fields in crystal reports but are not supported in Intellicus reports:

  • File Author
  • File Creating Date
  • File path and name
  • Group Number
  • Group Selection Formula
  • Modification Date
  • Modification Time
  • Record Number
  • Record Selection Formula
  • Report Comments
  • Report Title
  • Total Page Count

Following are the properties imported when a formula field is imported from crystal report to Intellicus report:

  • DiscreteOrRangeKind
  • EditMask
  • EnableNullValue
  • EnableRangeLimit
  • EnableShowDescriptionOnly
  • EnableSortBasedOnDesc
  • MaximumValue
  • MinimumValue
  • NumberOfCurrentRanges
  • PickListSortMethod
  • PlaceInGroup
Line

Following properties are imported when a line object is imported from crystal report to Intellicus report:

Property Name (Crystal) Property Name (Studio)
Style LineStyle
Width LineWeight
Color LineColor
Suppress Visible
Left Left
Right Right
Top Top
Bottom Bottom

Following property is not imported when a Line object is imported from crystal report to Intellicus report:

  • ExtendToBottomOfSection
Box

Following properties and their values are imported when a box is imported from crystal report to Intellicus report.

Property Name (Crystal) Property Name (Studio)
Style Shape
Width Width
Height Height
Fill Color BackColor
Line Color Line Color
Suppress Visible
Left Left
Right Right
Top Top
Bottom Bottom

Following properties are not imported when a box is imported from crystal report to Intellicus report:

  • HasDropShadow
  • ExtendToBottomOfSection
  • CloseAtPageBreak
Sub Report

Sub report is imported as embedded. Its position and dimension information is imported. Crystal report does not have concept of referenced report.

Following properties are not imported from crystal report to Intellicus report:

  • Backclor
  • BorderColor
  • BottomLIneStyle
  • CloseAtPageBreak
  • EnableOnDemand
  • HasDropShadow
  • KeepTogether
  • LeftLineStyle
  • RightLineStyle
  • TopLineStyle
Charts

Charts are imported as bound charts. Fields placed on Group axis as well as on Value axis are imported as is.

Chart type

Charts of following chart type are imported from crystal report to Intellicus report:

  • Side by side Bar Chart (Normal)
  • Stacked Bar Chart (Normal)
  • Side by Side Bar Chart (3D)
  • Stacked Bar Chart (3D)
  • Line Chart (Normal)*
  • Stacked Line Chart (Normal)
  • Line Chart (Marker)*
  • Stacked Line Chart (Marker)*
  • Stacked Area Chart (Normal)*
  • Stacked Area Chart (3D)*
  • Pie Chart (Normal)
  • Pie Chart (3D)
  • Radar Chart

*Imported properly when only 1 series is plotted.

Charts of following chart type are converted to their generic chart type after import:

Source chart type Converted chart type
Percent Bar Chart (Normal) Bar Chart
Percent Bar Chart (3D) Bar Chart
Percent Line Chart (Normal) Line Chart
Percent Line Chart (Marker) Line Chart
Percent Area Chart (Normal) Area Chart
Percent Area Chart (3D) Area Chart
Multiple Pie Chart Pie Chart
Proportional Pie Chart Pie Chart
Doughnut Chart Bar Chart
3D Riser Chart Bar Chart
3D Surface Chart Bar Chart
Stacked Radar Chart Radar Chart
Notes

3D charts of Crystal are not imported. In Intellicus, the 3D is a visual effect only.

Only Bar charts having horizontal orientation are imported.