Share via

Adding simple text field to a report results in #Error

Dom 976 Reputation points
2023-07-13T15:45:15.28+00:00

I have an RDL report that has been used for years without problem. A user asked for a new field to be added to the report. It is an e-mail address (varchar). The dataset is loaded from a stored procedure. If I execute the SP in SSMS, the new field shows up fine.

User's image

If I right click on the dataset and hit Query and then Execute, the field shows up fineUser's image

User's image

If I drag the field into the report and preview, all the values come up #error.

User's image

The error window shows this warning.

User's image

What is going on and how do I correct this?

SQL Server Reporting Services
SQL Server Reporting Services

A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.

0 comments

Answer accepted by question author

Anonymous
2023-07-14T03:05:51.1833333+00:00

Hi @Dom

From what I've searched, this seems to be an issue with caching, try deleting the ".data" file created in the same directory as the report.

For more details, you can refer to this link: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/fad557d1-f32b-4291-a5ef-33220a99fa1b/the-value-expression-used-in-textrun-8216textboxparagraphs0textruns08217-returned-a-data?forum=sqlreportingservices.

If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

Best regards,

Aniya

Was this answer helpful?

1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.