Jump to content

Has anyone had any experience with developing a report that ...


Kristi Carter

Recommended Posts

Has anyone had any experience with developing a report that is set for ON TABLE PCHOLD FORMAT AHTML. -DEFAULTH &WF_ARVERSION=2;

Then include a drill to another report in this report and when it runs the more records it has for the initial report the longer it takes to run. However when we remove the drill link in the report it runs much faster.

We have troubleshooted so many scenarios and everything seems to come back to the report having a drill option to another report.

We have even tried SET ARCOMPRESS = OFF with also ENGINE INT CACHE SET OFF, however it didnt seem to make a difference.

Article for this: Controlling the File Compression of Interactive Reports

Any suggestions to make performance better

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...