Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Exception when trying ...
Microsoft Dynamics AX (Archived)

Exception when trying to select the query for an SSRS report in Visual Studio

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi all,

  I am trying to create an SSRS report in Visual Studio.  I have created the basic report and added it to AOT.

  Now, when trying to specify the query for the report, I am getting the following error:

I have searched on the internet and the basic recommendations were:

1) Create a configuration file based on the original configuration in the Dynamics AX Client Configuration.  Then refresh the WCF configuration.  I did this and basically got the same error.

2) Delete the respective Dynamics AX folder in the AppData directory.  I did this as well but the problem persists.

I checked in the Event Viewer and basically there are no errors related to this problem.  What could be the cause please and how can I solve it?

Thanks.

*This post is locked for comments

  • Girija Shankar Beuria Profile Picture
    Girija Shankar Beuria 690 on at
    RE: Exception when trying to select the query for an SSRS report in Visual Studio

    Hi,

    Try the suggestions given below. If does not work try the below (Do it only on a dev environment):

    axwonders.blogspot.in/.../solving-error-cil-generator-found.html

    - Girija

  • Suggested answer
    raelhefn Profile Picture
    raelhefn on at
    RE: Exception when trying to select the query for an SSRS report in Visual Studio

    Please check this post it will guide you to solve this issue community.dynamics.com/.../104510.aspx

  • Verified answer
    Denis Macchinetti Profile Picture
    Denis Macchinetti 16,444 on at
    RE: Exception when trying to select the query for an SSRS report in Visual Studio

    Hi

    Try to check if CIL works as expected.

    Finally, try to deploy the Service Group, BI Services.

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

photo of Muhammad Affan

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

thumbnail image of a pie chart section

Top 10 leaders for November!

Congratulations to our November super stars!

thumbnail image of the word Tip

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans