페이지 이력

...

Move beyond managing stacked Excel files each year — and being to view and analyze profit and loss data more conveniently online.

...

• • • From the EPA main screen, go to [Menu] > [ToolsTool] and launch i-AUD Designer.

    • Drag and drop the saved Excel file into the i-AUD Designer window.

    • The Excel report now appears in the web view, preserving the original layout.
      
      
      

    • Ensure the report automatically resizes to fit the web browser window.

    • In the Properties pane on the right, check Docking: Left, Right, Bottom.
      
      
      
      

    • To remove the border from the report on the designer screen, set the Line Type property under Border to ‘None’.

...

• • • Next, add and configure the 'Year' filter to view the Income Statement report by year on the web.
    • Place a ‘Year’ label and a calendar so that users can select the year, and add a ‘Search’ ‘Refresh’ button to refresh data when clicked.
      
      
    • From the UI Bot menu at the top, click Label and place it on the designer. In the Properties pane, change the Text propertyto ‘Year’, or press F2 on your keyboard. You can also customize the label’s font, color, and other style properties in Style.
      
      
      
      
      
    • Next, add the calendar.
    • From UI Bot > Calendar, click Year and place it next to the label..
    • Set the calendar’s Name property to 'VS_YYYY', the same variable you defined in the Excel’s ‘Name Manager’. This ensures that the value selected in the calendar is used as the filter condition.
      Optionally, set InitDate to define the default value when the report is first opened.
      
      
      
      
      
    • Finally, add the ‘Search’ ‘Refresh’ button to the designer.
    • From the UI Bot menu at the top, click Button and place it in the desired location on the designer.
    • Similar to the ‘Year’ label, change the button’s Text property to ‘SearchRefresh’, and adjust its formatting in Style.
      You can use BoxStyle to quickly apply a saved style to the button.
      
      
      
    • Set up an event so that when the ‘SearchRefresh’ button is clicked, the report data is refreshed using the value from the Year variable.
    • Click Process Bot at the top. In the Objects panel, double-click Button with a name ‘Search’‘Button’; in the Activities panel, double-click 'Refresh'.
    • In the Refresh module details, select the MXGrid component to refresh, and drag a connection line from the Button to Refresh Module.
      (Note: Dragging and dropping the Excel file onto the web screen automatically creates the MXGrid component.)
      
      
      
    • Save and close the Process Bot.
    • The report setup is now complete.

...