Adding a Crystal report to Vantage 8.0.403C

Yahoo Archive
1
Follow up: PROBLEM RESOLVED



After applying all the 3.0 .Net patches to no avail, shortening the
path to the file, searching Crystal's & Microsoft's knowledge bases I
discovered that by removing the spaces from the file name it worked as
expected................... It's been a learning experience



Thanks to all who help!



Dan Shallbetter





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Dan Shallbetter
Sent: Friday, December 07, 2007 1:31 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Adding a Crystal report to Vantage 8.0.403C



Steve,

I am testing report distribution methods using both the BAQ and ODBC
method. It is the BAQ method that I was seeing in system monitor . The
BAQ method report displays but some formulas need to be refined based on
filed conversions. It appears that the BAQ takes a date field i.e.
PayrollDate and converts it to date/time field type. The same report
using ODBC retains it as a date field type. My problem is trying to run
the ODBC report from a menu, nothing seems to happen. Do I need to
configure ODBC user access at the client level, or is this at the server
level? (see below a little fuzzy about what Epicor is talking about)

How to get a Custom Crystal Report onto the Vantage 8.03 Menu

Set-Up User Access for ODBC:

Ensure you have created the user 'sysprogress' with password
'sysprogress' using the Data Admin utility. You can access the Open Edge
Data Administration tool by taking your existing "Admin Tools" shortcut,
right click on it and enter properties:

On the end of the target line - replace "DataAdminMenu.w" with "_admin.r
-rx" so it reads (at the end) "-p _admin.r -rx".

Your AppServers for that DB should be stopped, but the DB itself should
be running. Rename the shortcut appropriately.

Thanks,

Dan

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of vantage
Sent: Friday, December 07, 2007 10:55 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Adding a Crystal report to Vantage 8.0.403C

Dan,

If you select the report in the system monitor and then select preview
from
above do you get any errors or does the report show up?

Steve

-----Original Message-----
From: Dan Shallbetter [mailto:dans@...
<mailto:dans%40stateselectric.com>
<mailto:dans%40stateselectric.com> ]
Sent: December 07, 2007 8:37 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Adding a Crystal report to Vantage 8.0.403C

Steve,

I tried that it. When I tried to run the report from a menu, the custom
report maintenance screen appears, I select print preview and nothing
happens. Looking at the system monitor the report shows up under the
reports tab with the last action as being auto-preview. As this is my
first attempt at this what might I being doing wrong?

Thanks,

Dan

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of vantage
Sent: Thursday, December 06, 2007 3:54 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Adding a Crystal report to Vantage 8.0.403C

Sorry, should say without any data in the report!

This is a bug in the new .net release for the viewer. You need to save
your
report with any data in it from the report builder to get the prompted
to
show up.

Steve

-----Original Message-----
From: Dan Shallbetter [mailto:dans@stateselectric
<mailto:dans%40stateselectric.com> .com
<mailto:dans%40stateselectric.com> ]
Sent: December 06, 2007 2:53 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Adding a Crystal report to Vantage 8.0.403C

Hello,

I have added a test ODBC report though menu maintenance (verifying ODBC
setup). I am trying to add a report that uses parameter fields for
record selection. It flashes retrieving data but never returns anything
else. I would have expected to be prompted for the parameter values? Any
help would be appreciated.

Thanks,

Dan Shallbetter

States Electric Mfg.

[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]

[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]
2
Hello,



I have added a test ODBC report though menu maintenance (verifying ODBC
setup). I am trying to add a report that uses parameter fields for
record selection. It flashes retrieving data but never returns anything
else. I would have expected to be prompted for the parameter values? Any
help would be appreciated.



Thanks,



Dan Shallbetter

States Electric Mfg.



[Non-text portions of this message have been removed]
3
This is a bug in the new .net release for the viewer. You need to save your
report with any data in it from the report builder to get the prompted to
show up.



Steve



-----Original Message-----
From: Dan Shallbetter [mailto:dans@...]
Sent: December 06, 2007 2:53 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Adding a Crystal report to Vantage 8.0.403C



Hello,

I have added a test ODBC report though menu maintenance (verifying ODBC
setup). I am trying to add a report that uses parameter fields for
record selection. It flashes retrieving data but never returns anything
else. I would have expected to be prompted for the parameter values? Any
help would be appreciated.

Thanks,

Dan Shallbetter

States Electric Mfg.

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





[Non-text portions of this message have been removed]
4
Sorry, should say without any data in the report!



This is a bug in the new .net release for the viewer. You need to save your
report with any data in it from the report builder to get the prompted to
show up.



Steve



-----Original Message-----
From: Dan Shallbetter [mailto:dans@...]
Sent: December 06, 2007 2:53 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Adding a Crystal report to Vantage 8.0.403C



Hello,

I have added a test ODBC report though menu maintenance (verifying ODBC
setup). I am trying to add a report that uses parameter fields for
record selection. It flashes retrieving data but never returns anything
else. I would have expected to be prompted for the parameter values? Any
help would be appreciated.

