• Welcome to the upgraded JDELIST forum and thank you for your patience.
    Please restrict discussions and issues regarding the new forum software to the Off Topic forum. We will be monitoring that forum for issues.
    If you have trouble logging in, please reset your password using the forgotten password form: https://www.jdelist.com/community/index.php?lost-password/
    If you are unable to successfully reset your password, please contact us: Click here!
    We hope that you enjoy the upgraded forum.
  • Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

SQL Server Reporting Services

Hodgie

Member
Is anyone using Reporting Services to create financial reports over the F0902 and F0911 tables? We are looking at options to replace FASTR reports and want to know if SSRS is a viable option. Right now we are running on an AS400 but will migrate to SQL Server when we upgrade to 8.12.
Any input is greatly appreciated.
 

acrigger

Member
Hello,

If you are trying to use SQL Reporting Services to develop financial reports against the F0902 and F0911 you will likely have to perform a great deal of work to get a good template in place that you will use to build your reports from. One of your biggest tasks will be to perform calculations to derive your column amounts and units. As you are probably aware, the F0902 stores data by Fiscal Year, Account ID (BU.Obj.Sub), Ledger Type, Subledger, Subledger type etc with each month value stored in a different field.

Using SQL Reporting Services with JD Edwards Financials will likely require you to perform what we have done for Crystal Reports, which is providing Financial Reporting Templates with the applicable tables defined and joined together by JD Edwards module with hundreds to thousands of formulas provided with all variations amounts and units formulas like i.e. Current Year – Year-to-Date – Actual Amount. You will need to build different formulas to derive (Month, Quarter to Date, and Inception to Date), (Amounts and Units), (Actual and Budget), etc. Some other considerations is when defining row-based reports like financials in that you will want to create your rows so they are flexible to support multiple criteria whether they are defined by Account, Business Unit, Acct Cat Codes, BU Cat Codes, etc, but also combinations of these as well. Using Preferred Strategies templates, we have examples of JD Edwards World customers have replaced hundreds of FASTR reports with an individual Crystal Report.

Preferred Strategies provides this logic to JD Edwards customers for Crystal Reports but not SQL Reporting Services. Have you considered Crystal Reports?
 
Top