Creating reports and dashboards | Stimulsoft community forum

Hi All

This might look pretty lame , but for starter like me, am getting pretty confused. Sorry.
I have a Data Structure as follows.

Table 1 : Runlist

Runlist ID RunlistName
1 R1


Table 2 : Method
MethodID MethodName RunlistID
1 Meth_1 1
2 Meth_2 1

Table 3: RunlistRow
RowID MethodID
1 2
2 1


When I try to display this structure using a set of Databands, I am getting everything right, except that, Last table gets displayed in the wrong order.

RowId MethodID
2 1
1 2


Currently I have set Databand and relations as follows
Databand Source Relation MasterComponent
DB1 Runlist None None
DB2 Method RunlistMethod DB1
DB3 Row Row Runlist DB2


Please guide me, Thanks in Advance
Anu

Hi,

take a look at the sort property of the databand.

There you can set it to "rowID"

cheers

stephan

Hi Stephan

I tried that, but problem is since method details needs to print before row details ( ps : Method Databand acts as Master Component for Row Band), the sort needs to be given there. But the Method Table doesn't have any referances to RowID.

RowID comes into play only in the RowTable.

Hierarchy of tables w.r.t to relations are as follows
1. Runlist
2. Method
3. Row

Regards
Anu

Hello.

anuviswan wrote:I tried that, but problem is since method details needs to print before row details ( ps : Method Databand acts as Master Component for Row Band), the sort needs to be given there. But the Method Table doesn't have any referances to RowID.

RowID comes into play only in the RowTable.

Hierarchy of tables w.r.t to relations are as follows
1. Runlist
2. Method
3. Row

Please, send us your report template for analysis.

Thank you.

Hi Aleksey

Please do let me know which ID i should be sending the files ?

Thanks
Anu

Hello.

anuviswan wrote:Please do let me know which ID i should be sending the files ?

Please, send your files on support@stimulsoft.com and add there link on this forum.

Thank you.