Interesting. I guess I don’t understand the RDD vs RDL stuff. I actually cannot add my new field to the report until I sync the dataset – it gives an error.
The Value expression for the text box ‘Textbox1’ refers to the field ‘SchedCode’. 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.
If I close Report Builder, Sync the DataSet for the report style, reopen Report Builder – I can add my field and save. However, that’s when I get the report with duplicated data – it’s now 14 pages.
Steps to duplicate:
· In Report Data Definition maintenance, make a copy of ProdDtl, change field JobHead.SchedCode from excluded to included
· In Report Style, make a copy of Production Detail Report, change Data Definition to match the one created in previous step
o Generate this report from Job Tracker for a given job – it should render just like the default report
· Open ProdDtl created from previous step in Report Builder.
· Attempt to add textbox with Fields!SchedCode.Value and save – you should see the error
o The Value expression for the text box ‘Textbox1’ refers to the field ‘SchedCode’. 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.
· Close Report Builder, click Sync Dataset in Report Style Maintenance, open ProdDtl in Report Builder and reattempt to add textbox with Fields!SchedCode.Value. No error upon saving
o Generate this report from Job Tracker for a given job – for some jobs it duplicates Scheduling Resources multiple times
- Steve