To do this in a VB Expression use DateDiff and set the interval to return the result in weeks.

Or you can use datediff in SQL (it works much the same...

Not that I know of, you can have defaults for all but one parameter.

It is possible to setup columns but I found it trial and error as Studio won't show the columns in the preview (which make you think it's not working). I found...

Yes. This is fairly straight forward in 2005.

Create a dataset with just the selected values in.

In the Report Parameters dialog select the appropriate parameter.

Change the option for default values to...

I read an article here about this the other week.

http://www.sqlservercentral.com/columnists/ADavel/3138.asp

However, I haven't had an performance issues yet and use one of two methods.

The easiest way is if you are...

I am assuming that it is the months across the top of the matrix you need to sort on. I am also assuming that you have a column in the...

I'm glad you got it fixed it seems strange you had to set the border colour to white as this shouldn't matter. In the past I have resorted to setting...

Set the BorderStyle to None for the borders you want invisible. I have a report where I have vertical borders and no horizontal borders and they appear without gaps.

I have...

I don't know a way of fixing column sizes. But I can help you with the legend. The best way is to create you own, which also enables you to...

Thanks for the extra detail. I would start by writing a SQL statement to select the task, cost and create a column for month. Something like

select TaskName, TaskCost, month(taskdate) as...

I think I know what you mean, but could you provide a little more detail ?

Do you mean average monthly cost for each task (rather than cost) ?

You don't say which version of SQL and RS you are using. But if you are using SQL 2005 use the interactive sort feature with the IIF code above and...

I have had problems with dates too. Make sure the default language for the report is UK. To do this, in the properties panel use the drop down above the...

Yes this is easy to do in a table. Basically you need to make this an expression. This gets more complicated it you have grouping though. There is a RowNumber...

I use Visio (as part of MS Office 2003). It will get all the details from SQL-Server itself although it works better with 2000 than 2005.

Choose New -> Database -> Database...