hyperlink problem using ePortfolio

[issdvas]

I am using the following:

CR version – 10
CE version – 10
Oracle database

I have 5 reports saved in CE10.
The user navigates to the 1st report through ePortfolio.
The 1st report hyperlinks to the second, passing only a report number.
The 2nd report has a hyperlink to the 3rd and passes just the report number.
The 3rd report has a hyperlink on the hospital name field to the 4th and passes the report number and a hospital name.

All of the above works just fine.
Here’s the problem:
The 4th report hyperlinks to the 5th report and passes the hospital name and a doctor’s name.

The doctor’s name is one field with the format: LASTNAME, FIRSTNAME
To further complicate matters, the last name can be hyphenated.

In report 4, I break the name down into parts:
mdlastname
mdlastnamept2
mdfirstname

I then send these parts to the 5th report in a hyperlink using promptex:

"

http://servername/crystal/enterpris...romptex-attendingfirst="&{@attendingfirst}&""

I use the following statement to select based on the parameters in the 5th report:

if {?attendinglastpt2} = "" then { CURRENTATTENDING} startswith ({?attendinglast} & ", " &{?attendingfirst})else
{CURRENTATTENDING} startswith ({?attendinglast}&"-"&{?attendinglastpt2}&", "&{?attendingfirst})

the 5th report is displayed without data the first time I try the hyperlink, even though the url address contains all the name items

when I click on a different name, the hyperlink work and I can then go back and click on the first name successfully.

Anyone have any ideas why this is happening?

Thanks,
G

 

[mdwyer]

No replies? I'm no expert, but I wonder about a caching problem. One trick we've had to use in other situations is to add a timestamp field to the hyperlink so that it is always different.

 

[issdvas]

I stuck this timestamp field at the end of the hyperlink, but the result is the same:
&timestamp="&CurrentDateTime&"

is this the same sort of syntax you used?

thanks for your help