Thanks,

Dan Shallbetter

States Electric Mfg.

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





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



Have you ever used the BAQ Report Designer? Much cleaner solution to
custom reports than ODBC. Building the query can sometimes be a little
tricky as the tool used to do so is a little weak, but the integration
of the report into the Vantage interface is seamless and works
identically to all 'canned' reports. Indistinguishable to the end user.



Todd



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Dan Shallbetter
Sent: Thursday, December 06, 2007 3:53 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Adding a Crystal report to Vantage 8.0.403C



Hello,

I have added a test ODBC report though menu maintenance (verifying ODBC
setup). I am trying to add a report that uses parameter fields for
record selection. It flashes retrieving data but never returns anything
else. I would have expected to be prompted for the parameter values? Any
help would be appreciated.

Thanks,

Dan Shallbetter

States Electric Mfg.

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





This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.

[Non-text portions of this message have been removed]
6
Hello Todd,



I started down that path to begin with (my first attempt with BAQ). When
I created the following criteria in the BAQ



for each EmpBasic where ( EmpBasic.EmpStatus = 'A') no-lock , each
LaborHed where (AND LaborHed.PayrollDate >= 02/19/2007) and
(EmpBasic.EmpID = LaborHed.EmployeeNum) no-lock .



And then analyze the statement it returns the following error:



** Unable to understand after -- "no-lock where". (247)



I removed the payroll date criteria and it tested fine.

I have the following questions:

I added the payroll date filter as an option in the BAQ report designer.
It appears that this eliminates the need for doing the same record
filtering in Crystal using parameter fields?

Can I create criteria for multiple tables in the BAQ and how does one
edit the syntax errors that creates?

When I tested the BAQ it returns a lot of data, generating data in the
report designer appears to create a very small sample set of data and
only after deploying the BAQ do I see the expected results ( spent a
long time trying to understand why my Crystal report was not returning
more data before I figured that one out) is there a way to expand the
amount of data it generates?



Thanks for the help and advice!



Dan Shallbetter

States Electric Mfg.





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Hofert
Sent: Thursday, December 06, 2007 4:03 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Adding a Crystal report to Vantage 8.0.403C



Dan,

Have you ever used the BAQ Report Designer? Much cleaner solution to
custom reports than ODBC. Building the query can sometimes be a little
tricky as the tool used to do so is a little weak, but the integration
of the report into the Vantage interface is seamless and works
identically to all 'canned' reports. Indistinguishable to the end user.

Todd

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Dan Shallbetter
Sent: Thursday, December 06, 2007 3:53 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Adding a Crystal report to Vantage 8.0.403C

Hello,

I have added a test ODBC report though menu maintenance (verifying ODBC
setup). I am trying to add a report that uses parameter fields for
record selection. It flashes retrieving data but never returns anything
else. I would have expected to be prompted for the parameter values? Any
help would be appreciated.

Thanks,

Dan Shallbetter

States Electric Mfg.

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

This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.

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





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



I tried that it. When I tried to run the report from a menu, the custom
report maintenance screen appears, I select print preview and nothing
happens. Looking at the system monitor the report shows up under the
reports tab with the last action as being auto-preview. As this is my
first attempt at this what might I being doing wrong?



Thanks,



Dan





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of vantage
Sent: Thursday, December 06, 2007 3:54 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Adding a Crystal report to Vantage 8.0.403C



Sorry, should say without any data in the report!

This is a bug in the new .net release for the viewer. You need to save
your
report with any data in it from the report builder to get the prompted
to
show up.

Steve

-----Original Message-----
From: Dan Shallbetter [mailto:dans@...
<mailto:dans%40stateselectric.com> ]
Sent: December 06, 2007 2:53 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Adding a Crystal report to Vantage 8.0.403C

Hello,

I have added a test ODBC report though menu maintenance (verifying ODBC
setup). I am trying to add a report that uses parameter fields for
record selection. It flashes retrieving data but never returns anything
else. I would have expected to be prompted for the parameter values? Any
help would be appreciated.

Thanks,

Dan Shallbetter

States Electric Mfg.

[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]
8
Dan,



If you select the report in the system monitor and then select preview from
above do you get any errors or does the report show up?



Steve



-----Original Message-----
From: Dan Shallbetter [mailto:dans@...]
Sent: December 07, 2007 8:37 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Adding a Crystal report to Vantage 8.0.403C



Steve,

I tried that it. When I tried to run the report from a menu, the custom
report maintenance screen appears, I select print preview and nothing
happens. Looking at the system monitor the report shows up under the
reports tab with the last action as being auto-preview. As this is my
first attempt at this what might I being doing wrong?

Thanks,

Dan

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of vantage
Sent: Thursday, December 06, 2007 3:54 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Adding a Crystal report to Vantage 8.0.403C

Sorry, should say without any data in the report!

This is a bug in the new .net release for the viewer. You need to save
your
report with any data in it from the report builder to get the prompted
to
show up.

