When calling a report with command line parameters you have to pass the password. How can you make the call generic without knowing all passwords?

I am sure there is something simple that I am missing here ..

dsig

David Tod Sigafoos ~ SigSolutions

[email protected]

David -

Reporter requires the password parameter if the user printing the report has a password specified.

-Chris

Revelation

Hi Dave,

I have 2 ways of doing that:

1. Call Reporter with a generic (pre-defined) user name:

REPORTER.EXE /AP=XXX /UN=GENERIC_USER …

This obviously works even though each user logs into OpenInsight with a user name other than GENERIC_USER .

In my app however, everybody logs in as the same OI user name, and then my own security kicks in and asks for internal user names and passwords. Therefore, I use the same generic name at all times for everything.

2. This is more cumbersome, but it allows you access to the password.

Use line=Repository( "EXECUTE" , "APPNAME*OIREPORT*RDLAYOUT*REPORTNAME",…)

This returns the complete syntax that you need to use with the Utility function (including /PW=xxx)

I haven't used this second approach in a while (since OI3.4) but it used to work OK.

Hope that's what you're looking for

Dave Pociu

"Almost as nice a guy as Don Bakke "

Since I did not seem to get the question accross the first time let's try this ..

Since reporter requires a password IF the user has a password, how can I launch a report from an entry screen in a generic manor. I don't want to hard code the password into the program and I do not want to ask the user every time the want to print a generic report.

IS THERE A WAY to get the users password from the system and pass it on to reporter?

Sorry about the confusion in my original post …

dsig

David Tod Sigafoos ~ SigSolutions

[email protected]

BINGO!!

I like suggestion 1 (the users will never know that GENERIC_USER exists .. and it gives me a back door in case they nuke the app password . Not sure about suggestion 2 .. might try later for knowledge ..

thanks

ps .. who says you aren't a nice guy .. heck you even give code samples ..

dsig

David Tod Sigafoos ~ SigSolutions

[email protected]

I'm just continuing where Don left off with "Not a world leader in anything, just a nice guy"

View this thread on the forum...