Getting started with first report

  • rgbatson

    I have a connection to hosted database through ODBC. Option load from database only shows a report name "Grade" and doesn't display anything. No Help to fo further. Any suggestions?
    Thank you
    Bob Batson

  • Gil


    First: OpenRPT has moved to become part of the PostBooks project on SourceForge. PostBooks is the open source version of xTuple ERP. Go to for the latest version of OpenRPT. Go to for more recent information and more active forum discussions than you'll find here in the OpenRPT project.

    Now, back to your request:

    Have you read the documentation? You can find it at

    Do you have an xTuple ERP database? If so, we'll need more information, such as what version of OpenRPT you're using, what version of the xTuple ERP database, etc.

    If you do not have an xTuple ERP database but do have a "report" table, then there are probably no reports to load. Click the New button or select New from the File menu to start building a new report.

    However, if you do not have an xTuple ERP database then you probably don't have a "report" table in your database, either. If this is the case, you have two choices:

    • work with report definitions as XML files instead of loading them from and saving them to your database

    • create a report table

    Here is the table structure for PostgreSQL:

                                                   Table ""
         Column      |            Type             |                             Modifiers                              
     report_id       | integer                     | not null default nextval(('report_report_id_seq'::text)::regclass)
     report_name     | text                        | 
     report_sys      | boolean                     | 
     report_source   | text                        | 
     report_descrip  | text                        | 
     report_grade    | integer                     | not null
     report_loaddate | timestamp without time zone | 
        "report_pkey" PRIMARY KEY, btree (report_id)
        "report_name_grade_idx" UNIQUE, btree (report_name, report_grade)

    In case the "default nextval(('report_report_id_seq'::text)::regclass)" looks unfamiliar, report_report_id_seq is a sequence counter and nextval() increments it (see the PostgreSQL SEQUENCE documentation). The result is that report_id is a self-maintaining primary key.


  • rgbatson

    Thank you, Gil.
    This is a whole education, and I will work to catch up with you!
    Bob Batson