Steve

-----Original Message-----
From: Dan Shallbetter [mailto:dans@stateselectric
<mailto:dans%40stateselectric.com> .com
<mailto:dans%40stateselectric.com> ]
Sent: December 06, 2007 2:53 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Adding a Crystal report to Vantage 8.0.403C

Hello,

I have added a test ODBC report though menu maintenance (verifying ODBC
setup). I am trying to add a report that uses parameter fields for
record selection. It flashes retrieving data but never returns anything
else. I would have expected to be prompted for the parameter values? Any
help would be appreciated.

Thanks,

Dan Shallbetter

States Electric Mfg.

[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]





[Non-text portions of this message have been removed]
9
Make sure your menu item report path is a UNC destination to a share and
not too long

Gary Parfrey

Dot Net IT Limited, Reg No 4412519

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Dan Shallbetter
Sent: 07 December 2007 14:37
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Adding a Crystal report to Vantage 8.0.403C



Steve,

I tried that it. When I tried to run the report from a menu, the custom
report maintenance screen appears, I select print preview and nothing
happens. Looking at the system monitor the report shows up under the
reports tab with the last action as being auto-preview. As this is my
first attempt at this what might I being doing wrong?

Thanks,

Dan

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of vantage
Sent: Thursday, December 06, 2007 3:54 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Adding a Crystal report to Vantage 8.0.403C

Sorry, should say without any data in the report!

This is a bug in the new .net release for the viewer. You need to save
your
report with any data in it from the report builder to get the prompted
to
show up.

Steve

-----Original Message-----
From: Dan Shallbetter [mailto:dans@...
<mailto:dans%40stateselectric.com>
<mailto:dans%40stateselectric.com> ]
Sent: December 06, 2007 2:53 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Adding a Crystal report to Vantage 8.0.403C

Hello,

I have added a test ODBC report though menu maintenance (verifying ODBC
setup). I am trying to add a report that uses parameter fields for
record selection. It flashes retrieving data but never returns anything
else. I would have expected to be prompted for the parameter values? Any
help would be appreciated.

Thanks,

Dan Shallbetter

States Electric Mfg.

[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]





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



I am testing report distribution methods using both the BAQ and ODBC
method. It is the BAQ method that I was seeing in system monitor . The
BAQ method report displays but some formulas need to be refined based on
filed conversions. It appears that the BAQ takes a date field i.e.
PayrollDate and converts it to date/time field type. The same report
using ODBC retains it as a date field type. My problem is trying to run
the ODBC report from a menu, nothing seems to happen. Do I need to
configure ODBC user access at the client level, or is this at the server
level? (see below a little fuzzy about what Epicor is talking about)



How to get a Custom Crystal Report onto the Vantage 8.03 Menu



Set-Up User Access for ODBC:



Ensure you have created the user 'sysprogress' with password
'sysprogress' using the Data Admin utility. You can access the Open Edge
Data Administration tool by taking your existing "Admin Tools" shortcut,
right click on it and enter properties:



On the end of the target line - replace "DataAdminMenu.w" with "_admin.r
-rx" so it reads (at the end) "-p _admin.r -rx".



Your AppServers for that DB should be stopped, but the DB itself should
be running. Rename the shortcut appropriately.



Thanks,

Dan









From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of vantage
Sent: Friday, December 07, 2007 10:55 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Adding a Crystal report to Vantage 8.0.403C



Dan,

If you select the report in the system monitor and then select preview
from
above do you get any errors or does the report show up?

Steve

-----Original Message-----
From: Dan Shallbetter [mailto:dans@...
<mailto:dans%40stateselectric.com> ]
Sent: December 07, 2007 8:37 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Adding a Crystal report to Vantage 8.0.403C

Steve,

I tried that it. When I tried to run the report from a menu, the custom
report maintenance screen appears, I select print preview and nothing
happens. Looking at the system monitor the report shows up under the
reports tab with the last action as being auto-preview. As this is my
first attempt at this what might I being doing wrong?

Thanks,

Dan

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of vantage
Sent: Thursday, December 06, 2007 3:54 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Adding a Crystal report to Vantage 8.0.403C

Sorry, should say without any data in the report!

This is a bug in the new .net release for the viewer. You need to save
your
report with any data in it from the report builder to get the prompted
to
show up.

Steve

-----Original Message-----
From: Dan Shallbetter [mailto:dans@stateselectric
<mailto:dans%40stateselectric.com> .com
<mailto:dans%40stateselectric.com> ]
Sent: December 06, 2007 2:53 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Adding a Crystal report to Vantage 8.0.403C

Hello,

I have added a test ODBC report though menu maintenance (verifying ODBC
setup). I am trying to add a report that uses parameter fields for
record selection. It flashes retrieving data but never returns anything
else. I would have expected to be prompted for the parameter values? Any
help would be appreciated.

Thanks,

Dan Shallbetter

States Electric Mfg.

[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]

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





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