Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Report :The Hidden exp...
Finance | Project Operations, Human Resources, ...
Suggested answer

Report :The Hidden expression for the tablix ‘Table_0’ contains an error:

(0) ShareShare
ReportReport
Posted on by AXx 95

Hi experts ,

Got a weird error, I need to add two new fields to report(Report is AutoDesign ). So, I created One new field (CostPrice) in InventSumDateTransReport. ,and Referenced it in InventDimPhyDP class as :

inventSumDateTransReport.CostPrice = _inventSum.averageCostPrice();

When I compile It there is no error , but when I add it to the VS Dataset (just add to dataset.)and deploy it. then I run the report (IM >> Reports>> Status >> Phy Invent. >>Phy Intvent By Invent Dim )

Report is AutoDesign

I got this error:

The Hidden expression for the tablix ‘Table_0’ contains an error: Input string was not in a correct format. (rsRuntimeErrorInExpression)

pastedimage1600928115653v1.png

Please Guide Me

  • Blue Wang Profile Picture
    Blue Wang on at
    RE: Report :The Hidden expression for the tablix ‘Table_0’ contains an error:

    Hi Axx,

    Have you checked the answer in the shared link? Any feedback?

    "I fixed the problem when I tracked the parameters and set their type to boolen, so I can check whether the parameter is chosen or not."

  • AXx Profile Picture
    AXx 95 on at
    RE: Report :The Hidden expression for the tablix ‘Table_0’ contains an error:

    Can You please Tell me where I can download Hotfix 3039913 ??? I have searched a lot but no positive result

  • Suggested answer
    vinitgoyal2005 Profile Picture
    vinitgoyal2005 6,330 on at
    RE: Report :The Hidden expression for the tablix ‘Table_0’ contains an error:

    Hi,

    check thread community.dynamics.com/.../report-the-hidden-expression-contains-an-error

    and community.dynamics.com/.../inventtransferorderoverview-report-issue

  • Suggested answer
    Andre Ghazaleh Profile Picture
    Andre Ghazaleh 870 on at
    RE: Report :The Hidden expression for the tablix ‘Table_0’ contains an error:

    Hi AXx,

    Apply hotfix 3039913 it should fix your problem.

    community.dynamics.com/.../report-the-hidden-expression-contains-an-error

  • Blue Wang Profile Picture
    Blue Wang on at
    RE: Report :The Hidden expression for the tablix ‘Table_0’ contains an error:

    Hi AXx,

    Same topic: community.dynamics.com/.../inventtransferorderoverview-report-issue

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans