Error while running ax ssrs report

Dynamics 365 for Finance and Operations/AX Technical Forum
#1

Hi,

I am created an ssrs report with Ax query and i seen the preview every thing is fine. I am trying to run this report in

sql server Reporting services browser. It throws me fallowing error.

The DefaultValue expression for the report parameter ‘AX_CompanyName’ contains an error:
Dynamics Adapter LogonAs failed. (rsRuntimeErrorInExpression)

#2

HI Roshan,

Refer the link https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb;en-us;2521632&p=62

Naresh Kumar Kolli

#3

You need to execute following steps-

1)For SSRS 2008 the Business Connector proxy account is required to be the SSRS service account through Reporting Services Configuration Manager.
2)Remove the SSRS execution account through Reporting Services Configuration Manager.
3)Restart the AOS and the Reporting Server.

#4

hi,

im having the same issue. but the given solution is not working. is there any other workaround available?

thanks