Select Multiple tables in Report Wizard

[ngaheer]

No reply yet. kindly suggest me the solution to this problem.. my prject deadline is approaching.

[Vital]

Please wait. We work on solution for you.

[Edward]

My application supports two ways for designing a report. If i design the report from designer manually,

everything is working fine. I hav set MasterReport to my report. Following is the code to it.

Public Sub SetReportLayoutColumn()

Dim masterReport As New StiReport
Dim a As String = System.AppDomain.CurrentDomain.BaseDirectory.ToString
masterReport.Load(a & "Master.mrt")
Dim report As StiReport = PopulateReportDesign()
report.MasterReport = masterReport.SaveToString()

Dim reportLayout As String = report.SaveToString
_reportLayout.RLALayout = reportLayout
report.Design()

End Sub


The above code, properly sets the mater report using tostring method.

Yes, it is the correct way of designing the report using inheritance.

The problem comes when i try designing report using wizard. One of your rep said me to set this Master

Report as Class insted of a string.

Designing the report via Wizard is possible only for the new reports. So after designing report with wizard you always get only new report template. The report will include only new bands and texts.

Code: Select all

            Dim wizard As StiMasterDetailWizardService  = New StiMasterDetailWizardService()
            Dim rptNew As StiReport = wizard.CreateReport(masterReport)

The code above tells to the wizard only about the data from the masterReport. Wizard is intended for creating new reports only.

Now i am using a class, but still when i preview the report. It gives arror at

Streport.Compile.
Following is the code for playing wizard.(some code is commented, as i was just testing the working of this

report)

The reports which are stored as classes cannot be designed later.

you hav seen the code above, now suggest how can get my master report working over the report created

using report wizard.

Please use the following code:

Code: Select all

    Dim masterReport As New Reports.Report
    Dim ds As New DataSet("Demo")
    ds.ReadXmlSchema("Demo.xsd")
    ds.ReadXml("Demo.xml")
    masterReport.RegData("Demo", ds)
    masterReport.Dictionary.Synchronize
    Dim rptNew As StiReport = New StiMasterDetailWizardService().CreateReport(masterReport)
'if you want to remain inheritance for the Dictionary
    Dim dataSource As StiDataSource
    For Each dataSource In rptNew.Dictionary.DataSources
        dataSource.Inherited = True
    Next
    rptNew.Design

Also tell me, if i set master report as string, why does it not work in that way, i mean to ask, why there is a

need of using class and not string.

It could be misunderstanding. Wizard uses only a reports' Dictionary for creating a completely new report.

Thank you.

[ngaheer]

Dim outputFieldSet As OutputFieldSet = OutPutFieldSetDataStore.getInstance.find(_reportLayout.RLAOFSID)
Dim ds As DataSet = ReportExecuter.ExtractSchema(outputFieldSet)
Dim masterReport As New Reports.Report
ds.ReadXml(outputFieldSet.ReturnFieldsXML)
ds.ReadXmlSchema(outputFieldSet.OFSSchemaString)
masterReport.RegData("demo", ds)
masterReport.Dictionary.Synchronize()
Dim rptNew As StiReport = New Stimulsoft.Report.Design.Wizards.StiMasterDetailWizardService().CreateReport(masterReport)
'if you want to remain inheritance for the Dictionary
Dim dataSource As StiDataSource
For Each dataSource In rptNew.Dictionary.DataSources
dataSource.Inherited = True
Next
rptNew.Design()

this is the code i used, but its giving error at fourth line while reading XML .. the error is about invalid characters in path.

outputfieldset.ReturnFieldsXML is

All
0


npf.npfmodusr
0
0
-1
0


npf.npfmodtime
0
1
-1
0


npf.npfmodsrc
0
2
-1
0


npf.npfmoddate
0
3
-1
0


npf.npfLogID
0
4
-1
0


npf.npfdltusr
0
5
-1
0


npf.npfdlttime
0
6
-1
0


npf.npfdltsrc
0
7
-1
0


npf.npfdltdate
0
8
-1
0


npf.npfaddusr
0
9
-1
0


npf.npfaddtime
0
10
-1
0


npf.npfaddsrc
0
11
-1
0


npf.npfadddate
0
12
-1
0


npf.npfmemo
0
13
-1
0


npf.npfext
0
14
-1
0


npf.npfphone
0
15
-1
0


npf.npftype
0
16
-1
0


npf.npfarea
0
17
-1
0


npf.npfseq
0
18
-1
0


npf.npfsort
0
19
-1
0


npf.npfIsEmailAddress
0
20
-1
0


npf.npfnafseq
0
21
-1
0


npf.npfCountry
0
22
-1
0


npf.npfEmail
0
23
-1
0


naftype.naftSecurityGroups
0
24
-1
0


naftype.naftEnabled
0
25
-1
0


naftype.naftcodeplm
0
26
-1
0


naftype.naftcode
0
27
-1
0


naftype.naftdesc
0
28
-1
0


naftype.naftcompany
0
29
-1
0


naftype.naftsortdef
0
30
-1
0


naftype.naftLogID
0
31
-1
0


naftype.naftdltdate
0
32
-1
0


naftype.naftdltsrc
0
33
-1
0


naftype.naftdltusr
0
34
-1
0


naftype.naftdlttime
0
35
-1
0


naftype.naftadddate
0
36
-1
0


naftype.naftaddsrc
0
37
-1
0


naftype.naftaddtime
0
38
-1
0


naftype.naftaddusr
0
39
-1
0


naftype.naftmoddate
0
40
-1
0


naftype.naftmodsrc
0
41
-1
0


naftype.naftmodtime
0
42
-1
0


naftype.naftmodusr
0
43
-1
0

[Edward]

Please correct your code. The line 3 and 4 must be swapped. This error came to your code from my previous post, my fault. First the shema for the DataSet should be read, then a data in xml format for it. So your code should be the following:

Code: Select all

ds.ReadXmlSchema(outputFieldSet.OFSSchemaString)
ds.ReadXml(outputFieldSet.ReturnFieldsXML)

Thank you.