No possibility to create a report based on postgresql
No possibility to create a report based on postgresql
Hi,
I've connected to postgresql database directly and for schema "public" I can retrieve all the columns. But when I click on "preview" (I do not have to put even any data on the report template) there is an error that sort of "relation" does not exists.
I'm attaching two screenshots where you can see clearly what I mean and also a .txt file with two queries so you can easily create yourself and insert some data.
I'm using the newest JS Stimulsoft client.
Hope to hear from you soon!
Best wishes,
Michal Choldrych
I've connected to postgresql database directly and for schema "public" I can retrieve all the columns. But when I click on "preview" (I do not have to put even any data on the report template) there is an error that sort of "relation" does not exists.
I'm attaching two screenshots where you can see clearly what I mean and also a .txt file with two queries so you can easily create yourself and insert some data.
I'm using the newest JS Stimulsoft client.
Hope to hear from you soon!
Best wishes,
Michal Choldrych
- Attachments
-
- query.txt
- (3.09 KiB) Downloaded 191 times
-
- Screenshot_180.png (12.41 KiB) Viewed 6702 times
-
- Screenshot_179.png (73.88 KiB) Viewed 6702 times
Re: No possibility to create a report based on postgresql
Hi Michal,
Thank you for the bug report, do you mind to send us a sample JS test, that reproduces the issue, so we could help in fixing the problem or to provide a required fix.
Sorry about that, but that would be of a great help.
Thank you very much,
Edward
3153380
Thank you for the bug report, do you mind to send us a sample JS test, that reproduces the issue, so we could help in fixing the problem or to provide a required fix.
Sorry about that, but that would be of a great help.
Thank you very much,
Edward
3153380
Re: No possibility to create a report based on postgresql
Hi Edward,
The issue is Independent from the Designer version used. I can reproduce same with WPF Designer.
Attached is a sample report.
Best regards
Vitaly
The issue is Independent from the Designer version used. I can reproduce same with WPF Designer.
Attached is a sample report.
Best regards
Vitaly
- Attachments
-
- PostgresReport.mrt
- PostgresReport
- (8.08 KiB) Downloaded 212 times
Re: No possibility to create a report based on postgresql
Hi Vitaly,
Thank you for the sample report and your comment. We will update you in this topic and will reply to your email request as well once the solution for the problem is found.
The workaround has been explained here for now:
viewtopic.php?f=8&t=56192
Thank you,
Edward
Thank you for the sample report and your comment. We will update you in this topic and will reply to your email request as well once the solution for the problem is found.
The workaround has been explained here for now:
viewtopic.php?f=8&t=56192
Thank you,
Edward
Re: No possibility to create a report based on postgresql
Hi Edward,
There is no workaround on the topic you mentioned. That topic mentions databases other than public.
This one says that even with pubic it does not work
Best regards
Vitaly
There is no workaround on the topic you mentioned. That topic mentions databases other than public.
This one says that even with pubic it does not work
Best regards
Vitaly
Re: No possibility to create a report based on postgresql
Hi Vitaly,
Yes, you are correct, that is a slightly different issue, true. Are you using the latest PostGreSql 10.4 and Windows 10 x64? I have done a quick test with that database. With the schema that was mentioned in the above topic.
The report was rendered without any issue. Please check my report attached. I think I need to kindly request the db script to create the database schema that you used for the test you explained and kindly provided the mrt report for us.
Thank you,
Edward
Yes, you are correct, that is a slightly different issue, true. Are you using the latest PostGreSql 10.4 and Windows 10 x64? I have done a quick test with that database. With the schema that was mentioned in the above topic.
The report was rendered without any issue. Please check my report attached. I think I need to kindly request the db script to create the database schema that you used for the test you explained and kindly provided the mrt report for us.
Thank you,
Edward
Re: No possibility to create a report based on postgresql
Hi Edward,
The designer runs on Windows 10 x64.
The DB is PostgreSQL 9.6.5 on x86_64-pc-linux-gnu (running within docker)
Another interesting observation, the connection string in the report you sent contains
Below is a table creation script used for this tests (on the default schema public)
The report itself is attached to a previous post
The designer runs on Windows 10 x64.
The DB is PostgreSQL 9.6.5 on x86_64-pc-linux-gnu (running within docker)
Another interesting observation, the connection string in the report you sent contains
wich is not recognized in my environment. The data adapter has been automatically downloaded by the designer (Npgsql 2.2.7.0).Min Pool Size=0
Below is a table creation script used for this tests (on the default schema public)
Code: Select all
CREATE TABLE public."Reservation"
(
"Id" uuid NOT NULL,
"TenantId" uuid NOT NULL,
"PropertyId" uuid NOT NULL,
"Arrival" date,
"Departure" date,
"Adults" integer,
"Children" integer,
"FirstName" text,
"LastName" text,
"Title" text,
"ReservationStatus" text,
"VIP" text,
"Notes" text,
"RoutingInstructions" text,
"PurchaseElements" text,
"InventoryStatus" text,
CONSTRAINT "PK_Reservation" PRIMARY KEY ("Id")
)
WITH (
OIDS=FALSE
);
ALTER TABLE public."Reservation"
OWNER TO postgres;
-- Index: public."idx_Arrival"
-- DROP INDEX public."idx_Arrival";
CREATE INDEX "idx_Arrival"
ON public."Reservation"
USING btree
("PropertyId", "Arrival");
-
- Posts: 6263
- Joined: Tue Mar 20, 2018 5:34 am
Re: No possibility to create a report based on postgresql
Hello,
Please try to use the following query:
Thank you.
Please try to use the following query:
Code: Select all
select * from public."Reservation"
Re: No possibility to create a report based on postgresql
Hello Lech,
yes, this is correct. This query works. However the query has not been written manually but generated automatically by Stimulsoft designer while selecting the available tables. End user has no idea and knowledge that they need to modify query. Also in our environment they won't know anything about existing schemas
Thanks
Vitaly
yes, this is correct. This query works. However the query has not been written manually but generated automatically by Stimulsoft designer while selecting the available tables. End user has no idea and knowledge that they need to modify query. Also in our environment they won't know anything about existing schemas
Thanks
Vitaly
-
- Posts: 6263
- Joined: Tue Mar 20, 2018 5:34 am
Re: No possibility to create a report based on postgresql
Hello Vitaly,
We have added this task to our to-do list.
Thank you.
We have added this task to our to-do list.
Thank you.