Confusion about adding Crystal reports directly into Vantage

Thank for Michelle sharing. I posted our procedures in "Progress Code"
folder.
My colleague can call crystal report 8.5(exe or rpt) in 4GL, but they
only know how to pass parameters with Ctrl+V and DBF. Do you know other
ways?

--- In vantage@yahoogroups.com, "Michelle de la Vega" <mdelavega@...>
wrote:
>
> I have added my procedures to the yahoo group. It is called Crystal
> Report in Vantage 6.1.
In Vantage it seems you can add Report Builder reports directly into
the application so even those without Report Builder installed can run
them. I cannot find a way to do this with reports created in Crystal.
Does anyone have expierence with this? I'd like to write several custom
reports in Crystal but allow users to simply run them directly from
Vantage without Crystal installed on their client at all. Any help
would be appreciated.
--- In vantage@yahoogroups.com, "Josh Holman" <jholman@...> wrote:
>
> In Vantage it seems you can add Report Builder reports directly into
> the application so even those without Report Builder installed can
run
> them. I cannot find a way to do this with reports created in Crystal.
> Does anyone have expierence with this? I'd like to write several
custom
> reports in Crystal but allow users to simply run them directly from
> Vantage without Crystal installed on their client at all. Any help
> would be appreciated.
>
Should have added It's Vantage 6.1
Josh -

When I was working with another firm, Technical Services, Inc. in Ames, Iowa, I purchased a report viewer & scheduler, that you can set up to schedule reports to run & email to others, and/or purchase to allow them to run reports on their PC without full crystal. It does require a program to run, but more inexpensive option than crystal for everyone, and can be preset up with specific reports by you, to limit access to all reports.

http://www.easystreetsoftware.net/Products/EasyView_Main.php

From $35, and as low as $29 per license in multiple qtys. I know I used one license primarily, and scheduled most standard reports.

- Becky Venneman, CMA, SPHR
Virtual Bizniz
info@...
becky.venneman@...

----- Original Message -----
From: Josh Holman
To: vantage@yahoogroups.com
Sent: Thursday, September 14, 2006 8:11 PM
Subject: [Vantage] Re: Confusion about adding Crystal reports directly into Vantage.


--- In vantage@yahoogroups.com, "Josh Holman" <jholman@...> wrote:
>
> In Vantage it seems you can add Report Builder reports directly into
> the application so even those without Report Builder installed can
run
> them. I cannot find a way to do this with reports created in Crystal.
> Does anyone have expierence with this? I'd like to write several
custom
> reports in Crystal but allow users to simply run them directly from
> Vantage without Crystal installed on their client at all. Any help
> would be appreciated.
>
Should have added It's Vantage 6.1





[Non-text portions of this message have been removed]
Josh, this answer is straight off the answer book from Epicor. I haven't
got round to using it yet, but plan to down the track. The problem I had
was creating the compiled report ( the crystal .exe file) from memory. I
am sure this is what you are after though.



Cheers

Stuart



AnswerBook Details

AnswerBook #:

2056MPS

Product:

Vantage

Date Added:

3/20/2002

Version:



Date Changed:

3/29/2004

Module:

Crystal Reports

_____

Summary:

How to add a compiled Crystal Report as a Vista\Vantage menu option.

Details:

Page ID 2056MPS

How to add a compiled Crystal Report as a Vista\Vantage menu option.

The following procedure will allow you to call a compiled Crystal Report
(.EXE) from a Vista\Vantage menu option. This will allow you to use
Vista\Vantage menu security to control user access to these reports.

Step #1: Create a Progress program (.W) file to call the Crystal Report
.EXE.

This program (.W) file would contain the following code:
============================================================

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
***********************************************************************/

ProgNamePath = "W:\Vantage\UD\Scrap By Reason Detail.exe".
* Note - Depending on version of program the application directory could
also be mfgsys60 or mfgsys61

RUN WinExec (INPUT ProgNamePath, INPUT 1, OUTPUT ReturnCode).


=====================================================================
The example above shows how a "Scrap By Reason Detail.Exe" would be
called. Include the full path to the compile report .exe.

Save this file as UD<Compile ReportName>.W and eliminate the spaces.

For example: Scrap By Reason Detail.exe "save as"
UDScrapByReasonDetail.w



Step #2: Copy the UD<Compile ReportName>.W file to the \Vantage\UD or
mfgsys60\UD or mfgsys61\UD folder.

Step #3: Use Vista\Vantage Menu Structure Maintenance to add a new menu
option to call the UD<Compile ReportName>.W

Note: Menu ID must start with UD. Any naming convention for the
remaining characters can be used.

