Please check first our knowledge base for solutions to your problem. If you can't find the right answer to your question select another support option on the right side.
DBxtra version 7.1.1+ now offers two versions of the Report Web Service. 1.) Report Web Service – DBxtra Server (DBXS) Although you can use it as an Internet facing Web Server we recommend it for Intranet use only. Its robustness and security schema are not as sophisticated as the Internet Information Server – IIS. It [...]
We have identified that some customers started experiencing this issue when they open or create a new Report Object: This problem is caused by a misconfiguration of Internet Explorer when a Microsoft update is applied, the main problem is that the connection timeouts before the Report Web Service responds, this may be experienced also [...]
Under Internet Information Services (IIS) 7 or newer, updating DBxtra to version 7.1.0 or newer could cause this problem: To solve it you need to do as follows: 1.- Open the Control Panel. 2.- Open the Administrative Tools folder. 3.- Open the Internet Information Services (IIS) Manager. 4.- Under Connections, select the root node, the [...]
There are a issues to consider with running DBxtra .NET v7.1.0 on IIS 6. First, DBxtra Report Web Service runs with the .NET Framework version 4.0. You cannot run more than one version of the framework in the same application pool in IIS6. While multiple versions of the framework can co-exist on the same server, [...]
DBxtra Report Repository database – SQ Server CE Until now DBxtra used a MS Access database as Report Repository and although we never heard of any problem, DBxtra version 7.1 now uses a MS SQL Server database for storing all report definitions in its Report Repository. The MS SQL Server DBxtra Report Repository definitely offers [...]
By default most web browsers decide what is best when they find a pop-up link, and usually every DBxtra report open from the Report Web Service is opened in a new window, if you want to always open every new report in a new tab instead you can do as follows: Internet Explorer: 1.- Open [...]
If you have to handle many users in DBxtra it might be cumbersome to add and edit them manually in DBxtra. That’s why we just released a utility which handles the import of users easily. You can download the DBxtra user import utility from here. Important! Always do a backup of your Report Repository first. [...]
If your DBxtra trial has run out, and you need more time to evaluate please request an extension to the trial. Contact us and we’ll send you a trial extension key.
Beside English, German, Spanish, Italian we now also offer a Portuguese language file for your DBxtra Report Web Service translation. Download the language files from here. Learn how to import a Report Web Service language file.
Problem: I can’t make the Schedule Server run any automated job, but if i run them manually they run fine. Solution: The most probable scenario for this problem is that the Schedule Service can’t connect to the Repository, to solve this, you must do as follows: 1.- Open the Schedule Server, note that with Windows [...]
Problem: I’ve upgraded my DBxtra and found that when i want to edit a query the Column Grid of the Query Builder appears blank, but when i select a column there, it appears just fine, while the others still appear blank. I’ve upgraded my DBxtra and when i want to change a Schedule with more [...]
You can easily change the appearance of your Report Web Service interface. DBxtra manages style sheets for style configuration of the Report Web Service. To make it easier for you to configure styles without knowledge of css formatting DBxtra includes a style configurator. Learn more about changing the appearance of the Report Web Service
DBxtra allows you to choose different languages and also translate – personalize the Report Web Service. Select "Define Languages" on the "Report Web Service" menu. Set a Language as Default Select the language and click "Default". To set this language as the default for your Report Web Service check the "Set as default" checkbox. Edit [...]
If you’re running DBxtra in trial mode: DBxtra installed the Report Web Service on the internal DBxtra Web Server. To access the Report Web Service from another PC you need to enter the URL like your Web Browser: http://PCNAME:8080/DBxtra.NET where "PCNAME" is the name of the computer where the Report Web Service runs. When you [...]
This sample report is included in the DBxtra sample project. You will learn how to: Create a new Query Design a basic Report Assign a clickable hyperlink to the Report Create the Query Drag all required tables to the Diagram Pane. Select field to be included. Assign Alias names. Assign Parameters Double click the "Country" [...]
The DBxtra Schedule Server offers report schedule capabilities with many options, including recurring schedule jobs based on specific time intervals. Your reports can be scheduled for delivery by e-mail to your business contacts. Plus, you can export reports to a specific location or uploaded to an FTP server; all in the most common output formats [...]
1.) Free DBxtra Desktop Report Viewer DBxtra offers a Free Desktop Report Viewer that lets anyone open reports designed with the DBxtra Report Designer. Run any report designed with the DBxtra Designer. Open Data Grids, Reports, Pivot Grids; DBxtra will detect the object type and open the DBxtra Desktop Viewer accordingly. All reports are live [...]
To take a look at real time sample reports on a live connected Report Web Service please click here.
If you need for some reason – like moving from a testing Server to a productions Server – to move the DBxtra Report Repository to a new location follow these steps: Report Repository – Server Setup · Run the DBxtra Setup – on the Server / PC where you would like to install the Report [...]
Question: I use POSTGRES SQL. But I see that the POSTGRES SQL SINTAXES is not implemented. Example: SELECT coalesce(ean.codean) ean FROM EAN There is an error: I think taht DB wants "as" For me it is important that all my QUERY to be used "how are now" Answer: Currently DBxtra requires you to use [...]
To upgrade to the latest version of DBxtra you need to have a valid maintenance plan. Recommendations: Always download the latest DBxtra version from the customer panel: http://www.dbxtranet.com/Customers/Customers.aspx Login with user name and password which was provided to you with the welcome – license e-mail we sent to you when you ordered DBxtra. If your [...]
The Free Desktop Report Viewer – version 7.0.1 – now let’s you open reports from within the Viewer in multiple tabs.
If you’re running DBxtra in trial mode which enables you to publish your reports to both the Report Web Service and as physical report which can be opened with the Free Desktop Report Viewer. Once you order your DBxtra license, DBxtra will let you publish your report either as physical report (opens with the Free [...]
This guide is for those customers who upgrade to DBxtra 7 having previously another DBxtra version installed on your computer and who also access their repository from a Network Share (\\Server\Shared) or a Mapped Drive (Z:\Shared). Starting from DBxtra version 7, we no longer support repositories in Network Shares, that’s mainly because we have done [...]
Q: Would like to try your product but am unable to connect to my Oracle 10g database. It does not appear as though the connection screen requires enough information to properly connect. In order to connect with the Service name you need to have the tnsnames.ora file configured on the PC on which you [...]
Here is what you need to design and deliver reports.
DBxtra Designer The DBxtra Report Designer is the core part of the DBxtra reporting suite. It allows you to create projects, connect to your databases and define user-groups and user security. You can design queries, reports, charts, data grids and pivot tables. DBxtra Designer licensing: You’ll need at least one DBxtra Designer license to design [...]
The DBxtra Query is the core of all DBxtra objects. No SQL or programming knowledge is required to design Queries. The first step to design a Report Object like a Data Grid, Report, Chart or Pivot Grid is building the Query. You can create Queries from database objects like tables and views and also from [...]
DBxtra allows to organize your information with Projects. Each Project has its Data Connections, Object folders and Report Objects. Create a new Project Click "Project" on the "New" menu. Assign a Project name. Select User Groups who will have privileges to access the Project. Click "Create". If you want to create a Data Connection at [...]
Schedule Job Comparison Add Schedule Jobs The next step is to add a Schedule Job. Schedule Job – Simple E-mail This option can be useful if you need to send a message to your contacts. See also: Schedule Job comparison table Open the Schedule and click "Add Job". Select "E-mail – Simple". Click "Next". Enter [...]
The DBxtra Web Report Widget allows embedding of any DBxtra Report Object (Reports, Data Grids, Pivot Grids) into any Web page. IMPORTANT! You need to have a Report Web Service license to be able to the Web Report Widget. What you can do with the Web Report Widget Embed any DBxtra Report, Chart, Data Grid [...]
To connect to an existing Report Repository click "Connect to DBxtra Repository" on the "Utilities" – "DBxtra Repository" menu button. Running the Report Web Service Choose either "Report Web Service" or "Disk path / File Share" Enter the URL or file path. Report Repository Path To view the path of the Report Repository you are [...]
When you run DBxtra for the first time it will automatically install a Report Repository on the internal DBxtra Web Server which holds all definitions and Report objects of your DBxtra Projects. You can create a new Report Repository, edit an existing one and also move it to a new location. Create a new Report [...]
Let’s suppose you need to automatically send a sales report to your DBxtra users where each user sees sales figures only for his customers. DBxtra – Schedule Server –is able to do that. Here is a view of our reports underlying query. We added a user variable by double clicking the Criteria field. Click on [...]
DBxtra Schedule Server version 4.1.4 + – now works with Gmail, Yahoo and Hotmail accounts. You can now send from these E-mail accounts. Gmail Outgoing mail server: smtp.gmail.com Use SSL: Yes Port: 587 Yahoo Outgoing mail server: smtp.mail.yahoo.com Use SSL: No Port: 25 Hotmail Outgoing mail server: smtp.live.com Use SSL: Yes Port: 25
Open the Windows Service. Control Panel > Administrative tools, Select the DBxtra Schedule Server Service which was installed by DBxtra. Right click and select Properties and the Log on tab. Select This account and assign the user who starts the Windows session or any other user who has privileges to the shared resource and/or access [...]
Although DBxtra will configure your Report Web Service automatically it sometimes requires manual configurations. Here are instructions for the most common issues you might face. To start using the DBxtra Report Web Service you need to create a DBxtra Server Database, which contains the definitions of all projects and objects created in DBxtra. Install the [...]
If you want to run the DBxtra Report Web Service on a 64 bit OS then please read here: Running 32-bit Applications on 64-bit Windows (IIS 6.0) Windows Server 2003™, Service Pack 1 enables IIS 6.0 to run 32-bit Web applications on 64-bit Windows using the Windows-32-on-Windows-64 (WOW64) compatibility layer. IIS 6.0 using WOW64 is [...]
Pass login information from an external application to the DBxtra Report Web Service When you integrate DBxtra Web Service into another Web Application you may want to avoid a double login if your own Application has a login mechanism, this is a basic example of how you can do it, which means that you can [...]
Run DBxtra for the first time The DBxtra Report Repository holds all definitions and Report objects of your DBxtra Projects. When you run DBxtra for the first time you will be asked if to connect to an existing DBxtra Report Repository or to create a new one. The first thing you need to do is [...]
One of the features our customers enjoy most is the export to a linked Excel sheet. What is a linked Excel sheet? Usually if you export data to an Excel file you get a static data-set. A snapshot of the data as it is at the moment as you export it. Now; the linked Excel [...]
It might not be so obvious how to create a stacked bar chart with DBxtra. So; here is a simple example. Let’s take a look of the underlying query. We have built a simple Sum query for customer sales by customer and month. We added a top 5 to the query. Let’s open the DBxtra [...]
Sometimes charts might get quite crowded. For instance in the following Pie chart we show all countries where we have customers. To show only a certain amount of data; let’s say the top 20 do the following: Select the Chart. In the Property Grid select "TopNOptions"; Select "Enabled" "Yes" and then assign the "Count". Now [...]
One of our customer asked the following question: Is it possible to generate one report with different charts using the group by expression ? Since we have a huge number of equipments we would avoid to generate one report/chart per equipment manually (filtering by equipment_id) but we would like to have one chart per page [...]
Select the field and click on the small arrow. Select “Format String”. Enter a Symbol like €0.00. Click OK. Let’s see the report in preview. Here is final result: See also: Format Report Fields
One report with embedded sub reports Sometimes it is very convenient to produce reports which include other reports. For example your boss might ask you to deliver him a single report which contains report summary from various sources. DBxtra .NET makes it very easy to do just that. Below you see 3 report pages which [...]
One of our customers asked us how to place a Total filed into the Detail Band instead of the Group Footer. Here is how that can be established. 1. Move the Total field from the GroupFooter band to the DetailBand. 2. Set the Total field to Visible = No. 3. Select the Reports scripting language. [...]
Question: I need to surround a a value with a character like that: [value]. Answer: Select the field in the Visual Report Designer. In the Property Grid > DataBindings > Text – assign [{0}]. Now the value will display like this: See also: Format Report Fields
here is a workaround if you don’t want show blank fields in a report. Insert all required fields. Since we want to suppress lines without data for the "Email" field we select it and set its height to a small value like "2". We also need to set the fields value "Can Grow" to "Yes". [...]
Let’s suppose you have a Report where you have a Gran Total and need a summary percentage by year. 1.We have the following data sources. The first data-source – CUSTOMER PURCHASES TOTAL BY YEAR. Select DatePart(Year, Orders.OrderDate) As Year, Orders.CustomerID, Sum(([Order Details].UnitPrice – [Order Details].Discount) * [Order Details].Quantity) As Total From [Order Details] Inner Join [...]
How can I add Zebra strips on my Report? Here is a sample of a report. To add “Even” or “odd” Zebra backgrounds select the Detail band. Click "Style", select either "Even Style" or "Odd Style" and select a style to apply. Now; here is how the Report will look: See also: Report Fields, Labels, [...]
Learn how to create an anonymous report with customized properties. This example is based on the report sample "Product Catalogue by Category – Anonymous Login" provided in the DBxtra Sample project. Design the Report. Save the Report. Click "Allow anonymous access in Report Web Service. Click the "Customization" button. Define your Customization. Click "Save". Let’s [...]
This approach of designing a drill down report can only be achieved using the DBxtra Report Web Service. Design the Detail Report The detail report needs to have a input parameter assigned on the field which will link to the main reports. Insert a parameter into this filed. Design the Sub Report. Save the report. [...]
DBxtra .NET allows total query synchronization between the diagram, grid and SQL pane. You can simple paste a SQL syntax from any other application to the SQL pane and DBxtra .NET will automatically create the query for it. DBxtra will create the Query for you.
One of our customers recently needed to use Constants – which may vary from time to time – in his DBxtra Queries. We built a sample query object explaining how to do that – CONSTANTS Sample – Invoices Detail {MXN to EURO, USD & YEN}. 1.- We created a new query object (Constants Table) which [...]
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. This functionality only applies to connections to MS SQL Server, MS Access, MySQL and Oracle databases. DBxtra – Expression Converter See also: Convert Expressions
Learn how configure nested input Parameters. See also: Insert Parameter
Let’s suppose you want your end-user only see sales data from customers assigned to him. Here is the query of the report. For now the report shows records for all customers. Let’s assign a user variable. Double click on the Criteria/Parameter field. The Criteria Builder will open. Click "User-Variables". Assign a name for the user [...]
One of our customers asked if he need to have the TNSNAMES.ORA file configured on the user’s box for them to use DBxtra? Answer: There are three ways to connect to Oracle. 1. Direct Connection to Oracle You need to provide the Service name; which is the TNSName – TNSNAMES.ORA (Network Configuration File) which is [...]
Some user who connect to MS SQL Server with Windows authentication experience problems when running the DBxtra Report Web Service. They might get a “Login failed for user ‘(null)’. Reason: Not associated with a trusted SQL Server connection” error message. Here is the cause of the problem and the solution for it: When you use [...]
Question: I can’t access my MySQL database on my shared hosting plan. Answer: Most ISP with shared hosting and also with VPS don’t allow access the the MySQL databases from outside the web-site. But in most cases you can add an exception in the CPanel. Select MySQL Databases. Enter your IP address. To get your [...]
Question: We are now deploying the Dev tables and Dev views to Production. How can I easily change the connection used on a report (from Dev to Prod)? The tables and view will be identical(Dev and Prod), the report just needs to change the connection to a database. Answer: The easiest way to do that [...]
Do you provide training? Absolutely. Please contact us for a quote. via FAQ – Support.
Yes; we offer one year of free maintenance which includes e-mail support and all upgrades for free. After the first year you need to order a maintenance plan to enjoy e-mail support and all free upgrades for one more year. The maintenance plan costs 20% of your current licenses value for one more additional year.
License key by E-mail 12 month of all Upgrades and E-mail support 30 Days of Unconditional No Questions Asked Money Back Guarantee
Just contact us and we we will send you a trial extension license key.
Absolutely; once you get a license key than you can use DBxtra with all your created connection, queries and reports.
© 2006 - 2012 - Advisionario S.A. de C.V.
