C# Programming
10-19-2009, 03:31 AM
Dear All,
I have parent and subreport in win form which uses Report Viewer and RDLC as Reporting Tool.
Every thing is fine as I can pass parms to both Parent and child, the only problem I face is that suppose that i am getting two records from parent with ID 1 and 2 and each of them has children with 5 records.
What i want is the Main and Subpreport should follow the following rule.
Parent Details
Id Code Discription
1 01 One // this is the first Record from Sql Statement passed
Child Details
ChildId Description //SubpReport
1 One
2 Two
. .
. .
. .
2 01 Two // this is the second Record from Sql Statement passed
Child Details
ChildId Description //SubReport
1 One
2 Two
. .
If i select single record from parent and get the child records, it shows ok
but getting more than one records from parent and the same whith child, it shows a very messy report. while i want above format
any ideas please?
Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan
I have parent and subreport in win form which uses Report Viewer and RDLC as Reporting Tool.
Every thing is fine as I can pass parms to both Parent and child, the only problem I face is that suppose that i am getting two records from parent with ID 1 and 2 and each of them has children with 5 records.
What i want is the Main and Subpreport should follow the following rule.
Parent Details
Id Code Discription
1 01 One // this is the first Record from Sql Statement passed
Child Details
ChildId Description //SubpReport
1 One
2 Two
. .
. .
. .
2 01 Two // this is the second Record from Sql Statement passed
Child Details
ChildId Description //SubReport
1 One
2 Two
. .
If i select single record from parent and get the child records, it shows ok
but getting more than one records from parent and the same whith child, it shows a very messy report. while i want above format
any ideas please?
Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan