Hi all,
i need to make an report, that i couldn't managed to do it!!!
(attached report.jpg) depending on DB structure (attached DB.jpg).
i need to use stored procedure and using c#.net to call or execute it.

about the report, its about car renting office need to know how many cars with specific type been Rented (R), how many are Free(F), and according to the dates the report been dated for a period between 2009-03-01 to 2009-03-30 for that you can check how many new cars did the office bought (New).
Also (Cost) its the total of rented car from specific type.
Finally the total for all the result of (Rented), (Free),(Cost), and (New)

thanks in advance ...