Query Studio and Report Studio Comparison - Documentation for Bmc Decision Support for Server Automation 8.5
Taskreport Studioquery Studiocreate Simple Ad Hoc Reports. Yesyesability to Access Full Data Model. Yesyescreate Drill Throughs. Yesnocreate Charts. Yesyes...
Task
Report Studio
Query Studio
Create simple ad hoc reports.
Yes
Yes
Ability to access full data model.
Yes
Yes
Create drill throughs.
Yes
No
Create charts.
Yes
Yes, limited
Filter.
Yes
Yes
Group.
Yes
Yes
Sort.
Yes
Yes
Create crosstab reports.
Yes
Yes
Create conditional formatting.
Yes
Yes, limited
Create prompt pages.
Yes
No
Create multipage reports.
Yes
No
Create multiple query reports.
Yes
No
Apply conditional styles and style variables.
Yes
No
Apply conditional rendering between lists, crosstabs, and charts.
Yes
No
Import and export report definitions.
Yes
No
Use custom SQL in reports.
Yes
No
View generated SQL for reports.
Yes
No
Create calculations using complex SQL functions.
Yes
No
Create filters with complex calculations.
Yes
No
Create joins.
Yes
No
Create dashboard reports.
Yes
No
Use objects, such as HTML items, value prompts, and hyperlinks.
Yes
No
Set default values and static values in prompts.
Yes
No
Create detailed customized layout and formatting.
Yes
No
Set page breaks on multiple data items.
Yes
No
Control exact placement of objects on a page.
Yes
No