I believe it is the way it is, at least in the version I use (2008). To me it is kind of a cross between VB and SQL. ...

In the Garden of Eden

Is the second tablix pushed onto another page? What happens when you export to PDF or XLS?

I don't understand your response. Do you have a blank dataset and you need to create the query, or do you have a dataset that appears to be working...

Did you create a new dataset yet?

I would do this in the dataset with a WHERE clause. If you can't or won't do that then put a filter on the tablix to do the same...

Rainy days and Mondays

Happy where I am. Willing to entertain ridiculous salary offers or offers where the job can really enhance my skills and offer dramatically better opportunities.

Is your destination SQL Server, a file? You say it has a DB_Databasetimestamp data type but that is an SSIS Expression type (actually the type is DT_DBTimeStamp), not a...

Marttali has put you more or less on the right track. However I would suggest a different naming convention for your archive file: yyyymmdd. This way it is...

Smoked Gouda - ee

You could change the MaximumErrorCount number of either the package or the task so that the package doesn't fail when it encounters an error.

I embed the following code into the report in Report Properties >> Code

Public Function DivideBy(ByVal Exp1, ByVal Exp2)

If Microsoft.VisualBasic.IsNumeric(Exp1) And Microsoft.VisualBasic.IsNumeric(Exp2) Then

If Exp2 = 0 Then

DivideBy = 0

Else: DivideBy =...

I don't know why the zero would give you a problem. But would this work instead?

=sum(iif(Fields!TransactionDate.Value>="1 Apr 2012", Fields!ActualManHours.Value, Fields!ActualManHours.Value - Fields!ActualManHours.Value))

Since Fields!ActualManHours.Value - Fields!ActualManHours.Value should give you a...

Can you set up some sort of replication scenario (log shipping, mirroring, etc.) and eliminate the staging table step, then load your data warehouse from the target tables?