To import a crystal report layout in Intellicus Desktop studio,
- On the Desktop Studio screen, click File > Import > Crystal Report. The Open screen appears.
- Select a crystal report file to import. The Save As screen appears.
- Specify information required to save the report. The crystal report is imported and the Report Conversion History screen appears.
- On Conversion History screen, click OK to proceed. Click Save to save the conversion history in a file.
Figure 1: Conversion history screen - 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.