Intellicus Enterprise Reporting and Business Insights 19.1

Field

0 views June 28, 2020 0

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