I’ve copy the Production Detail Report Data Definition.
I’ve unchecked ExcludeColumn on ProdBurRate and saved.
I’ve added a new Report Style and clicked Sync Dataset.
In SSRS I’ve added ProdBurRate to the Query and to the Fields.
I’ve printed from a Job with the Report Style and definition. I can check the Report DB with that GUID. I see that ProdBurRate is a column of INT type. I see the value I’m looking for in the table.
In SSRS when I choose that field as the Value of the Text Box Property I get this error:
[rsInvalidExpressionDataType] The Value expressino used in textrun ‘TxtBurdenLabor.Paragraph.TextRuns’ retunred a data type that is not valid.
What did I miss?
Did you check the format for the cells? I think rate should be decimals or number in this case.
I’ve just tested that based on your suggestion. No difference.
I didn’t create a new box. I’m recycling a box that had a working formula expression in it. One that was showing a numeric result.
It seems like the textbox was a Textfield and is expecting a text field, So that is why I asked that.
Then I would suggest creating a new text box or even dragging and dropping that box, since it may seem that there is a record that is showing a data type that is not valid.
One good way to debugging is to create a BAQ and check the ProdBurRate records to see if there is something you need to be considering.
Most of the time you will need to put a condition to prevent from this to happen.
I think you nudged me enough to find what I needed.
this is what I needed in the Expression to make it work:
oh good! Glad to help haha