Switching Grids in FRS Studio

FRS stands for Financial Reporting Studio used for developing Financial Reports like Income Sheet, Balance Statement..

If there are multiple Grids in the Report, to move between grids, use Bring to Front and Send to Back options

                       

Here we have 2 grids, to get Grid2

Go to Format > Bring to Front

After clicking it

Now to move the grid back

Select  the Grid and go to Format, click on Send to Back

   

After clicking on it,

Drill Through in FRS

Drill option in FRS is used to navigate from FRS Report to Account Inspector or Detail Balances to check transactions.

Steps to select Drill Option

Step-1: Hide task bar

To do this, right click on task bar, go to task bar settings

 Click on Automatically hide the task bar in desktop mode

Step-2: Now go to FRS Studio, select grid. Now we can find Drill Through option on right side bottom corner ( in Grid Properties - General)

Expand All Option In FRS

Expand All is used to expand all rows in the Report when expansions are placed. When Expand All option is chosen and once all expansions are expanded , we find Collapse All option to close all expanded rows.

Steps to select Expand All in FRS Studio:

Step-1: Hide Task Bar

To do this, right click on task bar, go to task bar settings

 Click on Automatically hide the task bar in desktop mode

Step-2: Now go to FRS Studio, select grid. Now we can find Expand All  option on right side bottom corner ( in Grid Properties - General)

Opening FRS Studio and creating a Report

After Installing FRS Studio, Open it.

Step-1: Enter User Name, Password and Server URL to open Studio.
             Server URL is nothing but Fusion Instance URL

               After giving credentials, Studio opens as follows

Step-2: Go to File > New > Report

         After Clicking on Report

Step-3: Before creating report, we need to set Database Connection

            

              Click on New Database Connection

                                   

            Enter details like Database Connection Name  and others..

            Database Connection Name can be any arbitrary name

            Click "OK"

                 

Step-4: After setting database connection, continue with report creation.

            Go to Insert > Grid

           After Inserting Grid, select dimensions and click on "OK"

         After selecting dimensions, report appears as shown

            

Installing FRS

Installing FRS

FRS stands for Financial Reporting Studio used for Financial Reports in Oracle Fusion

There are 2 ways to install FRS

Method-1:

Go to Fusion Instance > Login > Navigator > Reports and Analytics > Browse Catalog > In Analytics Home Page at Left Bottom, click on "Download BI Desktop Tools" > Download "Financial Reporting Studio" > Install it

Method-2:

Fusion Instance > Login > Financial Reporting Studio >  Open workspace for Financial Reports > Tools > Install > Financial Reporting Center > Install it.