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

Author Topic: IMPORTING POSTGRESQL FILE to limereport designer  (Read 3471 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: 450
    • 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: 1005
    • 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 »