adding status column to SI GL trial balance report

SOLVED

I created an SI report that is basicly a GL trial balance report because I want to show the ending balances for a 12 month period. So I added a column that I want to show the status of the GL account (active, inactive, deleted) . In the connector there's a table that uses the GL Account table and therefore, I am able to select the status field. So in the Report Viewer I created a subreport that contain this table so that I can use the status field but I am havig problem showing the "status" of the GL account on the report. Are there other areas in the subreport that I need to use? See the screen shots below.

Thank you

Manny

Parents Reply
  • +1 in reply to manny99
    verified answer

    Yes. Go to the Accounts Sub Report. Report Designer Add-In - Accounts 1-0

    Go to the reports Container.

    Add an Expression.

    Select Data Field

    Select GL_Account

    Select Status

    Go back to the sub report Report Designer Add-In - Accounts 1-0

    Go to the Columns tab and add Status to the end.

    Run the Report.

    Unhide the Accounts tab should look like the following:

    On the tab you have the Trail Balance in the Status Column link it to the Accounts tab Status Col.

    Thank should do it.

Children