SSRS Study Notes

I went through a series of Microsoft webcast on SSRS 2005 and found it helpful. Here are some of the notes I took:

1. When use URL to access a report use \reportserver\ instead of \reports\
2. List report item is more like a container for other report items like textbox and table.
3. Shift+click allows you to select multiple cells.
4. Print layout button helps preview page setup.
5. Multi-value parameter: use IN in Where clause (SQL Query).
6. Write stored procedures directly on data set.
7. You can add calculated field directly on dataset by right clicking on the dataset in Datasets view and choose Add then select Calculated Field.
8. Report Delivery: Web Service: msdn2.microsoft.com/en-us/library/ms155071.aspx
9. To use external assembly for custom code.
a. Create a Class Library project
b. Build it and put the dll in both the Report Server location and Report Designer location in Visual Studio.
c. In report designer go to project properties window and go to reference tab, and select the dll copied to Report Designer location.
d. To call the function, view the report rdl file code, locate the field that need the custom code, then put in custom expression. E.g.
=AdventureWorks.VB.Extensions.Commonfunctions.functionName(paremters the function takes)