General discussion

Locked

Getting XML report from Crystal Reports

By d_sanaz ·
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

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Getting XML report from Crystal Reports

by MadestroITSolutions In reply to Getting XML report from C ...

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!

Collapse -

Getting XML report from Crystal Reports

by d_sanaz In reply to Getting XML report from C ...

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

Collapse -

Getting XML report from Crystal Reports

by MadestroITSolutions In reply to Getting XML report from C ...

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

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums