Report: The Hidden expression contains an error

(0) Share

Report

Posted on by Ganriver1

1,559

Hi Friends,

Got a weird error, I need to add two new fields to report. So, I created two new fields in temp table. but, not even showing them in report, just add to dataset. I got this error:

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

Report is WMSPickingList_OrderPick. table is WMSPickingList_OrderPickTmp.

Any hint is greatly appreciated.

River

*This post is locked for comments

I have the same question (0)

All responses (21)

Answers (1)

Suggested answer

Sohaib Cheema 48,887 User Group Leader on at

Like (0)

Report

RE: Weird report error, could be related to dataset

The issue seems straight forward. Select your table which is on report design go to properties, go to visibility and check the expression of viability. Either remove it or try to fix it.

Was this reply helpful? Yes No
Ganriver1 1,559 on at

Like (0)

Report

RE: Weird report error, could be related to dataset

I looked at it. Hidden property has no expression. It's 'false'.

Was this reply helpful? Yes No
Suggested answer

Sohaib Cheema 48,887 User Group Leader on at

Like (0)

Report

RE: Weird report error, could be related to dataset

see here

1) right click the corner of your whole table and click properties

now go to Visibility Tab and either remove expression and select option of show. or fix your expression

Was this reply helpful? Yes No
Ganriver1 1,559 on at

Like (0)

Report

RE: Weird report error, could be related to dataset

Hi Sohaib,

We don't have expression there. It's exact what you show here.

River

Was this reply helpful? Yes No
Sohaib Cheema 48,887 User Group Leader on at

Like (0)

Report

RE: Weird report error, could be related to dataset

By error message, it seems the issue of wrong expression.

If that is not the case, as you said, then I am not sure about other reasons unless you specify some more details. Like, was this report working fine, before you added fields? if you delete customization of this report, is it behaving correctly? have you refreshed DS after adding new fields. have you restarted reporting services after adding new fields. all these points need consideration to know exact matter

Was this reply helpful? Yes No
Ganriver1 1,559 on at

Like (0)

Report

RE: Weird report error, could be related to dataset

Yes, report works fine before. Only after I add new fields to dataset. Not even showing new fields on report. And new fields got data as I debugged. Everything you mentioned I have checked. That's why it's so weird.

Was this reply helpful? Yes No
Suggested answer

Sohaib Cheema 48,887 User Group Leader on at

Like (0)

Report

RE: Weird report error, could be related to dataset

when you re-select Dataset (DP class), on VS level, does these new fields appear under Dataset on visual studio???

Was this reply helpful? Yes No
Ganriver1 1,559 on at

Like (0)

Report

RE: Weird report error, could be related to dataset

yes, they are there.

Was this reply helpful? Yes No
Sohaib Cheema 48,887 User Group Leader on at

Like (0)

Report

RE: Weird report error, could be related to dataset

may be restart to AOS can resolve the issue. sometimes a restart to AOS had fixed such issues with me in past.

Was this reply helpful? Yes No
Ganriver1 1,559 on at

Like (0)

Report

RE: Weird report error, could be related to dataset

already tried. no help.

Was this reply helpful? Yes No