110 likes | 242 Views
MBS QRT Training. Bonnie Faulkner. QRT Workshop. QRT Main Screen Fields and Buttons. QRT Workshop. To create a query: Click New on the QRT main screen. Enter the description, use, category and view. Select the columns for your query/report. QRT Workshop. What to Select for Your Query
E N D
MBS QRT Training Bonnie Faulkner
QRT Workshop • QRT Main Screen Fields and Buttons
QRT Workshop • To create a query: • Click New on the QRT main screen. • Enter the description, use, category and view. • Select the columns for your query/report.
QRT Workshop • What to Select for Your Query • Available Columns /Include Columns/Data Order. • Column descriptions –understanding the fields (i.e. account/description = name).
QRT Workshop • Adding Filters • Allows users to select only active services, specific service areas, and/or a certain product or package.
QRT Workshop • Filter Details (bottom of screen) • Allows users to check or change filter options at run time. • Select Prompt for value at runtime.
QRT Workshop • Sample Query • Execute or schedule to run.
QRT Workshop • To schedule a query to run from the QRT main screen: • Select the query. • Right-click in the User Query Schedule list to display the shortcut menu and click New.
QRT Workshop • Verify the schedule details, update them as needed and click Save.
QRT Workshop • Executed Query Results