Chawada
asked on
ORACLE FORM DESIGNER
I have designed a form,attached a menu to it and created the .fmx and .mmx files.
On running the form, clicking the items on the menu does not execute the commands associated with those menu items.
Anything wrong?
On running the form, clicking the items on the menu does not execute the commands associated with those menu items.
Anything wrong?
ASKER
Clicking the menu items is supposed to open the report parameter screens.At the moment nothing happens but when i view the Reports Background engine , Actions: Show Log,I get these messages "REP -0002: Unable to retrieve a string from the Report Builder Message File. REP-1439: End of report <Report Name>"
ASKER
I am using Developer 2000 R2.1 Forms 5.0.
When using Developer 2000 R1.6 Forms Forms 4.5, I never encounter this problem.
When using Developer 2000 R1.6 Forms Forms 4.5, I never encounter this problem.
Is this an application that you upgraded from Forms4.5 to 5.0 (and Reports 2.0 to Reports2.5)? There are a couple of syntax differences in the way Reports is called from Forms between those versions. It has been a couple of years since I was involved in upgrading those versions, but I think the problem is the command string you are passing to run the report. I think there are different or additional parameters required - check the documentation for Reports.
I presume you have already recompiled all your forms and reports to get it working in Dev 2.1?
The message has to do with report not being compiled properly. If still getting the message, recompile the report again and check. It should work.
The message has to do with report not being compiled properly. If still getting the message, recompile the report again and check. It should work.
ASKER
Thanks Markgeer and M-Ali but the problem has not been solved yet.
The application was developed using Forms 5.0 and reports 2.5.
I think this is something to do with Menu security and maybe Roles because what i noticed yesterday is that if I am the one logged in to the database, the application runs perfectly and opens the report parameter screens as expected but for other users it brings up that error message.
I gave the users permissions (same as mine!) to all the tables that the query refers to but I still have that error message "REP -0002: Unable to retrieve a string from the Report Builder Message File. REP-1439: End of report <Report Name>"
Anyone understands how the Menu Security and Rolesfor Forms 5.0 works because it seems to be completely different from Forms 4.5.
Note: The Use Security from the Menu Properties has been set to NO and the Display without Privilege from the individual menu properties's Menu Security has been set to YES.
Thanks in advance!!
The application was developed using Forms 5.0 and reports 2.5.
I think this is something to do with Menu security and maybe Roles because what i noticed yesterday is that if I am the one logged in to the database, the application runs perfectly and opens the report parameter screens as expected but for other users it brings up that error message.
I gave the users permissions (same as mine!) to all the tables that the query refers to but I still have that error message "REP -0002: Unable to retrieve a string from the Report Builder Message File. REP-1439: End of report <Report Name>"
Anyone understands how the Menu Security and Rolesfor Forms 5.0 works because it seems to be completely different from Forms 4.5.
Note: The Use Security from the Menu Properties has been set to NO and the Display without Privilege from the individual menu properties's Menu Security has been set to YES.
Thanks in advance!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
M-Ali,
Thanks!
That was nothing to do with menu security and roles completely(although all the time I was thinking along those lines). Running the reports straight from the Reports Runtime gave me the same error message.
I recompiled the reports and updated the regedit to make sure that the reports runtime files are in the correct directory and that was it!!!!!
Thanks!
That was nothing to do with menu security and roles completely(although all the time I was thinking along those lines). Running the reports straight from the Reports Runtime gave me the same error message.
I recompiled the reports and updated the regedit to make sure that the reports runtime files are in the correct directory and that was it!!!!!
Have you tried running the form with the default menu? Does that work as it should?