Are you sure you have all the Service Packs installed on the new server so it matches what you had installed on your old server?

You can create a parameter, such as Expand All, and then check this value as to whether the toggle items should be expanded or collapsed when the report generates.

I use...

Use something like...

 =Sum(iif(CustomerAmt<0, 0, CustomerAmt))

So you have a dev and prod server both for RS and the SQL Database, correct?  If you have access to both, then the issue is not with authentication with...

Have you tried setting the authentication on the datasource for the report to Windows Authentication?  Be aware though, users will not be able to create subscriptions for these reports then.

Are you trying to join the data from the two datasets?

You need the calculated value to appear in the report somewhere, but not in the footer.  RS will not allow data to be dropped here.  Set the hidden value to...

In your data source, create a column which will specify the sort order (1,2,3. etc).  Add this column to the report above the row or column you actually wish to...

Easiest approach is to use RS 2005.  It's a feature in the new release.  Is this possible for you?

I've run into the same issue and have not yet figured out why this does not work correctly.  What we've done is to create a custom function within the report...

Is the embedded code within the report or in a dll on the report server?  If it's the latter, you need to set permissions to access the dll.

Are you trying to concatenate fields in your dataset to text in the textbox?  If so, the textbox value should look something like ="My text here " + Fields!MyField1.Value +...

Do as google search on SQL Views.  They are easy to create...

create view as

select a,b from table

Depends on how the reports ties together. If they are really detail reports supporting summary reports you could use a sub report.

And Yes, data regions can be nested within each...

You can create a parameter for the report and then tie that to a filter on the report's data region.