Skip to main content

Notifications

Announcements

New Dynamics 365 Community Call! (ERP Edition)
News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX forum / Error while deploying ...
Microsoft Dynamics AX forum
Answered

Error while deploying my SSRS reports

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

Hi All,

Thanks in advance.

I am facing a issue while deploying my SSRS report. The issues are as follows,

First Error:

Error 1 An error occurred while deploying the report LegalCarbonLawClientListReport.
This might be because the SQL Server Reporting Services extensions have not been installed on the report server, or configuration information has not been entered in the Report Servers form in Microsoft Dynamics AX. C:\Program Files (x86)\MSBuild\Microsoft\DynamicsTools\Microsoft.Dynamics.Framework.Design.Reporting.Modeling.targets 466 6 ReportModel1

Second Error:

Error 2 System.Web.Services.Protocols.SoapException: The Value expression for the text box ‘Textbox1’ has a scope parameter that is not valid for an aggregate function.  The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a dataset.
   at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings)
   at Microsoft.ReportingServices.WebServer.ReportingService2005.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings) C:\Program Files (x86)\MSBuild\Microsoft\DynamicsTools\Microsoft.Dynamics.Framework.Design.Reporting.Modeling.targets 466 6 ReportModel1

Can any one please help me to resolve this issue.

Thanks and Regards,

Deepak M.

Categories:
Development / Customization / SDK
  • GregJacobs Profile Picture
    GregJacobs 5 on at
    RE: Error while deploying my SSRS reports

    I had a reference to a private add-on library.  I changed the Copy Local property to False.  Then the solution deployed fine.  It was trying to overwrite the file while in use.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error while deploying my SSRS reports

    It is too late to answer your question but I think my answer may help the others who search this page.

    I got this error on my system and I fixed it by changing the expression value I had written wrong on ‘Textbox1’ cell of my table. Then, it was deployed successfully.

  • Mohammad Raziq Ali Profile Picture
    Mohammad Raziq Ali 2,432 on at
    RE: Error while deploying my SSRS reports

    Hi,

    Things you must remember while working SSRS reports whether it is customized or New reports from scratch.

    -->Try to put static debugger (write breakpoint; in your code)in DP Class processReport() method.

    --> Run the report from visual studio (go to Microsoft dynamics AX Configuration Utility, select developer tab, and select check boxes provided) and debug it.

    --> Stress (While Debugging) on query in processReport() methods because that could also be one of the reason for your problem.

    --> Put static debugger in insertIntoTempTable() as well to check whether data is populating in temp table or not, change TableType as regular.

    --> Refresh Report Report Server in Tools-> Caches ->Refresh report server

    --> Delete the Report from report Server and redeploy it.

    --> Generate Incremental Cil and Full Cil generation (Recommended)

    Note: This is as per AX 2012 and higher versions.

  • Verified answer
    Faisal Fareed Profile Picture
    Faisal Fareed 10,794 User Group Leader on at
    RE: Error while deploying my SSRS reports

    Hi,

    Solution for first error:

    Please check reporting extensions (one of the components of AX setup) are installed on SQL reporting server. You too have to check Reporting services are properly configured and report manager URL and web service URL are properly configured and accessible.

    Solution for second error:

    You have to edit this report in visual studio and find Textbox1 on report. Right click on this textbox1 and select expressions. There is something wrong with the expression set on it, you have to verify that parameter is being used in expression is a valid parameter. Build your report, there should not be any error and then deploy this report again from visual studio.

  • Bell Profile Picture
    Bell on at
    RE: Error while deploying my SSRS reports

    Maybe its cause that you copied columns from a report to current report. So, you should create comlumn by manual to solve this problem!

Helpful resources

News and Announcements

New Dynamics 365 Community Call! (ERP Edition)

Quick Links

Dynamics 365 Community Update

Welcome to the inaugural Community Platform Update. As part of our commitment to…

Dynamics 365 Community Newsletter - August 2024

Catch up on the latest D365 Community news

Community Spotlight of the Month

Kudos to Mohana Yadav!

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,107 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 227,954 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans