Visual Studio 2019 SSRS Dataset Query Designer, grouping causes query flickering

Steve Mason 1 Reputation point
2022-12-08T12:23:29.827+00:00

Hello Im having the same issue with the flickering group by in VS did you ever resolve ?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,066 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Anonymous
    2022-12-09T06:09:00.127+00:00

    Hi @Steve Mason
    I tried using the dataset query designer in VS, clicked "Show Group By", but everything works fine, it doesn't appear flickering.

    I recommend you report issues to the MS team responsible for SSRS extensions using Report a Problem in Visual Studio.
    268808-1.png

    But while waiting for the response, you can try three workarounds below:

    1. Go to Tools\Options -> Environment\General. Uncheck the Adjust visual experience box and possibly optimize rendering. Your graphics driver may be causing the problem, which will switch to software rendering.
    2. Install SQL Server Data Tools 15.8.0 (https://learn.microsoft.com/en-us/sql/ssdt/previous-releases-of-sql-server-data-tools-ssdt-and-ssdt-bi ), which contains version 1.24 of the extension.
    3. Use the Relational Query Designer.

    For more details, you can refer to these links:
    flickering-design-viewer-on-group-ssrs-visual-stdi.html
    visual-studio-2019-ssrs-dataset-query-designer-grouping-causes-query-flickering.

    Best regards,
    Aniya

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.