Hi All,

The report design has a crosstab with one column and one row. The crosstab displays row values for each date in the date range selected. The data is sourced from a MySQL ODBC connection.

From designer am able to view all the dates selected in the cross tab. For example 12/1, 12/2, 12/3 so on until 12/31.

However, while running the same report from crystal enterprise I am only getting one record (12/31) for the entire date range when exporting to excel.

Any suggestions on how to fix this are very much appreciated.

Thanks,

-----------
In other words when the data is truncated while running the report from cyrstal enterprise infoview since its using the ODBC driver to MySQL. The data shows up fine in the crystal designer.

Edited by svap09 - 13 Jan 2011 at 12:49pm