What is the proper way to pass a DataSet to the Report

[Sandy Pham]

I pass a DataSet of data to the report writer. Can you please tell me what the proper way to create a DataSet is?

I create my DataTables and then I set up DataRelations to represent table joins. I used to do a join going both directions.

relation = new DataRelation(strDataRelationName, columnParent, columnChild, false);
ds.Relations.Add(relation);
relationReverse = new DataRelation("Rev_" + strDataRelationName, columnChild, columnParent, false);
ds.Relations.Add(relationReverse);

Then, when I got a new build a few months back, the report writer got confused and listed the same tables multiple times. So, I just started putting the DataRelation going one direction and that seemed to work. However, now when I do a report with a join, only the first record is displayed.

I'm so confused. Please tell me what I'm doing wrong.

Thank you,

Sandy

[Edward]

It seems that you are doing everything correctly. Is the sample application possible? If yes, then please send it to support[at]stimulsoft.com for analysis.

Thank you.

[iman_22a]

hi Sandy

this condition occurs when you use inner join on thow tables that may be some data in left table that has no related data on right table.or use join with column other than a primary key .

exc for my bad english
Iman