If you click on the layout tab and then click on the little square that is in the upper left hand corner at the intersection of the two rulers and...

This should work for you. Put the procedure name in the datasource and change the command type  to Stored Procedure. The system should then detect the parameters and give you...

You can add a column to the matrix and then modify the expression to put in a calculated field. The calculated field can use the sum function as shown below....

This feature is one of the best kept secrets. If you hover the mouse pointer over the little green arrow in the upper right corner of the Total Text box...

You probably will need to use the web service. Set up the report with the parameters specified in the query using the @ParameterName convention. Then you have to set a...

You can type headings into the text box that the matrix has above the rows. The alignment is tricky but using trial and error you can type in a text...

You probably need to set up a report that uses a list control tied to a query that is grouped by each sales person. Then put a sub report that shows the...

You should be able to do this with the immediate if function. A statement something like =IIF(TestFields!Value = 0 ,"N/A",Fields.Value/SecondFields.Value)

The IIF is structured IIF(Test Condition,True Part, False Part), you...

Click on the column in question and then right click and you will get a tabbed dialog that has a Sort tab. Set the field and sort direction in this...

You do this on the reporting services web site. Go to the report click on the report and then click on the properties tab at the top. Click on the...

The formatting is based on a string. I haven't tried it but you might be able to use an IIF statement to calculate and create the string on the fly.

Stuart

No, you would have to calculate the totals in a query or stored procedure and then divide the results to get the weighted average.

Stuart

It is very easy to set up a subscription. Be sure the data source property on the report has the user id and password stored. Then click on the subsciptions...

Is the detail report a different report or the same report that is customized using a parameter? If it is really a different report for each person then you would...

Try putting a subreport that uses the second dataset and pass in the parameters of the employee, and week numbers.

Stuart