Reports Setup

Bank Recon supports local mode processing reports. This means you don't need to have a Reporting Server running. Reports are designed to Reporting Services and the rdl is uploaded into Bank Recon directly. We use the Microsoft Report Viewer 2012 runtime to display the reports. The rdl's need to be designed in Visual Studio 2010, 2012 or the stand-alone Report Builder 3 tool.

11 standard reports ship with Bank Recon. These will always be created in the install folder. If you want to use them, then select the Reports option as part of the msi and they will be available from the UI. If you decide you want to use them later, upload them as per the steps below. We'll always maintain the standard reports and update them as required. If you feel you have another report that should be standard, send us a sample and we'll add it, if it makes sense.

You can also design your own reports. Please use the following views to do so. If you need any columns not included in the view, let us know and we'll add them. If you query the tables directly we can't guarantee that your reports won't break one day. We will always maintain the views. Don't name your own reports the same as our custom reports. They might get overwritten by accident

  • Reporting_CashbookTransactionViewStandard

  • Reporting_BankTransactionViewStandard

Reports Setup

Before reports can be viewed in Bank Recon, they need to be configured and set up, including the data source and reporting files. Selecting Setup>Reports>Data Sources navigates the user to the Data Sources screen for reports.

This is where the data sources that reports use are configured. A new data source can be added by selecting the Add button. The user enters the name and the connection string to the desired data source.

Selecting Cancel will return to the Data Sources screen. Selecting Save will add the data source and direct the user back to the Data Sources screen. A data source is edited by selecting the name.

Selecting Save will edit the source and direct the user back to the Data Sources screen.

Next, the reports need to be set up. Selecting Setup>Reports>Upload Reports navigates the user to the Upload screen for reports.

A new report is added by entering a name and description, and then uploading the relative RDL file with the browser. Selecting Save will uplaod the report which will then be ready for use through BankRecon. Reports are removed by selecting the delete icon.Update an existing report by importing the new rdl and giving it the same name. When prompted click 'Ok', you want to override the existing report with the same name.

In order to default and disable the Domain and Account parameter drop down lists (if included in the report) to the selected Domain and Account, the Parameter names in the RDL need to be named as follows (exact text and case):

    • domainid

    • accountid

This maps the Report parameters to the application values. Only the Parameter name needs to be exact. The Label and parameter name in the Datasets can be anything.