NextReports Layout Zoom

Version 3.4 of NextReports Designer makes use of moving to Java 1.6 and brings a wanted feature.

Report Layout can be zoomed between 50% and 300%. Values outside this range were not considered suited for designer. A zoom can be done with the spinner in the top right corner or with the CTRL + mouse wheel, same way as browsers zooming.

This feature is most useful if font size for a cell is too small. If that cell also contains a database column , the user interface combobox popup will have items which cannot be understand. By zooming the layout, this is not true anymore and user can see what he is doing.

NextReports : dynamic values for scheduling

Until server versions prior to 2.4 , the only way to have dynamic parameter values was to have those parameters defined as hidden. From version 2.4 you may have dynamic values also for visible parameters.

What does this mean?

NextReports engine recognizes "hidden parameters", meaning those parameters that are not visible at runtime, but which have default values declared in their definition.

On the server, a report can run instantly or it can be scheduled to run at some moments in the future. There is the possibility to want to run the same report instantly and also to schedule it. For some visible parameters with default values, we may have to "override" their values selected in user interface with default values computed at runtime. For these cases , the schedule process introduces a new property in parameter selection panel.

Every parameter which has default values provided by an sql select, will have inside user interface a boolean property called "dynamic" :

• If this property is false, the report will be executed with the static value(s) entered.
• If this property is true, the report will be executed with dynamic values, meaning the sql for default values is executed at runtime.

NextReports 'Hide when expression' property

NextReports Designer version 3.3 will add a new important feature to its core engine. A new property called 'hide when expression' can be set for every layout cell .

What does this mean?

This property contains an expression. If expression is evaluated to true at runtime, the cell content will be empty in the resulting exported report file. Also, if all cells from a row have 'hide when expression' property set and all those expressions are evaluated as true, the entire row will be hidden.

Example

Lets show an example with default Timesheet report.

You can see detail row D1 with some expressions. $E{WorkHours} expression  represents the work hours from column $C{Hours} and it is defined like this :

All other expressions are similar testing the corresponding activity code.

Because we do not want those expressions to be shown at runtime, we will set 'hide when expression' property for the containing cells. In this case, the expression is one which will always be true :

All cells from D1 row are always hidden, so the entire row will be hidden. That is why there is no need to set other properties for those cells like color, font and so on.

Expressions are used in some functions which can be seen in footer rows. For example, the total work hours is a function created on $E{WorkHours} expression :

 In this way we can have a more detailed report as seen in following results :

NextReports Server 2.3

Forthcoming NextReports Server version will bring some new features regarding dashboards :

• Any widget (chart/table) from dashboard can be detached, resulting a popup frame which can be maximized to full screen (with F11 key) . This will allow to view a chart on a plasma.

• There is a new action 'Go to entity' which will redirect the user to the chart / report used by a widget. This will offer an easy way to update or to do any supported action for that entity.

• Widgets have now an auto-refresh time (in seconds) property which can be modified from settings action (0 means no automatic refresh). This property will also be used inside a widget detached popup frame (instead the general "update interval" property defined in application settings)

Also, from this version, user is allowed to manually enter multiple values for parameters. Previous versions allowed only for manual single insertion (from a text field, calendar and so on) .

You can view these features in Online Demo version. ( demo / demo  )

NextReports Server - Job Monitor

From version 2.2 Job Monitor will show you both

1. reports running jobs (created with run action)
2. active scheduled jobs (created with schedule action) 

It is a better approach to have all components with auto-refresh in monitor panel. Previously, active scheduled jobs where seen in 'Scheduler management'. There were two identified problems with this :

1. functional : because any management section has a a lot of actions that are happening in the same page, some errors appeared with auto-refresh  which brought a page expiration and the user was shown the login page
2. structural & security : it is more intuitive that all running jobs be seen in the same place

NextReports Server Online Demo

NextReports Designer 3.2 and Server 2.2 were released today.
Also a server online demo is up and running.

Visit us at http://www.next-reports.com/index.php/documentation/nextreports-server-documentation/online-demo.html

Excel Palette

Excel offers only 56 colors in its standard palette. Java color chooser allows to select colors that are not understand by some Excel versions.

Because of that, we extended java JColorChooser with an "Excel Palette" tab to allow standard color selection:

In this way, we are sure that the selected colors will be the same in the generated excel file.

NextReports 3.2 : Group Row Variable

A Group Row variable is inserted from version 3.2

Depending on which band is used, this variable will show the current row from the enclosing group. If no group is defined inside report, this variable is identical with Row variable which shows the number of current record.

Using the variable inside an expression like

$V_GROUP_ROW + 
". " + 
$C_First_Name + 
" " + 
$C_Last_Name  

will show the next result :

Layout Expressions

From version 3.2 NextReports allows to insert expressions inside report layout.

Inside query designer there is already the possibility to add column expressions (any expressions that the current database type allows).

But if you have a query created with editor, the solution is to add expressions inside report layout. Such expression can contain besides sql columns, parameters and NextReports defined variables.

Columns $C{}, variables $V{} and parameters $P{} are evaluated at runtime, and after their evaluation the entire expression is evaluated. If expression is created in a cell outside detail or group bands , user cannot insert columns inside expression.

Expression editor allows to create :

• numeric expressions : 

  $C_Hours * 60

• string expressions :

  $C_Last_Name + " " + $C_First_Name

