Microsoft Dynamics AX (Archived)

Error while deploying my SSRS reports

(0) Share

Report

Posted on by Community Member

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.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Bell on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Faisal Fareed 10,796 User Group Leader on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Mohammad Raziq Ali 2,486 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
GregJacobs 5 on at

Like (0)

Report

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.

Was this reply helpful? Yes No