.Net Crystal Reports Viewer against Crystal Reports 2011
Hi,
I have a Crystal Reports which I executed in Crystal Reports 2011 and it runs well, but when I run the same report using the Crystal Reports Viewer using a Windows Application in Visual Studio.Net 2005(Visual Basic) it takes a lot of time to come up the report after I provide the parameters.
In other words I use Crystal Reports 2011 to run a report and it takes around 45 seconds to come up, by the other way I developed a Windows Application which uses the Crystal Reports Viewer and It takes a lot of time to come up with the resulting report. It takes around 12 minutes to come up Vs Crystal Reports which takes fewer.
My Visual Basic.net 2005 Application process a selected report by the user, apply the logon credentials to all the tables of the report, then it delegates the run process to the Crystal Reports Viewer. The Crystal Reports Viewer asks for the parameters and after provide them is when the issue happens.
.net Crystal Reports Viewer runs very slower than Crystal Reports 2011.
Please, any help will be appreciated.
I have a Crystal Reports which I executed in Crystal Reports 2011 and it runs well, but when I run the same report using the Crystal Reports Viewer using a Windows Application in Visual Studio.Net 2005(Visual Basic) it takes a lot of time to come up the report after I provide the parameters.
In other words I use Crystal Reports 2011 to run a report and it takes around 45 seconds to come up, by the other way I developed a Windows Application which uses the Crystal Reports Viewer and It takes a lot of time to come up with the resulting report. It takes around 12 minutes to come up Vs Crystal Reports which takes fewer.
My Visual Basic.net 2005 Application process a selected report by the user, apply the logon credentials to all the tables of the report, then it delegates the run process to the Crystal Reports Viewer. The Crystal Reports Viewer asks for the parameters and after provide them is when the issue happens.
.net Crystal Reports Viewer runs very slower than Crystal Reports 2011.
Please, any help will be appreciated.
ASKER
Actually I did a change to the report using The Crystal Reports embedded with Visual Studio and when I preview the report using Visual Studio 2005 it runs as Crystal Reports 2011 does(regarding the time it takes), but when I run the Windows Application to use The Crystal Reports Viewer to execute the report the same is happening(It takes a lot of time to generate the report).
WHen you changed the report in VS2005 it changed the report file format.
mlmcc
mlmcc
ASKER
I think that Yes, because I save it using Visual Studio and it changed from 37.5 KB to 38 KB of size and its modified date & time change to a new one.
Are you sure you are setting correctly the connection data in VS2005? How many subreports do you have in this report?
ASKER
One SubReports. I set well the data because it finally comes with the resulting report, but after more than 12 minutes.
Do you have the option "verify on first refreh" ON ? You may try what will be the difference if you turn it off.
If you are setting the connection in code, check if this code works. For example if possible set the report to use Integrated security and comment your code to set the connection in VS2005. Then check if the report is running faster.
What is the version of the referenced crystal dlls ? If you are using components distributed with VS2005 there will be a conversion.
Are you running the report from the same computer in both cases ( 2011 and 2005) ?
If you are setting the connection in code, check if this code works. For example if possible set the report to use Integrated security and comment your code to set the connection in VS2005. Then check if the report is running faster.
What is the version of the referenced crystal dlls ? If you are using components distributed with VS2005 there will be a conversion.
Are you running the report from the same computer in both cases ( 2011 and 2005) ?
ASKER
I verified, and the report doesn't have the "Verify on First Refresh" checked. The reference Crystal Dlls are the ones which comes with the FrameWork 2.0.
See one thing that I found right now. I went to the Crystal Reports Viewer Control and pointed it to the Crystal Report I'm trying to run, but using the "Choose a Report" Link in Visual Studio. In other words Instead of using the Load function in code in Visual Studio, I set the Report Viewer to directly pointed to the Crystal Report I'm trying to execute and I run the application by initially runs the forms which has the Crystal Reports Viewer that I set, and in this way the report runs at an acceptable time(20 seconds I think). Could this bring an idea about what is happening?
See one thing that I found right now. I went to the Crystal Reports Viewer Control and pointed it to the Crystal Report I'm trying to run, but using the "Choose a Report" Link in Visual Studio. In other words Instead of using the Load function in code in Visual Studio, I set the Report Viewer to directly pointed to the Crystal Report I'm trying to execute and I run the application by initially runs the forms which has the Crystal Reports Viewer that I set, and in this way the report runs at an acceptable time(20 seconds I think). Could this bring an idea about what is happening?
Can you save the report in VS2005? Obviously you have issues with loading the report not running it.
If the report is saved in 2011 and you are loading it with VS2005 there may be a conversion behind the scenes each time when yoy run the report.
If the report is saved in 2011 and you are loading it with VS2005 there may be a conversion behind the scenes each time when yoy run the report.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
I've requested that this question be closed as follows:
Accepted answer: 0 points for ialsina's comment http:/Q_27431652.html#37094628
for the following reason:
Thank You for your prompt attention and guide.
Accepted answer: 0 points for ialsina's comment http:/Q_27431652.html#37094628
for the following reason:
Thank You for your prompt attention and guide.
Was any of the comments helpful ?
ASKER
When you told me to use the Integrated Security to apply the Logon Credentials to the Crystal Report I began to apply changes to the Application and when I pointed the Report Viewer directly to the Report instead of using code to load the report and use it in the Report Viewer I noticed that it runs at an acceptable time, instead of using the code and apply logon credentials where I was using and applying the credentials with the DatabaseName Property that I mentioned before. In some way that particular comment move me for the solution. I don't know if it really is what you expect, but it really helped me since I was with this problem for more than one month ago.
Maybe you believe that your help wasn't enough but, you helped me in the sence that I was struggling with this problem weeks ago.
If you feel that I have to provide more info. Let me know and I will do so.
Maybe you believe that your help wasn't enough but, you helped me in the sence that I was struggling with this problem weeks ago.
If you feel that I have to provide more info. Let me know and I will do so.
ASKER
I agreed to object since I'm not an expert in this web site, but I could read that this question can be moved to a different forum like the Community Support. I apologize, I delegate to you what should be made with this question.
If a comment(s) was helpful in getting to the solution you can accept your comment as the solutionn and use the comments as assisted solutions awarding some or all of the points.
mlmcc
mlmcc
ASKER
Thank You for help me to trace where the problem can be. Your iteration and guide was help for me to analize and detect where the problem should be.
SAP/Crystal recommends using VS2010 and the Crystal assemblies for CR4VS2010.
The Crystal assemblies in VS2005 are version 10.2 and as such probably have to convert the report to the older format and eliminate any CR2011 features that aren't supported.
mlmcc