Crystal report refresh issue in visual studio 2010

[Former Member]

I have deployed an asp.net web application in IIS server. In which I have used Crystal Report (Version 13.0.0.99) for some basic reporting options. All the functionalities are working fine except the loaded data. The filter which I intend to pass as a parameter works fine in initial page load (All those parameters are just WHERE clauses which will be applied to SQL query). When I use refresh button in the Report all the filters removed automatically and all the records are being taken from the database. It looks so weird that how this is happening. Please help me out to overcome this issue. Thanks in advance.

[DellSC · Accepted solution]

You are using the original version of the SDK - it's now on SP 16 and there have been a LOT of updates and fixes!

The first thing I'm going to suggest that you do is upgrade to the latest version of the SDK, which you can find here:  .  The "Install Executable" does the integration with the Visual Studio IDE and the other installs are various types of runtime installs for use when deploying your application.

You'll have to recompile the application with the new SDK and then test it.   You'll also need to move the code that keeps the report in session from the PageLoad() event handler to the PageInit() event handler in order for it to work properly.

-Dell

[Former Member · Accepted solution]

Dell,

That is a great suggestion you arrived with. I upgraded to latest version and moved all the report block code in Init() event. Now the report working fine. but while I export, the page loading for a long time and stops automatically. Is there anything I am equipped with? Waiting for your valuable response.

[DellSC · Accepted solution]

This should really be asked in a new thread.  However,  I found a couple of things that may help resolve it:

If you're trying to set the file name for the exported file in your code, see here: 

Sample VB App for exporting:  http://wiki.sdn.sap.com/wiki/x/JQBmBQ

I know that this has been asked before and that there are other links out there - but I couldn't find them this morning.  If neither of these links help you, please post a new question about the issue and I'm sure someone will have some additional information for you.

-Dell

<Edit>

I also just found this thread:  .  It's not answered yet, but someone else is currently having the same issue.

</Edit>

Message was edited by: Dell Stinnett-Christy

[Former Member · Accepted solution]

Dell,

You saved my time and it helped me alot. I fixed the issue when I change the logic. IT was completely a POSTBACK issue. Modified the code and it works just awesome. Thank you so much