Report not refreshing when using .NET runtime

[Former Member]

Hi all,

we are using Crystal Reports XI to build reports on Frontrange ITSM data in a sqlserver database.. and using the CR XI .NET Runtime to view the reports embedded in the ITSM application.

Now, if I run a report, then modify the record in the application and run the report again, it is not showing the updated data - that's with the .NET thing

But if I run the report in CR XI Designer, update the record in the app and run the report again in the designer, it does refresh..

Thanks for any help/insight !

Antoine

[Former Member · Accepted solution]

HI Antoine,

Are you changing the schema of the report at runtime? If yes then it is not possible without using RAS sdk available using CRXI Developer edition of Crystal reports product. For any change made in the report structure or database schema you need to open the reports in designer, update the fields, save it and then use it in application.

To pass parameter at runtime you can use the SetParameterValue() method in .net so that you can pass parameter to report through code. I mean if you apply this code in a button click event then everytime you want to update the parameter you can click on the button rather than hitting the refresh button of viewer control.

If you want you can have a look at the samples [here|https://boc.sdn.sap.com/node/7770].

Does that help?

AG.

[Former Member · Accepted solution]

Thanks AG, but, sadly, I am not coding, I don't have access to the code here. The situation described is with Frontrange ITSM 5074 and the .NET Runtime of Crystal Reports XI.. What I am looking for is some parameter(s) in the report or in a config file somewhere, that would force the .NET Runtime to behave like the Developer version does, ie, refresh data..

cheers,

Antoine

[Former Member · Accepted solution]

HI Antoine,

As far as my knowledge goes, web.config file do not have any options to send parameter to the page that is calling the report and viewing the report, it is generally passed from that page itself from asp or code behind page. However we can try putting a globalized function in the config page so that it can get execute but we need to call it up otherwise it will be just like a one time hit thing. I mean it will executed just once. (At least I have never tried that or know if that could be done. However I am going to give it a shot but that might take time, in the meantime lets see if someone else has got some idea about it. Sorry!)

The only option that I can see for this is to use the viewer's refresh button to call the reports default properties, which will bring in the parameter page so that we can pass the new parameters to the report. Hitting the browser's refresh button may not work as it might just let the viewer pull the same data if the code is not written in Page_Load/Init event, which we may not know as we do not have access to that...

Hope that keeps you going for some time till we hear something else...

Regards,

AG.