By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,384 Members | 671 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,384 IT Pros & Developers. It's quick & easy.

Bind multiple tables values in Data Report

P: 1
Friends, I had designed an project using VB 6.0 and SQL 2008. Data Storage part is over. Now i am stuck up with display multiple table values in Data Report.

Please find my tables and values in Attachment 1;

Please find the dataraport design which i want to display to the end user in Attachment 2.

I am facing problem in Data Report because the multiple recordset is having issues. So I go with SHAPE as follows;

Please find the code in Attachment 3

I am facing Error message as Error message coming as " Datafield Command2.FSD_Amount not found"

Please guide me to fix the issue.

Thank you.

Attached Images
File Type: jpg Tables + Data.jpg (211.0 KB, 16 views)
File Type: jpg Data Report Design.jpg (56.7 KB, 17 views)
Attached Files
File Type: doc CODE.doc (28.5 KB, 29 views)
Dec 10 '18 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.