Comments by Kamal Mohan Pillai

Kamal Mohan Pillai 6-Nov-13 4:51am View

Hi, i checked the link and rewrote the code. But the problem is in .rdlc design file only one dataset can be used and hence only data from that table is displayed. The sql query is providing the desired value .

Kamal Mohan Pillai 6-Nov-13 1:11am View

Thanks keerth.

Kamal Mohan Pillai 6-Nov-13 0:27am View

Do i need to create a table for this query? Or how to access the query from the .rdlc file. the .rdlc file is asking for tables to connect. I am using C#, WPF.

Kamal Mohan Pillai 6-Nov-13 0:07am View

I have three tables. Order_Details, Order_Products, Products_Master.

Order_Details and Order_Products have OrderID in common and Order_Products and Products_Master have ProductCode in common.

I have to get the last entered OrderID and get its details from Order_Details and Order_Products. Also i need to get the ProductName from Products_Master where ProductCode is the code i get from Order_Products.

I assume you got it.

Kamal Mohan Pillai 6-Nov-13 0:00am View

Hi, thanks for the reply. I haven't added a relation between the tables yet. If i relate these tables will it be easier? If that is the best case then i would do that.

Comments by Kamal Mohan Pillai (Top 5 by date)