nastyitchy1
IS-IT--Management
We have numerous reports which I am in the process of moving to a web based system but I am having problems with the Web Report Server.
The system is working on an ASP/Form system which builds the URL for the report and uses a respose.redirect to the specific report using the URL parameters.
We are having a lot of trouble with the cache setup of the server tool whcih seems to want to cache everything and tis brother at the moment even though we've set everything to minimal settings according to the manual and various Knowledge base articles.
For example. A report has the following selection formula.
(if {?PromptX} <> 'Default Value' then
{Cutomer.IDNumber} = {?PromptX}
else True)
and
(if {?PromptZ} <> 'Default Value' then
{Customer.Location} = {?PromptZ}
else True)
After a bit of code the URL is sent as .....rtp?prompt0=SMITH1234&prompt1=UK
There are other bits to the record selection ans using the sf= command is not an option as it is too basic.
We've tired various combinations of rf= and promptonrefresh= but the main problem is this.
Loading up the initial page and choosing the parameters and running the report produces results that are expected. However if the report is run again, by going back to the asp page, the report then runs but only uses the previously reported on records, which, more often than not, return 0 records.
A work-around is to close the browser and to rerun the report with the new parameters but according to the literature we shouldn't have to do this.
Another point. Because the prompts are used in the record selection they appear before the report is run in Internet Explorer even though the values have already been set by the asp page. Is there any way to include parameters in a report without them appearing on first run?
Thanks very much in advance.
The system is working on an ASP/Form system which builds the URL for the report and uses a respose.redirect to the specific report using the URL parameters.
We are having a lot of trouble with the cache setup of the server tool whcih seems to want to cache everything and tis brother at the moment even though we've set everything to minimal settings according to the manual and various Knowledge base articles.
For example. A report has the following selection formula.
(if {?PromptX} <> 'Default Value' then
{Cutomer.IDNumber} = {?PromptX}
else True)
and
(if {?PromptZ} <> 'Default Value' then
{Customer.Location} = {?PromptZ}
else True)
After a bit of code the URL is sent as .....rtp?prompt0=SMITH1234&prompt1=UK
There are other bits to the record selection ans using the sf= command is not an option as it is too basic.
We've tired various combinations of rf= and promptonrefresh= but the main problem is this.
Loading up the initial page and choosing the parameters and running the report produces results that are expected. However if the report is run again, by going back to the asp page, the report then runs but only uses the previously reported on records, which, more often than not, return 0 records.
A work-around is to close the browser and to rerun the report with the new parameters but according to the literature we shouldn't have to do this.
Another point. Because the prompts are used in the record selection they appear before the report is run in Internet Explorer even though the values have already been set by the asp page. Is there any way to include parameters in a report without them appearing on first run?
Thanks very much in advance.