IWR - Reports with Joins Not Running (or indefinitely)

[browna2000]

Have a catalog. Two tables with an equi-join, ID=ID. Run the report in Impromptu = looks great. Publish the report to the web - the report seems to run indefinitely.
For reports that deal with only one table (no joins in the catalog) = they publish fine to the web.)
Also, the ad-hoc works great on the web.
It just seems that any reports which require a join to another table don't publish or we can't get them to run. Again, in the catalog we set the equijoins up.

Any thoughts are appreciated.
Angela

 

[scost]

You may want to check your .ini files that are on the machine that is running IWR. There may be a difference in the .ini files that are on your client machine where you are running Impromptu and the files that are on the server. Also, what type of database are you running against?

 

[browna2000]

Thank you for the information. The reports are developed and published all on the server side. We are using MS SQL2K.

 

[dennydm]

Hi,
when we faced similar problems, we tried to restart the services on Upfront server and the IWR server. That used to help a lot.