Program must always include UD/UD<Compile Report Name>.W





-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Josh Holman
Sent: Friday, 15 September 2006 10:27 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Confusion about adding Crystal reports directly into
Vantage.



In Vantage it seems you can add Report Builder reports directly into
the application so even those without Report Builder installed can run
them. I cannot find a way to do this with reports created in Crystal.
Does anyone have expierence with this? I'd like to write several custom
reports in Crystal but allow users to simply run them directly from
Vantage without Crystal installed on their client at all. Any help
would be appreciated.





[Non-text portions of this message have been removed]
Josh,



Epicor's procedures are lacking some information, I'll email you my
procedures that I have written.



Good Luck,





<http://www.coldjet.com>

Michelle de la Vega

Business Applications Manager

Cold Jet, LLC

455 Wards Corner Road

Loveland, Ohio 45140

513-716-6400

513-831-1209 FAX

Celebrating 20 Years of Dry Ice Technology and Innovation

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Stuart Noble
Sent: Thursday, September 14, 2006 11:10 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Confusion about adding Crystal reports directly
into Vantage.



Josh, this answer is straight off the answer book from Epicor. I haven't
got round to using it yet, but plan to down the track. The problem I had
was creating the compiled report ( the crystal .exe file) from memory. I
am sure this is what you are after though.

Cheers

Stuart

AnswerBook Details

AnswerBook #:

2056MPS

Product:

Vantage

Date Added:

3/20/2002

Version:

Date Changed:

3/29/2004

Module:

Crystal Reports

_____

Summary:

How to add a compiled Crystal Report as a Vista\Vantage menu option.

Details:

Page ID 2056MPS

How to add a compiled Crystal Report as a Vista\Vantage menu option.

The following procedure will allow you to call a compiled Crystal Report
(.EXE) from a Vista\Vantage menu option. This will allow you to use
Vista\Vantage menu security to control user access to these reports.

Step #1: Create a Progress program (.W) file to call the Crystal Report
.EXE.

This program (.W) file would contain the following code:
============================================================

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
***********************************************************************/

ProgNamePath = "W:\Vantage\UD\Scrap By Reason Detail.exe".
* Note - Depending on version of program the application directory could
also be mfgsys60 or mfgsys61

RUN WinExec (INPUT ProgNamePath, INPUT 1, OUTPUT ReturnCode).

=====================================================================
The example above shows how a "Scrap By Reason Detail.Exe" would be
called. Include the full path to the compile report .exe.

Save this file as UD<Compile ReportName>.W and eliminate the spaces.

For example: Scrap By Reason Detail.exe "save as"
UDScrapByReasonDetail.w

Step #2: Copy the UD<Compile ReportName>.W file to the \Vantage\UD or
mfgsys60\UD or mfgsys61\UD folder.

Step #3: Use Vista\Vantage Menu Structure Maintenance to add a new menu
option to call the UD<Compile ReportName>.W

Note: Menu ID must start with UD. Any naming convention for the
remaining characters can be used.

Program must always include UD/UD<Compile Report Name>.W

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Josh Holman
Sent: Friday, 15 September 2006 10:27 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Confusion about adding Crystal reports directly into
Vantage.

In Vantage it seems you can add Report Builder reports directly into
the application so even those without Report Builder installed can run
them. I cannot find a way to do this with reports created in Crystal.
Does anyone have expierence with this? I'd like to write several custom
reports in Crystal but allow users to simply run them directly from
Vantage without Crystal installed on their client at all. Any help
would be appreciated.

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
I would be interested in seeing your procedures as well. Could you post them here?

Thanks,
Kelly Potratz

Michelle de la Vega <mdelavega@...> wrote:
Josh,

Epicor's procedures are lacking some information, I'll email you my
procedures that I have written.

Good Luck,

<http://www.coldjet.com>

Michelle de la Vega

Business Applications Manager

Cold Jet, LLC

455 Wards Corner Road

Loveland, Ohio 45140

513-716-6400

513-831-1209 FAX

Celebrating 20 Years of Dry Ice Technology and Innovation

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Stuart Noble
Sent: Thursday, September 14, 2006 11:10 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Confusion about adding Crystal reports directly
into Vantage.

Josh, this answer is straight off the answer book from Epicor. I haven't
got round to using it yet, but plan to down the track. The problem I had
was creating the compiled report ( the crystal .exe file) from memory. I
am sure this is what you are after though.

Cheers

Stuart

AnswerBook Details

AnswerBook #:

2056MPS

Product:

Vantage

Date Added:

3/20/2002

Version:

Date Changed:

3/29/2004

Module:

Crystal Reports

_____

Summary:

How to add a compiled Crystal Report as a Vista\Vantage menu option.

Details:

Page ID 2056MPS

How to add a compiled Crystal Report as a Vista\Vantage menu option.

The following procedure will allow you to call a compiled Crystal Report
(.EXE) from a Vista\Vantage menu option. This will allow you to use
Vista\Vantage menu security to control user access to these reports.

Step #1: Create a Progress program (.W) file to call the Crystal Report
.EXE.

This program (.W) file would contain the following code:
============================================================

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
***********************************************************************/

ProgNamePath = "W:\Vantage\UD\Scrap By Reason Detail.exe".
* Note - Depending on version of program the application directory could
also be mfgsys60 or mfgsys61

RUN WinExec (INPUT ProgNamePath, INPUT 1, OUTPUT ReturnCode).

=====================================================================
The example above shows how a "Scrap By Reason Detail.Exe" would be
called. Include the full path to the compile report .exe.

Save this file as UD<Compile ReportName>.W and eliminate the spaces.

For example: Scrap By Reason Detail.exe "save as"
UDScrapByReasonDetail.w

Step #2: Copy the UD<Compile ReportName>.W file to the \Vantage\UD or
mfgsys60\UD or mfgsys61\UD folder.

Step #3: Use Vista\Vantage Menu Structure Maintenance to add a new menu
option to call the UD<Compile ReportName>.W

Note: Menu ID must start with UD. Any naming convention for the
remaining characters can be used.

Program must always include UD/UD<Compile Report Name>.W

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Josh Holman
Sent: Friday, 15 September 2006 10:27 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Confusion about adding Crystal reports directly into
Vantage.

In Vantage it seems you can add Report Builder reports directly into
the application so even those without Report Builder installed can run
them. I cannot find a way to do this with reports created in Crystal.
Does anyone have expierence with this? I'd like to write several custom
reports in Crystal but allow users to simply run them directly from
Vantage without Crystal installed on their client at all. Any help
would be appreciated.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]






---------------------------------
All-new Yahoo! Mail - Fire up a more powerful email and get things done faster.

[Non-text portions of this message have been removed]
I have added my procedures to the yahoo group. It is called Crystal
Report in Vantage 6.1.





<http://www.coldjet.com>

Michelle de la Vega

Business Applications Manager

Cold Jet, LLC

455 Wards Corner Road

Loveland, Ohio 45140

513-716-6400

513-831-1209 FAX

Celebrating 20 Years of Dry Ice Technology and Innovation

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Kelly Potratz
Sent: Friday, September 15, 2006 11:01 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Confusion about adding Crystal reports directly
into Vantage.



I would be interested in seeing your procedures as well. Could you post
them here?

Thanks,
Kelly Potratz

Michelle de la Vega <mdelavega@...
<mailto:mdelavega%40coldjet.com> > wrote:
Josh,

Epicor's procedures are lacking some information, I'll email you my
procedures that I have written.

Good Luck,

<http://www.coldjet.com <http://www.coldjet.com> >

Michelle de la Vega

Business Applications Manager

Cold Jet, LLC

455 Wards Corner Road

Loveland, Ohio 45140

513-716-6400

513-831-1209 FAX

Celebrating 20 Years of Dry Ice Technology and Innovation

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Stuart Noble
Sent: Thursday, September 14, 2006 11:10 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Confusion about adding Crystal reports directly
into Vantage.

Josh, this answer is straight off the answer book from Epicor. I haven't
got round to using it yet, but plan to down the track. The problem I had
was creating the compiled report ( the crystal .exe file) from memory. I
am sure this is what you are after though.

Cheers

Stuart

AnswerBook Details

AnswerBook #:

2056MPS

Product:

Vantage

Date Added:

3/20/2002

Version:

Date Changed:

3/29/2004

Module:

Crystal Reports

_____

Summary:

How to add a compiled Crystal Report as a Vista\Vantage menu option.

Details:

Page ID 2056MPS

How to add a compiled Crystal Report as a Vista\Vantage menu option.

The following procedure will allow you to call a compiled Crystal Report
(.EXE) from a Vista\Vantage menu option. This will allow you to use
Vista\Vantage menu security to control user access to these reports.

Step #1: Create a Progress program (.W) file to call the Crystal Report
.EXE.

This program (.W) file would contain the following code:
============================================================

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
***********************************************************************/

ProgNamePath = "W:\Vantage\UD\Scrap By Reason Detail.exe".
* Note - Depending on version of program the application directory could
also be mfgsys60 or mfgsys61

