Create a folder on the desktop of your VM called 'Week $8$ Drill Down Report' and inside of this folder, include:

$1.$ The Visual Studio project used to develop the report

$2.$ The stored procedure used in the report

Develop a drill down report in SSRS$.$ This will:

$1.$ Through a stored procedure that will need to be developed, extract the AP$.$Invoices table data.$$ This procedure will accept one parameter $($determine appropriate data type for this parameter$)$ that will be optional.$$ If no parameter is passed to the stored procedure, retrieve all data from the Invoices table.$$ If a parameter is supplied, pull back that particular invoice detail. $$The VendorId field will be used to toggle the drilldown functionality.$$ Retrieve and display all data by default when the report first loads.

$$a$.$ Add a parent group that will have the Vendor field at a parent group

$$b$.$ The drilldown piece will display the rest of the information from the AP$.$Invoices table

$$c$.$ Data display requirements $($formatting data$)$:

$1.$ Display InvoiceDate, InvoiceDueDate and PaymentDate as yyyy$-$mm$-$dd

$2.$ Display InvoiceTotal, PaymentTotal and CreditTotal to two decimal places.$$ Include the leading dollar sign.

$3.$ Center all data in each cell

$4.$ Ensure that all column headers are fully visible $($not truncated$)$ and are on single lines

Ensure that all objects are named appropriately.