Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

Getting started with first report

Help
rgbatson
2012-07-11
2013-04-26
  • rgbatson
    rgbatson
    2012-07-11

    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
    Gil
    2012-07-13

    Bob,

    First: OpenRPT has moved to become part of the PostBooks project on SourceForge. PostBooks is the open source version of xTuple ERP. Go to https://sourceforge.net/projects/postbooks/files/13%20PostBooks-OpenRPT/ for the latest version of OpenRPT. Go to xtuple.org 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 http://www.xtuple.org/sites/default/files/prodguide/OpenRPT-ProdGuide2.0/index.html

    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 "public.report"
         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 | 
    Indexes:
        "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.

    Gil

     
  • rgbatson
    rgbatson
    2012-07-13

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