• conditional expressions :

  if ($C_Hours < 8) { y=0; } else { y=1; }

For advanced users, it is also possible to call java methods for the specific object type. For example, for a String we can call any methods from java.lang.String class :

$C_Last_Name.toUpperCase()

NextReports (version 3.2) Formatting Conditions

A very useful feature for reports is the possibility to mark somehow a value.It may be outside a desired range or it may be equal / not-equal to a specified value. Think about a medical test report (if some index is less or greater than normal values).

To achieve this in NextReports, a new property called "formatting conditions" is used. By selecting a column or a function cell in the report layout, you could modify this property.

For example, we want to highlight in different colors the activity code inside a project time sheet. For every code we are interested in, we can choose a different foreground.

When we add a render condition, we can choose which property we want to modify at "render time" , like foreground, background, font, color. We select an operator, the value we want to compare with and the property value. The property value will overwrite the general cell property defined in the layout if the condition is met.

And the result is here :

Web Service to run reports

NextReports Designer uses a web service to publish / download reports to a NextReports server.

To integrate reports in a proprietary  application where we want to generate some reports with specific parameters from that application, we created a new report web service.

This will allow for a very simple integration with a NextReports server :

RunReportMetaData runReportMetaData = new RunReportMetaData();

runReportMetaData.setReportId(reportId);
runReportMetaData.setFormat(HTML_FORMAT);

Map parametersValues = new HashMap();
parametersValues.put("Id", 2);
runReportMetaData.setParametersValues(parametersValues);

try {
    String url = webService.runReport(runReportMetaData);
} catch (WebServiceException e) {           
    showError(e);
}

Table Widgets in NextReports Server

NextReports Engine has now support to export a report / chart to a table, a memory object with a header and data. This exporter is used on the NextReports Server to add a table widget inside the dashboard.

Widgets can be renamed through an editable label, near the collapse / expand button. Similar to charts, tables have settings (parmeters values), can be refreshed or deleted.

From server version 2.1widgets can be saved as excel. For a table widget this is obvious. For a chart widget, the excel will contain X column and all Y columns defined inside the chart.

XML Export

From 3.0 version a report can be exported to xml .

Generated predefined tags  are :

<document> for the exported file
<record> for any row from layout
<text> for static text
<image> for images

All the other tags for database columns, functions, hyperlinks, parameters, variables are represented by the name of the entities.

Some simple example for a report with just the columns in the detail band :

<?xml version="1.0" standalone="yes"?>
<document>
    <meta name="author" content="Advantage Software Factory"/>
    <meta name="creator" content="NextReports 3.0"/>
    <meta name="subject" content="Created by NextReports Designer 3.0"/>
    <meta name="date" content="Tue Mar 09 14:36:10 EET 2010"/>
    <meta name="keywords" content="www.next-reports.com"/>
    <record>
        <Project>Boom Server</Project>
        <First_x0020_Name>Brandon</First_x0020_Name>
        <Last_x0020_Name>Dunn</Last_x0020_Name>
        <Hours>2.0</Hours>
        <Date>2008-09-01</Date>
        <Activity_x0020_Code>WRK</Activity_x0020_Code>
    </record>
    ....... 
</document> 

Designer 3.0 & Server 2.0

NextReports Suite was launched with :

• charts & dashboards
• images for pdf, rtf, excel, html reports
• xml export

Designer release notes
Server release notes

As easy as "Pie"

       In the same manner as report integration, to view a Next flash chart in you application you have to do three things :

• start a local web server
• write just a few lines of code which will create a json file :

ChartRunner runner = new ChartRunner();
runner.setChart(chart);
runner.setConnection(connection);
runner.setQueryTimeout(queryTimeout);
runner.setParameterValues(parameterValues);
OutputStream os = new FileOutputStream(webRoot + 
                  File.separatorChar + "data.json");
boolean result = runner.run(os); 
os.close(); 

• open the url :

openUrl("http://localhost:" + webServerPort + "/chart.html?ofc=data.json");

And that is all. 

New Charts Types

New charts are emerged

• Horizontal Bar Chart
• Charts with more columns on Y Axis : comparative charts for Line, Bar and Horizontal Bar
• Stacked Bar Chart

Seeing the designer downloads is very useful.

Charts

Time to add charts to NextReports has come.

Similar to report, a new chart perspective is created. In here user will modify chart layout, which consists of four components : title, main, X Axis and Y Axis. Any component has a list of properties.

Charts can be previewed from NextReports designer. Default browser is opened with a flash object created from a json data file.

Charts can be published to a NextReports server where any user can add them to a a dashboard for viewing in real time.

NextReports - Image support

Designer v3.0 will add support to image rendering in HTML, EXCEL, PDF, RTF. A new Insert Image  action will be available in layout. Image will not be scaled.

Also NextReports Server will allow for adding report images . Download action will return a zip archive with '.report' file and image files if any.

NextReports - Metadata

Generated reports in HTML, EXCEL, PDF, RTF contain now metadata.

Every report has now a title (file name), author, subject, creator and keywords. From these you can see the NextReports Designer version, and the NextReports site link.

NextReports - Publish - revisited

Login Panel supports now not just to add, but also to edit and delete, a server. Also, the login for a specific server may be 'remembered'.

 

After a report is published  , name, server path and data source are also remembered, so a new publish update operation will be done faster.