Hi guys
when I try to modify a report, I got a message pop up:Report is locked by other user, bu I am sure I am the only one who use this report, I think I accidently lock the report, so how can I unlock the report?
Thanks in advance
Regards Billy

You can go to application locks and look for your login and remove the record(thats what is locked).

This has been already discussed many times , Kindly search the Form before posting.

hi ,
use ttstpdellocks session for unlocking ...

Newbie here for Baan,

Trying to learn my way around the system and Ive been able to create a package, session, etc and now Im working on a report. Well I started with input fields, editing scripts, etc. Went to lunch and came back, look liked Baan timed out or crashed, so I restarted. Now when I try to go to the Maintain report and edit script or anything for that matter, i get the "Report is locked by other user!!". Where in the system can I see whats locked and how can I unlock it? Might be a stupid question but Im on day 3 with Baan and I have NO idea how to unlock myself.

Thanks

Josh

Newbie here for Baan,

Trying to learn my way around the system and Ive been able to create a package, session, etc and now Im working on a report. Well I started with input fields, editing scripts, etc. Went to lunch and came back, look liked Baan timed out or crashed, so I restarted. Now when I try to go to the Maintain report and edit script or anything for that matter, i get the "Report is locked by other user!!". Where in the system can I see whats locked and how can I unlock it? Might be a stupid question but Im on day 3 with Baan and I have NO idea how to unlock myself.

Thanks

Josh

Hello,
release the application lock with session ttstpdellocks.
Navigate Tools -> Database Managment -> Misc. -> Applicationlock

Regards

OK I just figured that out, Baan Tools> DB Management> MISC> Remove App Locks > then you can unlock your own.

Ok I was able to unlock myself. It appears that when my PC goe to sleep mode it triggers an error in the app and I have to restart itself thus the error. Baan doesnt like to "sleep" like Win 7 does. Ha!

Ok one additional question, sorry if its stupid, ike I said new to Baan here, I want to create a report based off some table in the system. is this the correct way to do it?

Baan Tools> App Dev > Maintain Reports> INSERT>

Ok I was able to unlock myself. It appears that when my PC goe to sleep mode it triggers an error in the app and I have to restart itself thus the error. Baan doesnt like to "sleep" like Win 7 does. Ha!

Ok one additional question, sorry if its stupid, ike I said new to Baan here, I want to create a report based off some table in the system. is this the correct way to do it?

Baan Tools> App Dev > Maintain Reports> INSERT>

Hello,
this way is possible but,
later you have to link this report to a print session based on the main table.
You can't be sure, that all inputfields of the report are supplied by the printsession.

I think it's easier to locate an existing report which fulfills the requirement to > 80% and copy this report to a new one.
Afterwards modify the copied report as you want.

Regards

Hmmmm interesting insight. Baan seems to be straight forward, its just learning the navgation and seeing how it all ties into each other.

Ill try to copy an exsiting report and then modify the input fields, layout etc to see if this is going to work. Ive heard from someone here that I can perform MS SQL queries on data in the Baan system. So far Ive been able to conect to Baan using SQL MGT Studio but it looks like theres a pile of tables in there and I wouldnt know where to start when looking at data in a Baan table.

So far this site has been insightful and VERY useful.

Hmmmm interesting insight. Baan seems to be straight forward, its just learning the navgation and seeing how it all ties into each other.

Ill try to copy an exsiting report and then modify the input fields, layout etc to see if this is going to work. Ive heard from someone here that I can perform MS SQL queries on data in the Baan system. So far Ive been able to conect to Baan using SQL MGT Studio but it looks like theres a pile of tables in there and I wouldnt know where to start when looking at data in a Baan table.

So far this site has been insightful and VERY useful.

Hello GabrielVA,
never use other tools for data manipulation.
Only use the BaaN application logic.
Simple queries can be done by using BaaN easy SQL in the tools section.

Regards

Ok thanks! Glad im just in a learning process here and using a dev env also. I really appreicate all your help here so far. Im sure Ill post most questions on here as I learn my way abour Baan.

GabrielVA