Forum Discussion
Calculated fields show #Error when placed on Report Builder report.
I hope this is the right forum. This is the forum that comes up when I click the "Forum" button in Report Builder.
I am finding that the most basic calculated fields show #Error when placed on a report.
- I am using Microsoft Report Builder 15.0.20073.0
- I am following the instructions at Add, Edit, Refresh Fields in the Report Data Pane (Report Builder) - SQL Server Reporting Services (SSRS) | Microsoft Learn.
A calculated field as simple as:
MyCalcField = "Hello"
shows #Error when placed on a report.
My questions are:
- What am I doing wrong?
- I assume that calculated fields can be placed on reports. Is this correct? Are there limitations or pre-requisites for placing calculated fields on reports?
- Is it possible to substitute Crystal Reports for Report Builder in SSRS?
1 Reply
It's hard to say what you are doing wrong, there is not enough detail here. How are you placing the field onto your report - is it in a single text box or in a table?
If it's in a table it should work since calculated fields are calculated once per row. If you have just dragged on a text box it depends how you are aggregating the calculated field. In the example calculation you've given you are returning a string so you would need to use something like a First() or Last() aggregate, not one of the mathematical ones like Sum()
If I add a field like the one you've shown
It works fine if I use it in a table output
