You really should have posted this in a new thread rather than posting it at the end of a 2 year old thread.

In the properties for the text box (not...

Oops, missed that. Conceptually I think it is the same, a parameter for the user in the report definition. You need to be able to grab the user...

With regard to a user seeing data on a report that is pertinent to them only, make the user information a parameter input on the report and then feed that...

If I understand you are trying to run a daily report with parameters to be filled to pull yesterday's data. Perhaps with a start and end data parameter with...

vaporiferous

Dentist......ugh.

Does the destination report work properly with both parameters when you run it standalone?

First I would check the spelling of the parameter in both the source and destination. Also...

Shared Datasets? I am only aware of Shared Data Sources? What exactly do you mean by a shared dataset?

In the Textbox properties dialog for the source report. Go to the Action tab, hit the Go To Report radio button. Specify the name of the report you...

An SSRS Tablix can practically only contain data from one dataset. A single dataset can be a conglomeration of many tables from one or more databases.

So to answer question...

Dreary

When you execute the dataset in SSRS, not the report itself, just the dataset, what is returned?

Can you please show the entire expression that is not working?

One other thing to be aware of, in T-SQL depending on your data types 2/3 will result in zero in...

Put a scope qualifier in your SUM statement. Something like this (my syntax may be off)

=SUM(Fields!ColumnToAdd.Value,"2010")

Where "2010" is the name of the group for 2010.

You can also just add...

Either put a query in your destination that will return the state name to a state name parameter based upon the state value passed to the state parameter, or pass...