Marianne VAN WYK
asked on
VS2010 Reporting
Hi,
I'm having a hard time creating a master-detail report in VS2010. I have the following:
1x Master report for my transaction header info
1x dataset for my master report (with 1x Tableadapter to the transaction header table - no relationships)
1x Subreport for my transaction detail
1x dataset for my subreport (1x tableadapter to transaction detail - no relationships)
1x reportviewer
2x objectdatasources (one for each tableadapter)
My problem is the parameters I've set up don't seem to be filtering any data when I click to view the detail of a transaction. Can someone maybe explain to me in detail how subparameters get passed to an objectdatasource to filter data? Do I need to include a where clause in my select statement?
Here is the report I've created so far:
faulty-report.jpg
I'm having a hard time creating a master-detail report in VS2010. I have the following:
1x Master report for my transaction header info
1x dataset for my master report (with 1x Tableadapter to the transaction header table - no relationships)
1x Subreport for my transaction detail
1x dataset for my subreport (1x tableadapter to transaction detail - no relationships)
1x reportviewer
2x objectdatasources (one for each tableadapter)
My problem is the parameters I've set up don't seem to be filtering any data when I click to view the detail of a transaction. Can someone maybe explain to me in detail how subparameters get passed to an objectdatasource to filter data? Do I need to include a where clause in my select statement?
Here is the report I've created so far:
faulty-report.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Eventually figured it out
Cheers!
Caltain