Calculated fields show #Error when placed on Report Builder report.

[Anonymous]

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 (.... 

A calculated field as simple as:

MyCalcField = "Hello"

shows #Error when placed on a report.

My questions are:

1. What am I doing wrong?
2. 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?
3. Is it possible to substitute Crystal Reports for Report Builder in SSRS?

[d_gosbell]

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