Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: CrystalReports
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 13-Aug-12 21:42pm

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

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
  Permalink  
Comments
itsureshuk at 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)



Advertise | Privacy | Mobile
Web02 | 2.8.141022.2 | Last Updated 14 Aug 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100