RUN WinExec (INPUT ProgNamePath, INPUT 1, OUTPUT ReturnCode).

=====================================================================
The example above shows how a "Scrap By Reason Detail.Exe" would be
called. Include the full path to the compile report .exe.

Save this file as UD<Compile ReportName>.W and eliminate the spaces.

For example: Scrap By Reason Detail.exe "save as"
UDScrapByReasonDetail.w

Step #2: Copy the UD<Compile ReportName>.W file to the \Vantage\UD or
mfgsys60\UD or mfgsys61\UD folder.

Step #3: Use Vista\Vantage Menu Structure Maintenance to add a new menu
option to call the UD<Compile ReportName>.W

Note: Menu ID must start with UD. Any naming convention for the
remaining characters can be used.

Program must always include UD/UD<Compile Report Name>.W

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Josh Holman
Sent: Friday, 15 September 2006 10:27 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Confusion about adding Crystal reports directly into
Vantage.

In Vantage it seems you can add Report Builder reports directly into
the application so even those without Report Builder installed can run
them. I cannot find a way to do this with reports created in Crystal.
Does anyone have expierence with this? I'd like to write several custom
reports in Crystal but allow users to simply run them directly from
Vantage without Crystal installed on their client at all. Any help
would be appreciated.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]


---------------------------------
All-new Yahoo! Mail - Fire up a more powerful email and get things done
faster.

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
Why don't you upload your procedure to the groups files.

Shirley Graver
Rubber Associates

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
rfc822 Compliance issue From: added by system POTENTIAL SPAM
Sent: Friday, September 15, 2006 10:08 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Confusion about adding Crystal reports directly into
Vantage.



Josh,

Epicor's procedures are lacking some information, I'll email you my
procedures that I have written.

Good Luck,

<http://www.coldjet <http://www.coldjet.com> com>

Michelle de la Vega

Business Applications Manager

Cold Jet, LLC

455 Wards Corner Road

Loveland, Ohio 45140

513-716-6400

513-831-1209 FAX

Celebrating 20 Years of Dry Ice Technology and Innovation

________________________________

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Stuart Noble
Sent: Thursday, September 14, 2006 11:10 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Confusion about adding Crystal reports directly
into Vantage.

Josh, this answer is straight off the answer book from Epicor. I haven't
got round to using it yet, but plan to down the track. The problem I had
was creating the compiled report ( the crystal .exe file) from memory. I
am sure this is what you are after though.

Cheers

Stuart

AnswerBook Details

AnswerBook #:

2056MPS

Product:

Vantage

Date Added:

3/20/2002

Version:

Date Changed:

3/29/2004

Module:

Crystal Reports

_____

Summary:

How to add a compiled Crystal Report as a Vista\Vantage menu option.

Details:

Page ID 2056MPS

How to add a compiled Crystal Report as a Vista\Vantage menu option.

The following procedure will allow you to call a compiled Crystal Report
(.EXE) from a Vista\Vantage menu option. This will allow you to use
Vista\Vantage menu security to control user access to these reports.

Step #1: Create a Progress program (.W) file to call the Crystal Report
.EXE.

This program (.W) file would contain the following code:
============================================================

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
***********************************************************************/

ProgNamePath = "W:\Vantage\UD\Scrap By Reason Detail.exe".
* Note - Depending on version of program the application directory could
also be mfgsys60 or mfgsys61

RUN WinExec (INPUT ProgNamePath, INPUT 1, OUTPUT ReturnCode).

=====================================================================
The example above shows how a "Scrap By Reason Detail.Exe" would be
called. Include the full path to the compile report .exe.

Save this file as UD<Compile ReportName>.W and eliminate the spaces.

For example: Scrap By Reason Detail.exe "save as"
UDScrapByReasonDetail.w

Step #2: Copy the UD<Compile ReportName>.W file to the \Vantage\UD or
mfgsys60\UD or mfgsys61\UD folder.

Step #3: Use Vista\Vantage Menu Structure Maintenance to add a new menu
option to call the UD<Compile ReportName>.W

Note: Menu ID must start with UD. Any naming convention for the
remaining characters can be used.

Program must always include UD/UD<Compile Report Name>.W

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Josh Holman
Sent: Friday, 15 September 2006 10:27 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Confusion about adding Crystal reports directly into
Vantage.

In Vantage it seems you can add Report Builder reports directly into
the application so even those without Report Builder installed can run
them. I cannot find a way to do this with reports created in Crystal.
Does anyone have expierence with this? I'd like to write several custom
reports in Crystal but allow users to simply run them directly from
Vantage without Crystal installed on their client at all. Any help
would be appreciated.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]