Renown Software
FRx in SSRS
Renown Financial Reporting                                       Summary Video 

The Renown Financial Reporting module uses Dynamics SL and SQL Reporting Services "SSRS" to generate financial reports using a similar paradigm to Microsoft Dynamics FRx.

The report elements; Hierarchy (Tree), Columns, Rows and Fonts are defined in Dynamics SL maintenance screens.  The report reads the structure, formatting and GL balance data from Dynamics SL and renders the result to web reports using SQL Server Reporting Services and SharePoint. Using SQL Reporting Services provides more freedom in report design and easier deployment and generation of reports in a web environment.  

A genuine FRx alternative. Delivering the power of SSRS to finance and management teams.

E-mail sales@renown.com.au if you would like to attend a webinar on a date to be agreed.

SSRS Financial Reporting Designer 
       
Report Hierarchy (Tree)      Fonts     

A Dynamics SL screen is used to define report hierarchical structures using SL Company and Subaccount segments. Reports display at each tree leve,l via drilldown similar to FRx.

Video   

  

Font codes can be created that define font, bolding, size, back colour, borders, etc.  These font codes can be applied to columns and rows in the report for emphasis.

Details   

Report Columns         Report Rows       

Column Maintenance defines the GL balance to be displayed in the report columns. Links to any SL Ledger (Budget, Actual), for YTD or MTD values and allows user defined formulas.

 Video 

  

Rows define the lines of the report and can be Descriptions, Accounts or Sub-Totals. Account and Sub ranges can be defined. Non-print rows can be used for calculations.

Video   
 
SSRS Financial Reporting - Display
       
Report Generation        Drilldown & Notes

A SQL Server Reporting Services report is designed to read the report design elements above (Tree, Columns, Rows, Fonts) and the applicable GL balance to render the web report.

Video   

  

It is possible to drilldown through the Tree Hierarchy displaying the full report at each level or node. Notes can be entered in the rendered report and reprinted as annotations.

Video