DBxtra Tips
Tips about DBxtra Report Software
Here is how to make a website address a hyperlink in a report.
In this example the report field “Website” is the URL for a Web site.
To make it a clickable hyperlink select the field and in the Property Box select Data Bindings - Navigation URL and select the field to bind.
Now when you click the hyperlink on the report the URL will open in the Web browser.
Sometimes you need to convert a database field type to another one; like converting an integer to a string, or a sting value to a date or integer, etc.
DBxtra version 4.1.6 to be released next week will allow you to do that in an easy manner.
This functionality only applies to connections to MS SQL Server, MS Access, MySQL and Oracle databases.
You’ll learn how to:
· Add a new User Group
· Add a new User
· Assign Objects to User Groups
DBxtra lets you export any Report data to a live connected Excel worksheet. A live connected Excel sheet will let you always see your latest updated data set.
You’ll learn how to:
· Export your data to a live connected Excel file
· Refresh the Excel file to get the most current data set
The DBxtra Schedule Server allows you to deliver Reports automatically.
· Configure the Schedule Server
· Create a new Schedule
· Create a new Schedule Job
· Execute the Schedule automatically
· Execute the Schedule manually
The DBxtra Schedule Server allows you to automatically send Reports to business contacts.
You’ll learn how to:
· Create a merge E-mail
· Attach a DBxtra Report to the E-mail
You can assign Parameters to your Reports; when the Report is opened then the user needs to enter values to filter the data.
You’ll learn how to:
· Assign Parameters to Reports
· Open Reports with Parameters
DBxtra allows you to export your Reports to the most common file formats like Excel, Word, PDF, text, XML, etc.
We’ll design a summary Report from an existing Query object and assign summary functions. We’ll also create a function which assigns a Year – Month Parameter.
