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.
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" [...]
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 [...]
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". [...]
© 2006 - 2012 - Advisionario S.A. de C.V.
