Reporting with ReportViewer in Visual Studio

With finaquant® protos (non-commercial) or finaquant® calcs (commercial) a .NET developer has everything she needs for analytical table computations and database connection (i.e. storing and reading complete data tables).

Sometimes, tables need to be broken down into matrices for detail processing. As shown in our related forum post, the available matrix and vector functions in finaquant libraries can easily be extended with other numerical .NET libraries like ILNumerics that offer more specific functions for statistics and optimization.

Reporting (presenting data visually in well-formatted layouts and pdf files) is the only missing link. Luckily, basic reporting functionality is built in Visual Studio and .NET framework. Following video demonstrates how a simple report with a parameter can be created with ReportViewer:

You may find more information about reporting at Finaquant Community Forum explaining:

  • How to bind a DataSet to a report as data source programmatically (dynamic binding)
  • How to export a report to a PDF/WORD file programmatically (without preview)
  • How to send an Email with (PDF/WORD) attachment from an SMTP email account
Posted in Calculation engine | Tagged | Leave a comment

Simulation of Dealer Commissions with Matlab

As demonstrated in an earlier article dealer or sales commissions can easily be calculated with the .NET Calculation Engine finaquant® calcs.

This article demonstrates how changes in commission amounts can be simulated by varying selected table-valued inputs. In example presented here, the math software Matlab is connnected with the Calculation Engine implemented with finaquant® calcs in order to:

  1. Control the variation of selected inputs; Sales and Commission Scales.
  2. Reporting: Visualize the resultant total commissions with plot diagrams.

Simulation of Dealer Commissions

Simulation Scenario

Continue reading

Copyright secured by Digiprove © 2013 Tunc Ali Kütükcüoglu
Posted in Calculation engine, Fee and commission calculations | Leave a comment

Finaquant’s Matrix and Vector Functions

Both of our .NET libraries finaquant® protos (non-commercial) and finaquant® calcs (commercial) contain Matrix and Vector functions in addition to Table Functions. In fact, table functions are higher level constructs that are based on matrix and vector functions of the library.

You may find examples for Matrix and Vector functions in the Visual Studio file FinaquantCalcsStarter (or FinaquantProtosStarter) that you can download at the corresponding product page (see related downloads).

Visual Studio file FinaquantCalcsStarter

Parallel to field types of tables (text attribute, numeric attribute, key figure) there are three types of matrices and vectors:

  1. KeyMatrix/KeyVector (double)
  2. NumMatrix/NumVector (integer)
  3. TextMatrix/TextVector (string)

Here are some examples for creating matrices, and making operations with them: Continue reading

Posted in Calculation engine | Tagged , | Leave a comment

Table Function Demo with Microsoft Excel

As mentioned earlier in a related article Table Functions of the .NET libraries finaquant® calcs (commercial) or finaquant® protos (non-commercial) can be called from an excel sheet.

Following example demonstrates:

  • How Table Functions can be called from excel macros (VBA)
  • Generally, excel-.NET integration: How C#/.NET methods can be called from within excel macros (VBA)
  • How data tables in excel worksheets can be read and written by C#/.NET methods
  • How simple parameters (string, integer, double) can be passed from excel macros to C#/.NET

Calling Table Functions from Excel

In order to run the demo with excel:

  1. Download and install finaquant® calcs, Calculation Engine based on Table Functions (.net library).
  2. Download and open the Visual Studio project CalcsExcelIntegration as Administrator (Right-mouse MS Visual Studio, Run as Administrator).
  3. Build (or rebuild if you have already built) the VS project (ensure “Register for COM interop” is checked as build option under Project Properties).
  4. Open the excel file named CalcsExcelDemo (double click) under the folder named Resources in VS project CalcsExcelIntegration.

Continue reading

Copyright secured by Digiprove © 2013 Tunc Ali Kütükcüoglu
Posted in Calculation engine | Tagged , , | 2 Comments