Crystal Report does not show data when 1 of the 2 datatables in dataset return empty rows
Posted on 2004-04-27
Hi all, I'm using VS.net and crystal reports and currently facing this problem.
I have 2 datatables in the dataset
The first datatable is queried from the stored prod in sql sever 2000.
The second is a date, made into a datatable and added as a second table to the dataset that was queried
'Add datefrom and dateto into dataset
Dim dt As DataTable = New DataTable
Dim dr As DataRow
dr = dt.NewRow()
dr(0) = startDate
dr(1) = endDate
dt.TableName = "Table1"
The report shows fine when the first datatable return rows but when it the first datatable returns no rows, I still want the report to show the values of the secondtable.
Help Needed, Much Appreciated