Web Development

Ask something
Discussion Locked

Getting XML report from Crystal Reports

0 helpful
3 replies

by d_sanaz

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

We are going to develop our database project using SQL Server 2000. So, we want to put some of our reports on the web.
First, which method should we follow to do that.
Second, If we want to get our XML files from our reports generated by CrystalReports, what should we do ? Is it better to get our XML directly from database ?

Thanks

3 replies

by madestroitsolutions

You have to be more specific. Is the database going to be sitting on your web server? If that is the case, then you have everything you need on SQL server. It will provide XML output for you. The report is nothing more than a SQL Query issued to theSQL Server, which in return will send you the XML output, given that you specify this option of course.

Hope that helps.

Good Luck!

by d_sanaz

First, We don't want to put our databases on web because of
our project's security needs.
Exactly we want to know whether we should convert our SQL
Server databases to Crystal Reports Tables and then to XML
files or convert SQL Server databases directly to XML files.
Thanks a lot

by madestroitsolutions

You don't seem to understand the way SQL server and crystal reports work. Crystal Reports is capable of connecting to SQL server and generate reports from it. Crystal Reports supports XML, so it can generate the XML code for you, or if you prefer, you can just get the XML out of SQL Server. If you are familiar with XML, you will know that XML is simply organizing the information in a standard layout, so that it becomes sharable. What method you use? that is up to you. I would personally do it straight from SQL server.... why take an extra step.

By the way, in my last answer I asked you to explain a little, since your original posting was not clear as to what you wanted to do, so you don't have to REJECT my answer ( it hurts my rating :-0 ) because I was not wrong, just malinformed. Simply dont rate the answer yet.

Good luck, bye

This discussion is closed to new replies.