Results 1 to 1 of 1
  1. #1
    Join Date
    Feb 2009

    Red face Unanswered: Please Help !!! How can i make a report with stored procedure

    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 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 ...
    Attached Thumbnails Attached Thumbnails DB.JPG   Report.JPG  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts