Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

SSRS Report Error AX2012 R3

Posted on by 2,695

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

Categories:
  • Suggested answer
    lispyj Profile Picture
    lispyj 2,695 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 Microsoft Employee 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 Microsoft Employee 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 2,695 on at
    RE: SSRS Report Error AX2012 R3

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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,986 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans