I beleive the only way to bypass the login is to modify the registry. Here is what 5947MPS says:
PROBLEM: Bypass the login ID and prompt for a Crystal Report using an ODBC connection.
A Crystal form that has been modified with a subreport written using an ODBC connection continues to prompt for the ODBC System DSN login ID and password parameters.
The ODBC Driver for Open Edge 10.0B must be installed on each client that will be using an ODBC modified report. See document 4778MPS for instructions on modifying a Crystal Report to use ODBC.
For V8.03, an ODBC driver is not necessary for a customer Crystal Report. See document 7905MPS for instructions on creating a Crystal Report from a BAQ within V8.03.
RESOLUTION:
1. Go to Start->Run, and type in REGEDIT.
2. This will bring up your Registry Editor.
3. Find the HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI.
4. Find your specific ODBC connection that is setup in your ODBC datasources and double-click on it.
5. Go up to the Edit -> New -> String Value in the menu.
6. Give your New String Value the name of User ID.
7. Then double-click and give it a value of sysprogress. (Or whatever your user id is setup to be.)
8. Repeat the process for your Password.
9. Exit the Registry.
10. In the SystemTaskAgent (System Management->Utilities->System Agent), under ODBC Connection, put in the User ID and Password above.
11. In the Progress Explorer Tool, stop and start the TaskAgent and ProcessServer for this database.
12. Test your report and you should not get prompted.
________________________________
From: Tiffany McDonald <tmcdonald@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Wednesday, November 26, 2008 10:43:32 AM
Subject: RE: [Vantage] Re: Custom Crystal Reports in Vantage 6.1
I was under the impression it was impossible to attach a CR to the menu. I have now successfully attached a report to the Vantage menu; however, it prompts the user for the ODBC username and password. Is there any way to bypass this or save the information in the compiled .exe?
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of Gary Parfrey
Sent: Sunday, November 23, 2008 7:59 AM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] Re: Custom Crystal Reports in Vantage 6.1
You can run the exe crystal reports from the Vantage 6. 1 menu, by using
the following Progress script (example). Place the script in the UD
directory as a .W file. Modify the menu maintenance to call it.
/* Call Windows program using WinExec */
DEFINE VARIABLE ProgNamePath as CHARACTER NO-UNDO.
DEFINE VARIABLE ReturnCode AS INTEGER NO-UNDO.
PROCEDURE WinExec EXTERNAL "KERNEL32.DLL" :
DEFINE INPUT PARAMETER ProgramName AS CHARACTER.
DEFINE INPUT PARAMETER VisualStyle AS LONG.
DEFINE RETURN PARAMETER StatusCode AS LONG.
END PROCEDURE.
/*********** ********* ********* ********* ********* ********* ********* ****
****
Set the ProgNamePath variable value to the location\Crystal
Report's .EXE The Crystal Report must be compiled into an .EXE !!
************ ********* ********* ********* ********* ********* ********* ****
****/
ProgNamePath = "v:\REPORTS\ cr\CREM0001. exe".
RUN WinExec (INPUT ProgNamePath, INPUT 1, OUTPUT ReturnCode).
Gary
From: vantage@yahoogroups .com<mailto:vantage% 40yahoogroups. com> [mailto:vantage@yahoogroups .com<mailto:vantage% 40yahoogroups. com>] On Behalf
Of Todd Caughey
Sent: 22 November 2008 21:48
To: vantage@yahoogroups .com<mailto:vantage% 40yahoogroups. com>
Subject: RE: [Vantage] Re: Custom Crystal Reports in Vantage 6.1
In Crystal 8.5 there is an add-in that can be downloaded from the Epicor
FTP site that will assemble a report into a distributalbe .exe program
that will install the report and all require DLL files. This was a
standard feature in CR 8.0 that went away but they relented and made it
an add-in option. You can either run self contained reports that pick up
data via ODBC or make use of the DBF files created by Vantage for the
canned Crystal reports (mostly forms like Invoice or Job Traveler). The
downside of the DBF files is you only get those fields deemed necessary
for the report created by Epicor.
The add-in distribution wizard does not work with Crystal XI. And as
stated earlier I don't think Crystal XI plays nice with Vantage 6.10
either.
There is a facility in 6.10 for linking Report Builder reports into the
Vantage menu structure but this does not work for Crystal Reports. The
only way I've been able to run CR reports from Vantage has been by
adding them to the Favorites bar on the left side of the Vantage
screen...where you can run pretty much any Windows app. Not saying it is
not possible at all to add to the menu tree..it might be with some
Progress code routines.... just that I have not heard of it being
successful.
Todd C.
____________ _________ _________ __
From: vantage@yahoogroups .com<mailto:vantage% 40yahoogroups. com> <mailto:vantage% 40yahoogroups. com>
[vantage@yahoogroups .com<mailto:vantage% 40yahoogroups. com> <mailto:vantage% 40yahoogroups. com> ] On Behalf
Of joefromvt [joefromvt@yahoo. com<mailto:joefromvt% 40yahoo.com> <mailto:joefromvt% 40yahoo.com> ]
Sent: Saturday, November 22, 2008 2:30 PM
To: vantage@yahoogroups .com<mailto:vantage% 40yahoogroups. com> <mailto:vantage% 40yahoogroups. com>
Subject: [Vantage] Re: Custom Crystal Reports in Vantage 6.1
Todd,
Thanks for the response.
If I compiled/distribute d the reports, that would mean I would pull
the data, compile/distribute the report, and then post it to Vantage,
correct?
Ultimately what I want to do is make the reports available to users
via Vantage so that they can run them and the report would pull the
data requested by the report again.
Does this make more sense? I've been told by my manager that they
have done this before, but of course no one remembers how. :-|
Thanks again,
Joe
--- In vantage@yahoogroups .com<mailto:vantage% 40yahoogroups. com> <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com>, Todd Caughey <caugheyt@.. .> wrote:
recall anyone explicitly saying they succeeded. Also XI does not
have a distribution wizard like Crystal 8.0/8.5 so that could make it
more difficult yet.
<mailto:vantage% 40yahoogroups. com> <mailto:vantage% 40yahoogroups. com>]
On Behalf
Of joefromvt [joefromvt@. ..]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
PROBLEM: Bypass the login ID and prompt for a Crystal Report using an ODBC connection.
A Crystal form that has been modified with a subreport written using an ODBC connection continues to prompt for the ODBC System DSN login ID and password parameters.
The ODBC Driver for Open Edge 10.0B must be installed on each client that will be using an ODBC modified report. See document 4778MPS for instructions on modifying a Crystal Report to use ODBC.
For V8.03, an ODBC driver is not necessary for a customer Crystal Report. See document 7905MPS for instructions on creating a Crystal Report from a BAQ within V8.03.
RESOLUTION:
1. Go to Start->Run, and type in REGEDIT.
2. This will bring up your Registry Editor.
3. Find the HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI.
4. Find your specific ODBC connection that is setup in your ODBC datasources and double-click on it.
5. Go up to the Edit -> New -> String Value in the menu.
6. Give your New String Value the name of User ID.
7. Then double-click and give it a value of sysprogress. (Or whatever your user id is setup to be.)
8. Repeat the process for your Password.
9. Exit the Registry.
10. In the SystemTaskAgent (System Management->Utilities->System Agent), under ODBC Connection, put in the User ID and Password above.
11. In the Progress Explorer Tool, stop and start the TaskAgent and ProcessServer for this database.
12. Test your report and you should not get prompted.
________________________________
From: Tiffany McDonald <tmcdonald@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Wednesday, November 26, 2008 10:43:32 AM
Subject: RE: [Vantage] Re: Custom Crystal Reports in Vantage 6.1
I was under the impression it was impossible to attach a CR to the menu. I have now successfully attached a report to the Vantage menu; however, it prompts the user for the ODBC username and password. Is there any way to bypass this or save the information in the compiled .exe?
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of Gary Parfrey
Sent: Sunday, November 23, 2008 7:59 AM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] Re: Custom Crystal Reports in Vantage 6.1
You can run the exe crystal reports from the Vantage 6. 1 menu, by using
the following Progress script (example). Place the script in the UD
directory as a .W file. Modify the menu maintenance to call it.
/* Call Windows program using WinExec */
DEFINE VARIABLE ProgNamePath as CHARACTER NO-UNDO.
DEFINE VARIABLE ReturnCode AS INTEGER NO-UNDO.
PROCEDURE WinExec EXTERNAL "KERNEL32.DLL" :
DEFINE INPUT PARAMETER ProgramName AS CHARACTER.
DEFINE INPUT PARAMETER VisualStyle AS LONG.
DEFINE RETURN PARAMETER StatusCode AS LONG.
END PROCEDURE.
/*********** ********* ********* ********* ********* ********* ********* ****
****
Set the ProgNamePath variable value to the location\Crystal
Report's .EXE The Crystal Report must be compiled into an .EXE !!
************ ********* ********* ********* ********* ********* ********* ****
****/
ProgNamePath = "v:\REPORTS\ cr\CREM0001. exe".
RUN WinExec (INPUT ProgNamePath, INPUT 1, OUTPUT ReturnCode).
Gary
From: vantage@yahoogroups .com<mailto:vantage% 40yahoogroups. com> [mailto:vantage@yahoogroups .com<mailto:vantage% 40yahoogroups. com>] On Behalf
Of Todd Caughey
Sent: 22 November 2008 21:48
To: vantage@yahoogroups .com<mailto:vantage% 40yahoogroups. com>
Subject: RE: [Vantage] Re: Custom Crystal Reports in Vantage 6.1
In Crystal 8.5 there is an add-in that can be downloaded from the Epicor
FTP site that will assemble a report into a distributalbe .exe program
that will install the report and all require DLL files. This was a
standard feature in CR 8.0 that went away but they relented and made it
an add-in option. You can either run self contained reports that pick up
data via ODBC or make use of the DBF files created by Vantage for the
canned Crystal reports (mostly forms like Invoice or Job Traveler). The
downside of the DBF files is you only get those fields deemed necessary
for the report created by Epicor.
The add-in distribution wizard does not work with Crystal XI. And as
stated earlier I don't think Crystal XI plays nice with Vantage 6.10
either.
There is a facility in 6.10 for linking Report Builder reports into the
Vantage menu structure but this does not work for Crystal Reports. The
only way I've been able to run CR reports from Vantage has been by
adding them to the Favorites bar on the left side of the Vantage
screen...where you can run pretty much any Windows app. Not saying it is
not possible at all to add to the menu tree..it might be with some
Progress code routines.... just that I have not heard of it being
successful.
Todd C.
____________ _________ _________ __
From: vantage@yahoogroups .com<mailto:vantage% 40yahoogroups. com> <mailto:vantage% 40yahoogroups. com>
[vantage@yahoogroups .com<mailto:vantage% 40yahoogroups. com> <mailto:vantage% 40yahoogroups. com> ] On Behalf
Of joefromvt [joefromvt@yahoo. com<mailto:joefromvt% 40yahoo.com> <mailto:joefromvt% 40yahoo.com> ]
Sent: Saturday, November 22, 2008 2:30 PM
To: vantage@yahoogroups .com<mailto:vantage% 40yahoogroups. com> <mailto:vantage% 40yahoogroups. com>
Subject: [Vantage] Re: Custom Crystal Reports in Vantage 6.1
Todd,
Thanks for the response.
If I compiled/distribute d the reports, that would mean I would pull
the data, compile/distribute the report, and then post it to Vantage,
correct?
Ultimately what I want to do is make the reports available to users
via Vantage so that they can run them and the report would pull the
data requested by the report again.
Does this make more sense? I've been told by my manager that they
have done this before, but of course no one remembers how. :-|
Thanks again,
Joe
--- In vantage@yahoogroups .com<mailto:vantage% 40yahoogroups. com> <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com>, Todd Caughey <caugheyt@.. .> wrote:
>Vantage 6.10 is via the Favorites bar for each user.
> The only way I've put Compiled (Distributed) Crystal reports in
>DLLs are different. I've read of attempts to make it work but don't
> Also. XI is not compatible with 6.10's runtime environment. The
recall anyone explicitly saying they succeeded. Also XI does not
have a distribution wizard like Crystal 8.0/8.5 so that could make it
more difficult yet.
><mailto:vantage% 40yahoogroups. com> [vantage@yahoogroups .com<mailto:vantage% 40yahoogroups. com>
> -Todd C.
>
> ____________ _________ _________ __
> From: vantage@yahoogroups .com<mailto:vantage% 40yahoogroups. com> <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com> <mailto:vantage% 40yahoogroups. com>]
On Behalf
Of joefromvt [joefromvt@. ..]
> Sent: Saturday, November 22, 2008 12:44 PM<mailto:vantage% 40yahoogroups. com>
> To: vantage@yahoogroups .com<mailto:vantage% 40yahoogroups. com> <mailto:vantage% 40yahoogroups. com>
> Subject: [Vantage] Custom Crystal Reports in Vantage 6.1Vantage
>
>
> Hello Fellow Vantage Users,
>
> I have started creating some Crystal Reports in Crystal XI, and my
> manager wants me to put them in Vantage so that other users in
> can run them as well. Does anyone have instructions on how to do[Non-text portions of this message have been removed]
> this? I've searched through the help menu's as much as I can, and
> can't seem to find anything.
>
> Thanks,
>
> Joe
>
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]