web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

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 181

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

I have the same question (0)
  • lispyj Profile Picture
    lispyj 181 on at

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

  • Community Member Profile Picture
    Community Member on at

    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 :)

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    it seems to be some cache refresh issue

    Try clearing the cache

    Run commands under

    Tools > Cache

  • Suggested answer
    lispyj Profile Picture
    lispyj 181 on at

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans