Hey Guys,
I am working on modifying one of our SSRS reports and need to add a new table along with fields from that table into the report. The report I am working with is QuotForm, and the new table I added is QuoteOpr.
Here is everything I have done so far:
Steps Completed
- Copied the existing report style
- Opened the Data Definition and duplicated it
- Pointed the new report style to the new Data Definition
- In the new Data Definition:
- Added the new data source: QuoteOpr
- Un-excluded the column(s) I needed
- Created a relationship between QuoteOpr and the existing QuoteDtl table
Report Changes
- In Report Style Maintenance, I changed the report name in the Output Location
- Opened the original report in Report Builder
- Saved it under a new report name so the original report remains unchanged
- In Report Builder, I added the new dataset using dsQuoteForm
This is the query I used:
=“SELECT T1.Company, T1.QuoteNum, T1.QuoteLine, T1.EXP_FEE_c FROM QuoteOpr_” + Parameters!TableGuid.Value + " T1"
I then added the fields from this query into the dataset and saved the report
Current Status
Up to this point, everything works fine. I can see the new dataset and the fields without any issue.
Problem
The error occurs when I try to place the new fields into the report layout. When I save, I get the following message:
The Hidden expression for the tablix ‘Tablix1’ refers to the field ‘QuoteComment’. Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope. Letters in the names of fields must use the correct case.
Any ideas what could be causing this?
