Knowledge Base

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.

Real time Report Samples

To take a look at real time sample reports on a live connected Report Web Service please click here.

Assign a custom symbol for a report field

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

Design a Report with unbound Reports

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 [...]

Place a Total field in the Detail Band

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. [...]

Surround a value with a special character

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

How to suppress blank fields in a Report

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". [...]

Calculate with Scripts

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 [...]

Zebra on Reports

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, [...]

Anonymous Report – with customized Properties

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 [...]

Drill Down Reports

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. [...]

© 2006 - 2012 - Advisionario S.A. de C.V.