My report takes about a minute + to run, has two subreports and only a few tables that are joined as recommended. Any assistance would be greatly appreciated.
Answer
Report Designer performance troubleshooting
Best answer by dgross
HI Chris, thanks for checking in. I believe the issue is with a join in the main report which is using a parameter. I can’t quite understand why this would precipitously drag the performance down so much but I think it is.
+10Considering each report can be unique you can not rule out a general solution.
Can you please
- either provide the joins you are using as a SQL query?
- If not, in the “Relationships” tab select each pair of the joined tables and make screenshots and provide here so that we can rebuild the joins.
- if not, attach your report here. Note, we can not test the report if you have custom objects/fields in your report as it is going to be time-consuming to recreate widgets.
Reza Aghaei CPA, M. Acc. & Acumatica Customization - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Hi
Adding to the above, attach the .rpx file of main report and sub reports as well.
Regards,
VijayKumarU
Thanks for offering to take a look. I have removed all custom/attribute/item class references as best I could so this should work in a testing environment.
+10Sorry, I do not have any FS data that I can test.
Hi
HI Chris, thanks for checking in. I believe the issue is with a join in the main report which is using a parameter. I can’t quite understand why this would precipitously drag the performance down so much but I think it is.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.