I have a Crystal report that resides on a Server. The report was created with recrystallize via ASP. Thus, .rpt, .asp and parameters.asp control this one report. This report grabs fields from an Oracle Database based on an "event number".
Now, I have a MS Access document that I need to link to the above crystal report that also has an "event number". I created a hyperlink within MS Access that basically calls the above asp based on the displayed event number that's being displayed within MS Access.
Page being called in IE,
However, I'm having a problem and I suspect it has something to do with CR security, etc. When I click on the hyperlink in MS Access I will get a "User session has expired" or if I recently called the same report via another methond, I get the previous event number that I queried. Now, in the address bar, I see the correct event number that I'm trying to populate, but again, a previous event number is actually being displayed. To solve either of these problems, all I have to do is just hit the refresh button on Internet Explorer program, not the CR Server refresh icon. However, this is not acceptable because the user would always assume that the correct event is being displayed if they don't remember to always click the refresh button.
I've read the white page on CR site for :User session has expired" but I don't think it covers my situation.
Any thoughts? Thanks
Now, I have a MS Access document that I need to link to the above crystal report that also has an "event number". I created a hyperlink within MS Access that basically calls the above asp based on the displayed event number that's being displayed within MS Access.
Page being called in IE,
However, I'm having a problem and I suspect it has something to do with CR security, etc. When I click on the hyperlink in MS Access I will get a "User session has expired" or if I recently called the same report via another methond, I get the previous event number that I queried. Now, in the address bar, I see the correct event number that I'm trying to populate, but again, a previous event number is actually being displayed. To solve either of these problems, all I have to do is just hit the refresh button on Internet Explorer program, not the CR Server refresh icon. However, this is not acceptable because the user would always assume that the correct event is being displayed if they don't remember to always click the refresh button.
I've read the white page on CR site for :User session has expired" but I don't think it covers my situation.
Any thoughts? Thanks