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?