Click here to Skip to main content
15,920,005 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Good noon Frds,
In Crystal Report Creation .....Whether using Dataset or Database tables is best...What is the difference for the use of dataset and database...
Also i have to bind 15 textbox values in the crystal report...for that i have taken 2 tables from dataset,but it binding first table values only....
Posted

1 solution

Dataset is a collection of datatables.


You can have one or more datatables in dataset and also u can put your database tables directly by drag n drop in dataset.xsd pane

problem to your solution is ..take only one datatable in dataset which will contain fields from multiple tables from your datbase.

once the datatable has the values..u can populate it in the report.

goto dataset.xsd pane..right click then table adaptar..then u have to give sql query there ,which will fetch all fields that u want from multiple tables from your database..then click next and finish..datatable will be genarated automatically..


then while creating report select that dataset and fields that you want to display in the report..and then design report and poplate fields on report..thats what u need to do to show data from multiple tables in crystal report
 
Share this answer
 
Comments
itsureshuk 14-Aug-12 6:01am    
Thanks

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