Report does not appear in the menu (v2022)

deco10 · Post by **deco10** » Fri Dec 09, 2022 1:20 am

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?

mobhar · Post by **mobhar** » Fri Dec 09, 2022 8:34 am

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

arbei · Post by **arbei** » Fri Dec 09, 2022 9:09 am

You might have created the view by another database user so it cannot be accessed by the database user specified in the project.
You might have connected to the wrong database.