Data region wizard
Download
1 / 14

Data Region Wizard - PowerPoint PPT Presentation


  • 89 Views
  • Uploaded on

Data Region Wizard. Wireframe design. Select a query. Select query Arrange fields Select layout Select style Set options Finish. Use a query in this report. Dataset1 Product, Category, Region, Year, Sales. Dataset2 CategoryID, CategoryName. Create a new query. Help. < Back. Next >.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Data Region Wizard' - ima-hurst


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Data region wizard

Data Region Wizard

Wireframe design


Select a query

Select query

Arrange fields

Select layout

Select style

Set options

Finish

Use a query in this report

Dataset1

Product, Category, Region, Year, Sales

Dataset2

CategoryID, CategoryName

Create a new query

Help

< Back

Next >

Cancel

  • This page only appears if the report contains at least one dataset. If there are no datasets, the Select Connection and Design Query pages are the first two pages of the wizard.


Select a query

Select query

Arrange fields

Select layout

Select style

Set options

Finish

Use a query in this report

Dataset1

Product, Category, Region, Year, Sales

Dataset2

CategoryID, CategoryName

Create a new query

Help

< Back

Next >

Cancel

  • If “Create a new query” is selected, the Choose Connection and Design Query pages appear as sub-pages


Choose a connection for the query

Select query

Choose connection

Design query

Arrange fields

Choose layout

Select style

Set options

Finish

Browse…

New…

WTT

Report Library > Data Sources

VSTS

Report Library > Data Sources

Help

< Back

Next >

Cancel

  • Data sources in current report appear first, then recent shared data sources

  • Browse launches Open dialog, enabled only if have a report server

  • Edit enabled only for data sources embedded in this report

  • New launches Data Source dialog


Choose a connection for the query

Select query

Choose connection

Design query

Arrange fields

Choose layout

Select style

Set options

Finish

Browse…

Edit…

Connection1

(in this report)

WTT

Report Library > Data Sources

VSTS

Report Library > Data Sources

Help

< Back

Next >

Cancel

  • After creating a new connection, it appears at the top of the list

  • New button is now Edit, and is only enabled for the new data source created inside the wizard


Edit as text

Import…

! Run Query

Select query

Choose connection

Design query

Arrange fields

Choose layout

Select style

Set options

Finish

Query designer goes here

(user may need to resize/max wizard)

Help

< Back

Next >

Cancel


Choose chart type

Choose connection

Design query

Select chart type

Arrange fields

Set options

Finish

Column

Bar

Pie

Line

Area

Stacked

100 Percent

Help

< Back

Next >

Cancel

  • Page only in chart wizard

  • No “Choose Layout” page in chart wizard


Available fields

Choose connection

Design query

Arrange fields

Choose layout

Set options

Select style

Finish

Column Groups

Product

Category

Region

Year

Sales

Region

Row Groups

Values

Category

SUM(Sales)

Product

Show subtotals and grand totals

Expand/collapse groups

Help

< Back

Next >

Cancel

  • Add fields using drag/drop, SPACE, or ENTER (numerics to Values, others to Row Groups)

  • Fields removed from left list once added

  • Provide keyboard shortcuts for moving fields within and between lists

  • Delete key in a field list returns field to available list

  • Dropdown on Values fields allows changing or removing aggregate function

  • If row AND column groups, all Values must have an aggregate function (page validation)


Choose a table layout

Preview

Choose connection

Design query

Arrange fields

Choose layout

Set options

Select style

Finish

Blocked, subtotals above

Blocked, subtotals below

Stepped, subtotals above

Stepped, subtotals below

100%

Help

< Back

Next >

Cancel

  • Page is only shown if 1+ row groups and 0 column groups


Choose a matrix layout

Preview

Choose connection

Design query

Arrange fields

Choose layout

Set options

Select style

Finish

Subtotals above

Subtotals below

100%

Help

< Back

Next >

Cancel

  • Page is only shown if 1+ row groups an 1+ column groups


Select a style

Preview

Choose connection

Design query

Arrange fields

Choose layout

Select style

Set options

Finish

Steel blue

Golden coast

Green meadow

Silver bullet

100%

Help

< Back

Next >

Cancel

  • Choose layout page is skipped if “Show subtotals” is unchecked on fields page

  • Pan control shows actual preview at 100% zoom

  • User can pan using mouse or arrow keys


Choose table options:

Preview

Choose connection

Design query

Arrange fields

Choose layout

Select style

Set options

Finish

Interactive sortThis is some explanatory text about the option. You should try this because it is really cool.

Clickthrough actionsThis is some explanatory text about the option. You should try this because it is really cool.

100%

Help

< Back

Next >

Cancel

  • Interactive sort not available on chart


Summary

Connection: connection1

Groups: mart-com, hr, sales

Details: this is shared report…

Subtotals: Yes

Expand/Collapse: Yes

Layout: Blocked, totals below

Style: Steel blue

Options: Interactive sort, Clickthrough, Drilldown…

Preview

Choose connection

Design query

Arrange fields

Choose layout

Select style

Set options

Finish

Run report

100%

Help

< Back

Finish

Cancel


ad