Page 1 of 1

Report does not appear in the menu (v2022)

Posted: Fri Dec 09, 2022 1:20 am
by deco10

Hello,
I created a View with a relationship between two tables to create a Crosstab Report.
I enabled it in the Security Settings, I enabled it in the menu and in the code generation, but neither the View nor the Crosstab Report are appearing in the menu.
My Phpmaker is v 2022.12.4.
Can you help me?


Re: the report does not appear in the menu

Posted: Fri Dec 09, 2022 8:34 am
by mobhar

You may post your tables schema (CREATE TABLE ...) and database view schema (CREATE VIEW ...) including some records example (INSERT INTO ...), so others could try.


Re: Report does not appear in the menu (v2022)

Posted: Fri Dec 09, 2022 9:09 am
by arbei
  1. You might have created the view by another database user so it cannot be accessed by the database user specified in the project.
  2. You might have connected to the wrong database.