Kristi Carter Posted November 5, 2021 Share Posted November 5, 2021 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 More sharing options...
Sarah Buccellato Posted November 11, 2021 Share Posted November 11, 2021 Kristi, Id recommend opening a support case. Link to comment Share on other sites More sharing options...
Kristi Carter Posted November 11, 2021 Author Share Posted November 11, 2021 Thanks Sarah. I have also done that as well. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now