Crystal Asp.Net Report
I am working in Visual 2008 with SQL Server 2005 as the back end. I am trying to create a crystal report with an xsd file. This is what I did.
I created an empty xsd file from "Add New Items" .i dragged the saved proc from the server explorer from the database I want to attach to the crystal on the xsd.
Created a blank crystal report, connected the xsd file to the report via Create New Connection and selected the fields that I want to display in the report.
Now when I do a print preview of the report, I am showing the garbage data, not the actual data returned by the stored procedure.? I cannot understand this behavior.
Am I missing something?
a source to share
Thats Crystal Reports for you. What you are describing is typical behavior that is not worrying. I've written some reports specifying .xml or .xsd document as datatype (you need to remember ADO.NET selection to add connections for next steps). When I go to run the report, I simply specify the actual data type that I am getting from SqlServer / Oracle / etc by doing the following
report.Database.Tables[0].SetDataSource(dataTable);
As in the preview area, I get fake values, although my XML file may contain the actual data along with the schema, but when I actually run Crystal Report, I get the expected result.
a source to share