Click here to Skip to main content
15,887,596 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
in my project the rdlc report donot display the datas in the dataset..
i fetch the datas from 3 tables in db,the values are successfully shown in the dataset query builder that is in Table Adapter Configuration wizard .but the values donot disply in the report.rdlc .
i also tried the selection of datas from 2 tables thats successfully shown in the report.

the below is the query i tried in the query browser..
SQL
SELECT        table_customer.name, table_customer.customer_id, table_customer_payment.bill_no, table_customer_payment.bill_date, table_customer_payment.payment_date,
                         table_customer_payment.payment_amount, table_customer_payment.username, table_sale1.total_amount
FROM            table_customer_payment INNER JOIN
                         table_customer ON table_customer_payment.customer_id = table_customer.customer_id INNER JOIN
                         table_sale1 ON table_customer_payment.bill_no = table_sale1.bill_no

any solution for this pblm...???
Posted
Updated 2-Mar-13 5:14am
v2
Comments
Sandeep Mewara 2-Mar-13 11:15am    
Have you dragged-dropped a table and mapped the fields to be displayed?
sabodh 2-Mar-13 11:18am    
yes i dragged the third table to the dataset ..is any pblm for that?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900