Report Table Question

I have a report that contains 3 tables. I want to create a 4th table that contains data from the 3 other tables. Is there a way to reference the value from one of the other tables' textbox in my new table. All of these tables are contained in the same report. The 4th table is basically a summary of the other three tables.

Thanks in advance.

i dont think so, because all the textboxes in the table will be created dynamically and you can't refer those textboxes.

you better go for a stored procedure which fetch data from those tables and create a dataset based on this SP and refer this dataset in your fourth table.

Thanks.

|||I've done this before. You have to name the text box that you are referencing first in its name property. Then in the other table you put =ReportItems!Nameoftextbox

Report Security

Hi,

I have a certain report that contains information about a company structure... I want to allow only certain users to run the report (the easy part) but i also want the users to only see their own information (the hard part).

How can i achieve this?

Do i have to enable row based security over SQL Server 2005 table?

Best Regards

Hello,

You could use User!UserID to filter down your table to the data that each person should see.

Hope this helps.

Jarret