Welcome, Guest. Please login or register.
Did you miss your activation email?

Author Topic: IMPORTING POSTGRESQL FILE to limereport designer  (Read 1821 times)

solomon78

  • Newbie
  • *
  • Posts: 24
    • View Profile
IMPORTING POSTGRESQL FILE to limereport designer
« 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  :)
« Last Edit: September 04, 2018, 06:38:02 AM by solomon78 »

Subst

  • Sr. Member
  • ****
  • Posts: 442
    • View Profile
Re: IMPORTING POSTGRESQL FILE to limereport designer
« Reply #1 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?

solomon78

  • Newbie
  • *
  • Posts: 24
    • View Profile
Re: IMPORTING POSTGRESQL FILE to limereport designer
« Reply #2 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 
 

Arin Alex

  • Developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 992
    • View Profile
Re: IMPORTING POSTGRESQL FILE to limereport designer
« Reply #3 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)
« Last Edit: September 04, 2018, 10:39:30 PM by Arin Alex »