Hey Richard,
Thanks for the quick feedback on this.
So I've done more digging and did find a few instances where performance was impacted with the GL Trial Balance as a result of several accounts being used/available (Account Drop down list).
What was needed in those instances was hard coding the accounts being used on the report. Maybe this is something that can be leveraged here as well?
To modify the report, you can go to the SSRS Report Manager site, and click on the drop down next to the SSRS GL Trial Balance Detail or Trial Balance Summary Report, then select Edit in Report Builder. Once Report Builder is installed and the report is opened, you can expand the Parameters folder.
Once you have expanded the Parameters folder, right click on the I_cStartingAccountNumber parameter, and select Parameter Properties. Click on the Available Values tab in the Report Parameter Properties window, and select None. Then click the Default Values tab, and select No Default Values. Click OK.
Repeat this step for the I_cEndingAccountNumber parameter as well, then click the Save button in Report Builder.
I hope the above helps out.
Let me know either way!
Wishing you a wonderful rest of your day!
Nicole Fiskum
Support Engineer
Microsoft Dynamics
