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

Anonymous — Fri, 13 Oct 2023 13:18:42 GMT

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?

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

d_gosbell — Mon, 16 Oct 2023 03:33:42 GMT

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

topic Re: Calculated fields show #Error when placed on Report Builder report. in Report Server

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

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