LimeReport Forum

General Category | Основное => Discussion | Обсуждение => Topic started by: solomon78 on September 04, 2018, 06:31:59 AM

Title: IMPORTING POSTGRESQL FILE to limereport designer
Post by: solomon78 on September 04, 2018, 06:31:59 AM

please can anyone help me on how to import postgresql database file to limereport designer, I thought one will use the same approach as that of sqlite database  file but it didn't work  :)

Title: Re: IMPORTING POSTGRESQL FILE to limereport designer
Post by: Subst on September 04, 2018, 07:18:58 PM

you need the postgresql plugin first. Have you one?
do you lunch LR itself or from your program?

Title: Re: IMPORTING POSTGRESQL FILE to limereport designer
Post by: solomon78 on September 04, 2018, 09:38:52 PM

Thank you Subst, I later got the solution to it,

Connect Name:  ASD_tab
Driver:        QPSQL
Server:        127.0.0.1
User:          postgres
Password:      ************
Database:      postgres

I was having problem with the Database initially, I thought it can only be done through uploading, the above work well for my problem it also worked fine in below

Connect Name:  warehouse_tbl
Driver:        QPSQL
Server:        127.0.0.1
User:          postgres
Password:      ************
Database:      warehouse_db

I will still like to know solution on that of plugins u said. I really love LimeReport Designer 
 

Title: Re: IMPORTING POSTGRESQL FILE to limereport designer
Post by: Arin Alex on September 04, 2018, 10:36:32 PM

Hi!

Quote

I will still like to know solution on that of plugins u said

Subst meant that you need libqsqlmysql shared library (Qt plugin for postgres database)