View data in Crystal Reports when multiple DataSet tables

advertisements

I am using Crystal Report with VS 10,

I have added DataSet.

Now if There's only One Table in DataSet then data is being displayed, while if i add Two Tables with Link, then Data is not being display.

And i am taking fields from this table of DataSet(XSD).

How to overcome this problem.

Thanks In Advance. Khilen

You need to bind the DataTable(s) that you intend to use instead of binding the entire DataSet. This SO answer shows a very good example: https://stackoverflow.com/a/8341474/283895

(Code copied from that article)

ReportDocument rpt = new ReportDocument();
rpt.load();
rpt.Database.Tables[0].SetDataSource(ds.Tables[0]);
this.crystalReportViewer1.ReportSource = rpt;

Related Articles

C # Crystal Reports and XML Dataset (ADO.NET) Data Entry Issues

Afternoon Developers, I have a problem that's beginning to get on my wick. I have looked through google and Crystal Reports help and am still stuck for a solution. We have created an XSD complete with full information about data-types and the like. A

Crystal Reports - Create multiple PDF files from a report

Is it possible to print a report in Crystal Reports to multiple PDFs, for example if you had an invoice report that needed to be exported to individual PDF documents? I know this can be done manually, but I would like to set it up to automatically cr

NOT IN in Crystal Report with Multiple Data Sources

I need to do the following select for my Crystal Report: Select * from Table1 where ID not in (select ID from Table2 where mydate = @param) And to make things more complicated Table 1 & Table 2 are on two different servers (one is Access, one is SQL

Draw data from Crystal Reports

My data is stored in Oracle and the only way I can run a report with it is using Crystal Reports. I have a set of data that looks like this ,,,,,,,,,,1, or ,1,,,,,,, or ,1,,,,,1,,,,1,. There are more variations. Each one means a value is true for a r

filter data between 2 dates in crystal report vb.net

I need some help for creating Crystal Reports in VB 2005. I want to filter data between two dates (like from date and to date) with datetimepicker. I'm using SQL Server 2000 for the connection. Update: Thanks for the link, but I'm trying using record

Duplicate data in crystal reports

I am trying to load data from 3 tables in a crystal report. in each one, I have stored procedures that shows me the following data: The codes are: select distinct * from servicios where ID_Orden = @idordenrecibida SELECT distinct ID_orden, Consecutiv

Crystal Reports creates multiple pages

I have a crystal report, it has a 1 page report. when i tried to click print button to print, i noticed that it generates 8400 pages. What's wrong with that?!If the preview has 1 page but prints 8k then it may be a problem with the print driver. Can

View image in Crystal reports Use URL

I want to show image in a crystal report. Scenario is something like this. I have a database where my path of an image is persisting. eg ftp://Images/1.jpg Now i want to repeat this image in a crystal report. When i fills my datatable it shows me com

Filtering date in Crystal Reports

i am trying to filter date by month in Crystal Reports Formula but its not working Here is the Formula {Employees.d_o_b} = "yyyy-09-dd" in database date is saved in this format 2013-09-29 in a Date type filed i am using Sql Server 2008 and Cryst