How do I improve Crystal Reports 2008 performance?

Any inputs on improving Crystal Reports 2008 performance?

The rpt files used in both the application (VB and c#) are same. Only difference is crystal version is different. (for VB its crystal 2006 and C# its 2008)
Quick-SPO-Performance-Testing.xls
LVL 13
SameerJagdaleAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
There is no CR2006.  I assume you really have CR XI.

You are most  likely using much different calling methods and display methods.

The VB6 is probably using the RDC which no longer exists in CR2008.

The differences may be in the Crystal viewer or your code.

Are they running on the same machine?

Same OS?

Obviously the C# is running in the .Net framework while the VB is running as a COM application.  That could be the difference.

mlmcc
0
SameerJagdaleAuthor Commented:

mlmcc,

rpt files are of CR 6.

Following is the architecture for both the apps
-  You fetch data from mainframe
-  parse and store the data in local mdb
-  bind the report to mdb

 
The logic of parsing and storing the data into local mdb differs in both the apps. Resultant mdb is same in both the apps. Also query for fetching the data from the mainframe is same. Also there is a difference in CR versions as stated earlier.
 

- VB6 uses RDC which no longer exists in CR2008 !!
 
Sameer: is it valid in the above architecture?
 

- C# is running in the .Net framework while the VB is running as a COM application.  
 
Sameer: Yes (for both the points), but I need some artifacts to support that CR 2008 takes more time than CR6 to display the report if the architecture and other parameters like hardware etc. remain same.
Any help would be appreciated!
-Sameer
0
mlmccCommented:
Did you import the CR6 files into CR2008 and then save as CR2008 files or are you using the same report files for both applications?

Since it is CR6 you are probably using the OCX rather than the RDC.

mlmcc
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

SameerJagdaleAuthor Commented:
They are the same rpt files directly reused in 2008.
0
mlmccCommented:
The problem is when you open it in CR2008, it takes time for CR2008 to convert it from the CR6 format to CR2008 format.

Have you tried opening the report in CR2008 then saving it.
Make a copy of the report.  Once changed it cannot go back to CR6 format.

Use that one in the CR2008 application. CR6 cannot open it.

mlmcc

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
SameerJagdaleAuthor Commented:
Well,
I presume there could be multiple factors affecting the performance. mlmcc did help me to understand some.. thanks for that.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.