Referring to report Items contained in Table control on SSRS report

(0) Share

Report

Posted on by syed baber

11,633

Hi All,

I have a textbox within the Table control which is displaying the closing balance. Now, I have a requirement to display the closing balance at the bottom of the report as well just before the footer section. What is the best way to do this. I have tried ReportItems!Textbox2.value but it is giving errors at the time of report deployment. The error was something like "Report Items can only refer to the controls contained within the same group or data region ...." I tried to add a new table control as well and set its DataSetName property to the report's dataset and then trying to display the field there like Fields!ClosingBalance.Value, but still it is showing below error:

Error 1 : Field token Fields!ClosingBalance.Value is invalid. Could not find the identifier. \SSRS Reports\Reports\CustAccountStatementExt 0 0 CustAccountStatementExtReport"

Any help would be highly appreciated.

Thanks,

Baber.

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (0)

udaY-ch 5,133 on at

Like (0)

Report

Hi Syed,

report items are opted to use only in header or footer section.
you can add the textbox to the footer section and make space after the textbox and show your footer.

Was this reply helpful? Yes No
syed baber 11,633 on at

Like (0)

Report

Hi Udhanya,

Thanks for your reply. But we can also use it in the body section as well, right?

Was this reply helpful? Yes No