Click here to Skip to main content
13,088,299 members (39,619 online)
Rate this:
Please Sign up or sign in to vote.
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 13-Aug-12 21:42pm

1 solution

Rate this: bad
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
itsureshuk 14-Aug-12 6:01am

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web01 | 2.8.170813.1 | Last Updated 14 Aug 2012
Copyright © CodeProject, 1999-2017
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