Kindly suggest.
Code i m using to create report is as followes.
Code: Select all
Private Sub SetReportWizard()
Dim masterReport As New StiReport
Dim a As String = System.AppDomain.CurrentDomain.BaseDirectory.ToString
masterReport.Load(a & "Master.mrt")
Dim report As StiReport = PopulateReportWizardDesign()
report.MasterReport = masterReport.SaveToString()
Dim reportLayout As String = report.SaveToString
_reportLayout.RLALayout = reportLayout
report.Design()
End Sub
Private Function PopulateReportWizardDesign() As StiReport
Dim report As New StiReport
Dim rptNew As StiReport
Dim outputFieldSet As OutputFieldSet = OutPutFieldSetDataStore.getInstance.find(_reportLayout.RLAOFSID)
Dim dataSet As DataSet = ReportExecuter.ExtractSchema(outputFieldSet)
Dim reportOptions As String = Nothing
If Not outputFieldSet Is Nothing Then
If Not outputFieldSet.OFSFields Is Nothing And outputFieldSet.OFSFields.Count > 0 Then
report.RegData("Data", dataSet)
report.Dictionary.Synchronize()
rptNew = New Stimulsoft.Report.Design.Wizards.StiMasterDetailWizardService().CreateReport(report)
For Each dataSource As StiDataSource In report.Dictionary.DataSources
Dim tableName As String = dataSource.DataTable.TableName
Dim dt As DataTable = dataSet.Tables(tableName)
dataSource.Alias = dt.ExtendedProperties("DisplayName").ToString
Next
For Each dataRelation As StiDataRelation In report.Dictionary.Relations
Dim dataSource As StiDataSource = dataRelation.ParentSource
Dim tableName As String = dataSource.DataTable.TableName
Dim dt As DataTable = dataSet.Tables(tableName)
dataRelation.Alias = dt.ExtendedProperties("DisplayName").ToString
Next
If (Not _reportLayout.RLALayout Is Nothing) Then
If (_reportLayout.RLALayout.Trim.Length > 0) Then
report.LoadFromString(_reportLayout.RLALayout)
End If
End If
If _reportLayout.ReportOptions IsNot Nothing Then
For Each RepOption As ReportOption In _reportLayout.ReportOptions
Dim optionName As String = RepOption.REOName
optionName = optionName.Replace(":", "")
If (Not report.Dictionary.Variables.Contains(optionName)) Then
Dim variable As StiVariable = New Stimulsoft.Report.Dictionary.StiVariable("ReportOptions", optionName, RepOption.DataType)
report.Dictionary.Variables.Add(variable)
End If
Next
End If
End If
End If
Return rptNew
End Function