1 / 5

SRS Advanced

SRS Advanced. Jennifer Ranz jenolson@microsoft.com Program Manager II Microsoft Corporation. Agenda. Modify an existing report Create a report using a stored procedure Using Report Builder 2.0 features to make your report flexible/ user friendly Drilldowns Parameters Jump Tos

oded
Download Presentation

SRS Advanced

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SRS Advanced Jennifer Ranz jenolson@microsoft.com Program Manager II Microsoft Corporation

  2. Agenda • Modify an existing report • Create a report using a stored procedure • Using Report Builder 2.0 features to make your report flexible/ user friendly • Drilldowns • Parameters • Jump Tos • Tool Tips

  3. Modify an existing report • RM Accounts Due report • Proc based report (make a copy of the proc) • Copy of .rdl • Add the following Info: • Customer purchase order number • Add drilldown for Customer ID • Add formatting on the report for over due dates

  4. Create a report using a stored procedure • Requirements: • Item Number • Qty on Hand • Qty Allocated • Qty on Order • If Qty on Order look at the PO that has the Item on it (could be another report)

  5. Questions?

More Related