What I am in need of is a SSRS 2008 report written to generate a status report that will display information similar to the [url removed, login to view] attached. The report parameters will be passed into the report as internal parameters and will not ben shown to the user. The hierarchy of the results are going to be multiple "jobs" returned and then for a particular job, you can have details for that particular job below it (such as notes, orders, etc). The screenshot represents a single job but the report should be able to support multiple jobs. There are several child detail grids for a job such as orders, notes, etc. One of the requirements is that if the grid contains no rows, for it to not be shown.
With this project, I wlil provide the database objects (tables, procedures, etc). I am using SQL Server 2008 R2 and SSRS 2008.