Hi, I have 2 tables in one report. One table needs to refer to cells (ReportItems) in the other table. I tried to use the ReportItems like: ReportItems!textbox28.Value But thisonly works within the SAME table. Is this doable? Thanks, Minh

Hi Minh - You are only able to refer to other report items with the same or parent data scope. A table (data region) is a scope, so unfortunately you can't reference them as you describe. Typically when you are trying to refer between data regions, you are trying to relate or join to data sets. If this is the case, you will need to jointhe data in your query. -JonHP

Actually, that is what I am doing. The down side is that I have the same query (mdx) repeating in multiple datasets. How about custom coding? I mean, in custom code, can I somehow referencetextbox by its name? Minh

Hi Minh,Are you trying to just accessing one field from other data region? If yes, may be you can just include that field in your query.ORare you trying to create parent-child like report?You can actually use parameter to access from one table to another table and just make that parameter hidden (internal use).Hope This Help.Cheers,Uzzi

Hi Newcomer2K You may use report variables?They can be accessed from anywhere in the report?Create a report variable and set its value to ReportItems!textbox28.Value, then use it from the other table.Hope it will help.Vitchoura.

Thanks for all your repsonses. I'll try the hidden param approach. Minh

Dear Minh, i was facing the same problem in SSRS 2008, but hidden parameters generate error like "A value expression used for the report parameter refer to a field. Fields cannot be used in report parameter expression" Another way arround by which i resolve my issue is by using Report Variable. Like i took a report variable and assign expression i.e =Sum(Fields!field.Value, "MyDataSet1") And then i assigned that variable in any TextBox that out of the scope of the table, through which "MyDataSet1" was binded. Shoaib Anwar