FAQ
BIReport Backup
It is always suggested to backup BIReport before every installation. to do so you have to backup the SQL Database and the ReportLayouts folder in C:\inetpub\wwwroot\BiReportManagementConsole Actually, to save also the configuration, it is better to ...
Styles
The Appearance Properties In the Report Designer, are port and each of its elements (bands and controls) has a complete set of appearance options (such as Background Color, Borders, Font, Foreground Color, Text Alignment, etc.). By default, these ...
Useful Format Strings
The decimal and thousands separators are set following the culture of your machine. To create format patterns for date and time values, combine the strings listed in the tables below. These strings represent the year, month, day, number and so on, in ...
How to create a custom summary?
Scenario: In QlikView you have a table where some of the totals are the division between two totals, or when there are percentages, so you cannot simply use the group (or report) summary. Solution 1: Use the custom summary event. Select the label ...
How to use two axes for different order of magnitude of data in two series?
Scenario: You have to represent in a chart two series of data that are very different. For example, one is in the order of tens the other of hundreds of thousands. Solution: Use a secondary Y-axis, and connect it to the series. In Chart Wizard, go to ...
How to add an alert label to the chart?
Scenario: In a chart, you want to show a label with an alert every time a value surpasses a defined threshold. Solution: Replicate the procedure in the previous section, using the function: private void ChangeLabelText(object sender, ...
How to conditionally colour a chart?
Scenario: In a bar chart, you want each bar colour depending on its value. Solution: Add the chart to the Report, and with the chart selected go to scripts. Add the following script: // Apply different colors to the bars depending on their value ...
How to add an index?
From the toolbox, drag and drop the tool Table of Contents in the Report Header. Open the Table of contents tasks window clicking on the little arrow on the top right of the object, click on the ellipsis and Add a new level. Set the appearance and ...
How to create a multi-column report?
Scenario: the desired output is like this: a multicolumn output from a straight table in QlikView™ Solution: create a multicolumn layout for the detail band. Click on the little arrow on the detail band header, while the band is selected. In the ...
How to set a dynamically image form a QlikView table?
Scenario: In a QlikView table, each item is associated to an image inside the disk. How to replicate this dynamic association inside BIReport? Solution: add a Picture Box to the report and while it is selected, open the Script Editor and select the ...
How to create a chart with auto created series?
Scenario: you have this bar chart in QlikView. The straight table for it is this one, with one column for type, one for date, and one for number. You cannot use series to create that chart in BIReport, since you do not have a column for each type. ...