Crystal Report Performence Issue

Hi All,

I am new in Crystal Report.net2005.
I have used VB.net Application, Access 2003 as back end database.
I am using dataset for viewing crystal report.

My prob is that:

For th first time my reports are taking too much time to show.
But the next time it's not taking so much time.

It's happening every time when i exit the application.

Please give solution

Thank in Advance

Mayukh.What happens if you run the Crystal generated SQL directly in Access? Is it slow the first time and quicker next time?|||First time to make connection and pull data it takes sometime. But next time it would be faster as connection is already there until you refresh the report

Crossjoining data from 2 datasets

Hi,

I have one dataset DS1 connected to one SQL 2005 server DB, another dataset DS2 to different server on different physical machine, different SQL 2005 DB. I'm trying to build only one chart which data is based on those two different datasets DS1 and DS2. I understand that I can use subreports to use two different datasets, but how can I crossjoin those data together in one chart?

Thanks!

You need to combine the two datasets already in the dataset query. Some options to consider:

? Linked Server functionality (see http://msdn2.microsoft.com/en-us/library/aa213283(SQL.80).aspx)

? OpenRowSet functionality to join data from another database server into the current query (http://msdn2.microsoft.com/en-us/library/ms190312.aspx, http://msdn2.microsoft.com/en-us/library/aa276850(SQL.80).aspx)

-- Robert

|||

Thanks a lot Robert!

Linked server helped a lot!

Crossjoining data from 2 datasets

Hi,

I have one dataset DS1 connected to one SQL 2005 server DB, another dataset DS2 to different server on different physical machine, different SQL 2005 DB. I'm trying to build only one chart which data is based on those two different datasets DS1 and DS2. I understand that I can use subreports to use two different datasets, but how can I crossjoin those data together in one chart?

Thanks!

You need to combine the two datasets already in the dataset query. Some options to consider:

? Linked Server functionality (see http://msdn2.microsoft.com/en-us/library/aa213283(SQL.80).aspx)

? OpenRowSet functionality to join data from another database server into the current query (http://msdn2.microsoft.com/en-us/library/ms190312.aspx, http://msdn2.microsoft.com/en-us/library/aa276850(SQL.80).aspx)

-- Robert

|||

Thanks a lot Robert!

Linked server helped a lot!