Toc - Tips

This section provides some useful tips about DBxtra.

Note! Some tips might have been elaborated with prior versions of DBxtra and therefore might be showing screenshots of DBxtra windows which might have been changed in the current version.

twitter.gif   To keep updated when a new tip is released follow us on Twitter.

Data Connections

Tip - Change a Report connection

Tip - Access to MySQL on shared hosts

Tip - MS SQL Server Windows authentication Problem

Tip - Oracle Connection Option

Queries

Tip - User – User Group Variables

Tip - Nested user input parameters

Tip - Expression Converter

Tip - Constants in DBxtra Queries

Tip - Create queries by pasting SQL code.

Data Grids

Tip - Data Grid Hyperlinks

Pivot Grids

 

Reports

Tip - Drill Down Reports

Tip - Anonymous Report - with customized Properties

Tip - Zebra on Reports

Tip - Calculate with Scripts

Tip - How to suppress blank fields in a Report

Tip - Surround a value with a special character

Tip - Place a Total field in the Detail Band

Tip - Design a report with unbound reports

Tip - Assign a custom symbol for a report field

Charts

Tip - Chart on detail level – a chart for each detail

Tip - Showing only TOP x on a chart

Tip - Stacked Bar Chart sample

Export Data

Tip - Export data to existing Excel files

Tip - Linked – Always Live Connected – Excel Export

Report Web Service

Tip - Install DBxtra as IIS Report Web Service on your Server

Tip - Pass login information from an external application to the DBxtra Report Web Service

Tip - Running DBxtra Report Web Service on 64 bit Windows

Tip - How to configure the DBxtra Report Web Service on IIS (Internet Information Server)

Schedule Server

Tip - How to assign a Windows user to the DBxtra Schedule Server Service

Tips - DBxtra Schedule Server – with Gmail, Yahoo and Hotmail

Tip - Send merged reports by E-mails to DBxtra users with the Schedule Server

Various

Tip - Access many features without loading the object first.