Query Studio and Report Studio Comparison - Documentation for Bmc Decision Support for Server Automation 8.5

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

Chloe Bennett

Chloe Bennett

Culture, Media & Entertainment Columnist

Chloe Bennett explores the intersection of pop culture, streaming entertainment, digital trends, and contemporary lifestyle. Her weekly commentary reaches thousands of culture enthusiasts.

Share this article
Twitter Facebook Pinterest