This is a fairly light assignment for you to experiment with SQL Server® 2014 Report
https://www.microsoft.com/en-us/download/details.aspx?id=42301 (Links to an external site.)
Using your TRAMS database....
Create 4 reports based off tables/queries of your choice. There are no restrictions - but your query results should have a lot of returned data that displays properly in the report (suggest joining 2 or more tables in your queries).
Example of reports include: Monthly revenue for each property, Current Guests due to check-in, check-out during the week, Folio Details / Transactions, etc.
At least one of the four reports should contain a visual (bar, pie,
At least two of the four reports should use a Parameters (where the user enters the data to be filtered, or selects from a drop down of choices - even better).
FORMATTING: They are reports, after all. Make them look relatively good...and make them all look DIFFERENT. DO NOT RELY ON THE WIZARDS. You can use them as a "Start", but your reports should not look "standard".
As a side note: .RDL files are hosted on SQL Server Reporting Services and are available for people to pull reports on demand. Titan does not have Reporting Services installed, so we will not be publishing the .RDL files. I'm only interested in you creating them.
Attachment:- aldosari_a9.zip