How to use Crystal reports with multiple table data RRS feed

  • Question

  • User1171172248 posted


    I have a crystal report which uses ms access database. This database has 5 tables. Now i want to use data from all these tables in the crystal report. How can i embed multiple table data(fields) in a single crystal report. i am using C# + asp.net.


    Monday, June 9, 2014 4:46 PM

All replies

  • User-1941247845 posted

    You can have XSD mapping file ( which would be treated as a DataSet) with the required tables and fields. The same can be selected as a datasource and you can have those fields used in your report. In your code behind fetch your actual datas from DB and then populate them into a Dataset (should have similar tables and structure like the XSD) and then bind the same to teh report datasource.

    Hope this helps.. 

    Tuesday, June 10, 2014 3:03 AM