Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / SSRS Report Error AX20...
Microsoft Dynamics AX (Archived)

SSRS Report Error AX2012 R3

(0) ShareShare
ReportReport
Posted on by lispyj 128

I am attempting to modify the BOMConsistOf report to add several fields from the InventTable, and two fields obtained from Invent Table methods.  This is the first RDP based report I have ever attempted to modify.  I believe that I have successfully modified the code, and added the new fields to the BomConsistOfTmp table and the BOMConsistOf query.  The standard AX BomConsistOf report runs fine with these modifications.  When I modify the dataset of the SSRS report to include the new fields, errors start to occur when running the report.  "The parameter InventStatus is missing a value."  I disabled a few of the fields and redployed the report and then the error changed to " The hidden expression of the tablix contains an error. The input string is in the incorrect format.  I haven't yet added the fields to the design or modified the design in any way.  There are no formulas at all on the hidden property of the referenced tablix, and I have not modified the InventStatus parameter default (or any parameter).  I am baffled about how these errors can be related to adding fields to the dataset. 

Does anyone have any ideas?

Thank you in advance!

LJ

*This post is locked for comments

  • Suggested answer
    lispyj Profile Picture
    lispyj 128 on at
    RE: SSRS Report Error AX2012 R3

    Thanks for your suggestions.  Yes, I had refreshed the data set.  I have made the errors go away, but I am still very puzzled by this problem.  I restored and redeployed the original SSRS Report from within Dynamics.  I opened it for editing in Visual Studio, and saw that the parameters were of the datatype Boolean (they displayed as checkboxes in the parameter dialog, which is how is noticed it!)  As soon as I saved the .rdl within Visual Studio, even without making changes, the parameter datatypes changed to string.  Changing them back resolved the error in Dynamics, but left me with a set of Warnings at the time of the Visual Studio build that the parameters could not be bound to fields in the report because the type did not match.  I haven't yet found how to make the warning go away, but will keep looking.  Even with the warning in VS, the report generates correctly in AX.

    LJ

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: SSRS Report Error AX2012 R3

    it seems to be some cache refresh issue

    Try clearing the cache

    Run commands under

    Tools > Cache

  • Community Member Profile Picture
    Community Member on at
    RE: SSRS Report Error AX2012 R3

    1. Have you tried refreshing your dataset in Visual Studio? Right click on dataset>hit refresh. (Refreshing dataset is very important usually after making any modifications(adding new fields) on data source table).

    2. "When I modify the dataset of the SSRS report to include the new fields, errors start to occur when running the report.  "The parameter InventStatus is missing a value." "- In the preview of report I suggest typing in the parameter value. In your case whatever value is for InventStatus.  Click save and preview again.  

    - These are just suggestions based on my own development experience. Good luck with your findings if this doesn't help :)

  • lispyj Profile Picture
    lispyj 128 on at
    RE: SSRS Report Error AX2012 R3

    I should have indicated that I successfully modified the code in the RDP class!

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

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans