Hello all,

I need your help on the following:

I want to print a list with the menu structure, and then a mark for the authorised sessions for a certain user.

It should work like this: I enter a user, the start menu from that user is read and the menu structure for that start menu is printed. There is a check in table ttaad231 (session authorisations) whether the user is authorised for the session printed. If yes, the printed line is marked.

I have no user authorisations by module, so all permitted sessions are found in ttaad231.

How can I set up such report? I have the development kit, so I can generate new sessions, if necessary.

Thanks for all your help.

Hello,

Generate a new print session on a standard table (by ex. tccom001).

When he session is generated go to maintain script and change all sql stuf to use the tools table that you need. Modify your report to print the tools fields.

You are not allowed to use the tools table for the generation of the session ==> message "no integration with package tt" :cool:

Hi,

I already created a new session that prints all menu's with permitted sessions per user, but I want only the menu's to be printed that are visible for this user. Only the menu's in the menu structure from the user's startmenu should be printed.

I was thinking of printing the menu structure to an ascii file and importing only the lines starting with "Session: " into a selfmade baan table. Maybe someone can help me on that?

Ronald

I succeeded in making the list as I want it, I did it as follows:

1. Print menu structure to an ascii file
2. Create a new session with next steps in the script:
- open ascii file
- read ascii file
- filter lines starting with "Session: "
- get session
- look in ttaad231 for the user and that session
- print record