Report Objects

What are DBxtra Report Objects?

DBxtra offers three different kind of reports: Data Grids, Pivot Grids and Reports.

Once a Report Object was created it will show in the Explorer pane.

Objects do appear on the Project Explorer pane like that:

Note! Each Report Object opens in its own window which allows you to work on several Report Objects at the same time.

Load an existing Report Object

Select the Report Object and double click it.

Create a new Report Object

To create a new Report Object click the "Report Object" button on the "New" menu.

This will load the Report Object screen.

Note! All report objects need to be based on a Query.

To build the Query for the Report Objects click "Click here to create the Query".

The next step is to create the Query for the Report.

Save a Report Object

Saving a Report Object will save the Query, Data Grid, Pivot Grid and Report design.

To save a Report Object click the "Save" button.

You can also save the Report Object by clicking the "Save" button on the Query, Data Grid, Pivot Grid or Report " Report Object" menu.

Note! If you created a Data Grid View, Pivot Grid View or Report design you'll also be asked to save it.

A.) If you're running the Report Web Service

Select the Folder where to save the Report Object to.

You can create a new folder by clicking the "New Folder" button.

You can also assign a comment.

Assign the Report Object to an existing User Groups with privileges to view the object.

Allow Anonymous Access in Report Web Service

This option allows to open a Web Report without requiring to log in.

Customize web options

Web Report Widget

Learn more: Object Web Report Widget

Object Web Customization

This feature lets you customize how an individual object will be displayed in the Web Browser.

Click on the "Customization" button.

General Options

Theme: select the theme for the object.

Style: select the style for the Object.

Include Logo: define if to include the logo.

Include Menu: select if to show the menu.

Include Object Comment: define if to include the object comment.

Include Object Name: define if to show the name of the Object.

Include "Powered by DBxtra": define if to include that legend.

Hide Header - Footer - Right Side Bar, Left Side Bar: define if to hide those elements.

Data Grid Options

Show Data Grid: define if to show access to the Data Grid.

Include Views: define if to show Data grid Views.

Include Summaries: define if to show Data Grid summaries.

Pivot Grid Options

Show Pivot Grid: define if to show access to the Pivot Grid.

Include Visible Rows: define if to show visible data rows.

Include Sort by Field: define if to allow the sort by field option.

Report Page Options

Show Report: define if to grant access to the show Report link.

Include Report Toolbar: choose if to include the Report toolbar.

Allow Report Export: define if to allow exporting from a Report.

Included Menu Buttons

Include Menu Home Button: define if to show a link to Report Web Service's home.

Home Explorer Links: define if to open Reports in the same or in a new window (tab).

Include Report View/Data Grid/Pivot Grid buttons: define if to include those buttons.

Include Show/Hide Button: define if to allow to show those buttons.

Include Export to Excel: define if to show this button; applies only to Data and Pivot Grids.

Include Appearance button: define if to show this button.

Include Login/Logout button: define if to show this option.

B.) If you're not running the Report Web Service

Publish As: Select the report type.

File location: You can change the path of the file output.

Save a Report Object as a new Report Object

To save a copy of an existing Report Object click "Save As" on the menu bar.

If you only want to save the Query of the Report Object as Query, select "Save only the Query" option
This option will not copy the Data Grid and Pivot Grid Views and neither the Report design.

Rename a Report Object

To rename a Report Object select it.

Hit the "F2" key .

Assign a new name for the object.

Delete a Report Object

To delete a Report Object and place it into the Recycle Bin, select it, right click it and select "Delete".