JeffvClayton
asked on
VB.NET Crystal Report Designer
I am just provisionally testing producing a Crystal Report using the embedded CR Designer in VB.Net 2005. I intend to produce a report from an xml file exported from filling a Datatable. To test the technology I have exported a crosstab query from Access 2003 to an XML file. I have then added a new crystal report via the solutions explorer and selected the xml file as the datasource. I have added a few fields to the report from the field explorer and pressed the main report view tab.
The problem is the field headings are showing but the data seems to be some sort of microsoft test data i.e. days of the week and list of colours etc that have nothing to do my data, what happened to the data in the xml file? I double clicked on the xml file which opened in the browser and all the data is present and correct?
I am obviously missing some steps?
I also noticed that Crystal report help (VB.Net embedded) says its only compatible with XML in SQL Server 2005. Does this mean I can't export from a datatable to XML and run a crystal report?
The problem is the field headings are showing but the data seems to be some sort of microsoft test data i.e. days of the week and list of colours etc that have nothing to do my data, what happened to the data in the xml file? I double clicked on the xml file which opened in the browser and all the data is present and correct?
I am obviously missing some steps?
I also noticed that Crystal report help (VB.Net embedded) says its only compatible with XML in SQL Server 2005. Does this mean I can't export from a datatable to XML and run a crystal report?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
managed to press submit before finishing but basically all works wihtout using xml.
ASKER
What I wanted to do was design a crystal report template with relevant formulas based on the fields etc., layout the fields and headings, shading and other design attributes and test it. I have done this by making a temporary access table and setting it as the datasource.
The actual data would eventually be in the same fields as the access table but extensively manipulated in code using datatables, the final datatable i then needed to attach to my report template. Got it all working as follows:
1. Make temp access table and design report layout.
2. Make datatable with actual data
3. Link them
Dim cr As New CrystalReport1
cr.Load(clsGlobal.gsPath & "CrystalReport1.rpt")
cr.SetDataSource(DT)
CRV1.ReportSource = cr
CRV1.Show()