web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Reporting Tools
Microsoft Dynamics SL (Archived)

Reporting Tools

(0) ShareShare
ReportReport
Posted on by SU-22040800-0 2,459

Doe anyone know of an add-on reporting tool for Dynamics SL (that is embedded within SL)..?

 

The reason I’m asking, is that I have made use of the Quick Query tool, but it seems to time-out on some large reports (from a custom VIEW I have built)… however, when I run a select * from the VIEW, directly in SQL Server Management Studio, it returns a result in under 30 seconds.. (and does not timeout)

*This post is locked for comments

I have the same question (0)
  • SU-22040800-0 Profile Picture
    SU-22040800-0 2,459 on at

    Just to add to this, what i have found is that the Quick Query tool runs the report script 3 times..  :(

    It first does a SELECT COUNT(*) FROM (select...) PagedTbl,

    then does a SELECT TOP 1 * FROM (select...) PagedTbl,

    then runs the full report...

  • Community Member Profile Picture
    Community Member on at

    Dynamics SL includes Crystal Reports so you should be able to create a report using your view.  You can then add that report to your Dynamics SL menu by taking the necessary steps to adding a report.  these include adding the report to screen maintenance, adding the report to report control maintenance, adding the report under menu maintenance and granting rights to this report under access rights maintenance.

  • SU-22040800-0 Profile Picture
    SU-22040800-0 2,459 on at

    Hi Rick

    I know of crystal reports, but the report doesn't give the same interface options as QQ screens do...

  • Community Member Profile Picture
    Community Member on at

    Is your custom view able to use an existing index? It wouldn't change running through the view 3x, but having an index available for the view could speed up the process.

  • SU-22040800-0 Profile Picture
    SU-22040800-0 2,459 on at

    Thanks Brian - i'll give it a shot!

  • Community Member Profile Picture
    Community Member on at

    Hi James - Did you have a chance to either modify your custom view or add an index that includes the fields being searched? I'm curious if either approach improved the QQ performance. I've worked with just modifying the standard views, and haven't seen the speed issue that you reported.

  • SU-22040800-0 Profile Picture
    SU-22040800-0 2,459 on at

    Hi Brian - No i didn't change anything extra. I logged a call with Microsoft support, and they are building a hotfix for the QQ.exe file. I'm hoping it will only query it once, and not 3 times (as mentioned above).

  • SU-22040800-0 Profile Picture
    SU-22040800-0 2,459 on at

    I'm expecting delivery of the hotfix mid February. If you would like to email me for a copy, feel free to do so - james.solomon@immix.co.za

  • Community Member Profile Picture
    Community Member on at

    We used a product called Inquiry.  Similar grid based output but more selection controls that QQ.

  • SU-22040800-0 Profile Picture
    SU-22040800-0 2,459 on at

    Thanks Richard.. can you send me the link to download it?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans