"Kirk" wrote:

> Hello,
>
> I have an app that reads & writes to XML files.  I now would like to
> create some reports using Crystal Reports, and the usual way I do this
> is by creating a dataset in Visual Studio & inserting the fields
> graphically.  However, I cannot find out how to do this within the VS
> IDE.  I can create the dataset programatically like this:
>
>     Dim filePath As String = "C:\Temp\XMLfile.xml"
>
>     AuthorsDataSet.ReadXml(filePath)
>
>     DataGridView1.DataSource = AuthorsDataSet
>     DataGridView1.DataMember = "authors"
>
> ....but this created at runtime, and as such, I cannot use it at
> design-time for my CR design work.
>
> How can I create a dataset from an XML file at design time?
>
> Thanx in advance.
>
>

"Kirk" wrote:

> Elton,
>
> Thanks for your reply.  After some struggling, I was able to create a
> ttx file to use as I am designing my report (thank you!).  However, I
> am having a problem populating the report with data from my dataset.  I
> use the same code as above, but after I populate my dataset, I do this:
>
>    Dim crReport As New TcReport01
>    crReport.SetDataSource(AuthorsDataSet) 'Set the data source for the
> report
>    CrystalReportViewer1.ReportSource = crReport 'Set the report to view
>
> And all the report shows (in the detail section) is the default value
> in my TTX file.  For example, my TTX file looks like this:
>
>   ; Field definition file for table: ADORecordset
>   Description    String    20    Default
>
> But the the detail on the report always shows just "Default".  Can
> anyone see where I am going wrong?
>
> Thanks.
>
>

"Kirk" wrote:

> Elton,
>
> Thanks for your great response.  I followed your second option and was
> able to get my report to work!
>
> I changed the code to this:
>
> crReport.Database.Tables(0).SetDataSource(AuthorsDataSet.Tables(0))
>
> ....and it worked correctly.
>
> Thanks for following up with me and getting me past this hurdle.  I
> greatly appreciate your help!
> Kirk
>
>