build crystal report from xml file

[Former Member]

hi u all,

i have tried to make a crystal report file using a xml file that generated from a dataset via coding (vb2005 express edition). that rpt file then i use to view the data that i query from database mssql. the problem is whenever i set property 'report source' of 'report viewer', the program will generate error message "Failed to load database information". how can i fix it?

i appreciate all kinds of suggestion. fyi, if i make the data of the rpt file static, then the error won't happen.

for xml, how must i set the logoninfo?

[Former Member · Accepted solution]

Hi

Need more information -

CR Version?

There is no need to set the logon info for XML files.

NOTE VS express edition is not officially supported with crystal reports(Stand alone product).

It might be possible that the dataset you're creating at runtime does not match the schema that the report was designed with.

The simplest thing to do is write out the dataset to XML with Schema after you fill the dataset. Once you've written out the dataset you can go back to the report in Crystal Reports itself and try to point the report to the XML file directly.

Hope this helps!!

Regards

Amit

[Former Member · Accepted solution]

i ve tested to make the program via VB.Net 2003 and it successfully achieved it. but in my program, i want to use the maskedtextbox control. AFAIK, in vb.net 2003 we don't have that control.

so i guess if vb2005 can make me achieve that goal, i will consider to use it.

do you have any suggestion?

H.W.