BAQ Crystal Report Problem

Yahoo Archive
1
If it was a snake it would have bit me!



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Karen Schoenung
Sent: Wednesday, June 24, 2009 12:35 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ Crystal Report Problem








Charlie,

In Crystal Reports, you have the option under File...Save or Save with
report data...

Karen

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Charlie Wilson
Sent: Wednesday, June 24, 2009 11:32 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] BAQ Crystal Report Problem

How do you save the report without data in it?

~Charlie

_____

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
Rob Bucek
Sent: Wednesday, June 24, 2009 12:27 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BAQ Crystal Report Problem

You said that right Charlie, its probably by sheer luck then that it
hasn't happened to me as it is force of habit to not save data in the
reports... it would have had me stumped, and I run reports remotely
quite often.

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Charlie Wilson
Sent: Wednesday, June 24, 2009 8:38 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] BAQ Crystal Report Problem

I got it straitened out the first response was right it was pulling the
data
saved in the report when I opened it locally. But when I went somewhere
else
it tried to find a new dataset that wasn't in the same local. Also the
dataset I used to design the report wasn't right. The "sample data" I
used I
pulled from a dashboard I had to pull another set of sample data from
the
BAQ itself and redo the majority of the report all is working now.

This is the first BAQ to crystal I have done so I'm figuring it out as I
go.
Not the smoothest process in the world to do. Lots of places you can get
hung up.

~Charlie

_____

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
Rob Bucek
Sent: Wednesday, June 24, 2009 9:23 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BAQ Crystal Report Problem

Charlie, did you create that BAQ report while remoted into the server?

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Charlie Wilson
Sent: Wednesday, June 24, 2009 7:56 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] BAQ Crystal Report Problem

I'm on 8.03.407.

Epricor has them all over the place. Quotes, invoices, AP checks, and
several other places. It's going on in the background. Instead of the
Crystal opening a ODBC into the DB for it's data vantage kicks out a
....XML
file that is then read by the crystal report.

~Charlie

_____

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
Patty Richter
Sent: Wednesday, June 24, 2009 8:44 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] BAQ Crystal Report Problem

'canned' BAQ to crystal reports??? This caught my interest - what
version
are you on? and what do you mean by 'canned'...

________________________________
From: Charlie Wilson <foamdesigncsw@ <mailto:foamdesigncsw%40yahoo.com>
yahoo.com>
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Sent: Wednesday, June 24, 2009 6:11:01 AM
Subject: [Vantage] BAQ Crystal Report Problem

All,

I have created a nice little report for our QA department that prints up
to
nice Corrective actions forms. But I have a problem when I run the
report
when I am remoted into the server it works perfectly but if I run it
from
any other machine it ask me to specify the location of the dataset and
enter
a username and password. Now my guess would be that crystal is getting
passed the location of the dataset (.xml file) in this format
c:\epicor\mfgsysdat a\reports\ username\ ****.xml instead of like this
\\servername\ epicor\mfgsysdat a\reports\ username\ ****.xml. The only
problem
is I can't figure out where the setting is to adjust this. Any ideas?

PS all of the "canned" BAQ to Crystal reports are working for us just
not
this one I have made.

~Charlie

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

[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
All,



I have created a nice little report for our QA department that prints up to
nice Corrective actions forms. But I have a problem when I run the report
when I am remoted into the server it works perfectly but if I run it from
any other machine it ask me to specify the location of the dataset and enter
a username and password. Now my guess would be that crystal is getting
passed the location of the dataset (.xml file) in this format
c:\epicor\mfgsysdata\reports\username\****.xml instead of like this
\\servername\epicor\mfgsysdata\reports\username\****.xml. The only problem
is I can't figure out where the setting is to adjust this. Any ideas?



PS all of the "canned" BAQ to Crystal reports are working for us just not
this one I have made.





~Charlie





[Non-text portions of this message have been removed]
3
That is stored in the system agent. In the SystemAppServer section,
Client File specifies the unc path to the print directory. it should be in UNC format.
Â
If you had it wrong then it should not work for the other reports also.
I would check to be sure it is in unc format but I do not think that is the problem.
Â
Asking for the user name and password sounds like a permission problem with the file or folder.
Â
Have you made sure that the data is not being saved with the Crystal Report? This is another long shot but does happen sometimes.
Â
Â
Â


--- On Wed, 6/24/09, Charlie Wilson <foamdesigncsw@...> wrote:


From: Charlie Wilson <foamdesigncsw@...>
Subject: [Vantage] BAQ Crystal Report Problem
To: vantage@yahoogroups.com
Date: Wednesday, June 24, 2009, 6:11 AM








All,

I have created a nice little report for our QA department that prints up to
nice Corrective actions forms. But I have a problem when I run the report
when I am remoted into the server it works perfectly but if I run it from
any other machine it ask me to specify the location of the dataset and enter
a username and password. Now my guess would be that crystal is getting
passed the location of the dataset (.xml file) in this format
c:\epicor\mfgsysdat a\reports\ username\ ****.xml instead of like this
\\servername\ epicor\mfgsysdat a\reports\ username\ ****.xml. The only problem
is I can't figure out where the setting is to adjust this. Any ideas?

PS all of the "canned" BAQ to Crystal reports are working for us just not
this one I have made.

~Charlie

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



















[Non-text portions of this message have been removed]
4
'canned' BAQ to crystal reports??? This caught my interest - what version are you on? and what do you mean by 'canned'...




________________________________
From: Charlie Wilson <foamdesigncsw@...>
To: vantage@yahoogroups.com
Sent: Wednesday, June 24, 2009 6:11:01 AM
Subject: [Vantage] BAQ Crystal Report Problem





All,

I have created a nice little report for our QA department that prints up to
nice Corrective actions forms. But I have a problem when I run the report
when I am remoted into the server it works perfectly but if I run it from
any other machine it ask me to specify the location of the dataset and enter
a username and password. Now my guess would be that crystal is getting
passed the location of the dataset (.xml file) in this format
c:\epicor\mfgsysdat a\reports\ username\ ****.xml instead of like this
\\servername\ epicor\mfgsysdat a\reports\ username\ ****.xml. The only problem
is I can't figure out where the setting is to adjust this. Any ideas?

PS all of the "canned" BAQ to Crystal reports are working for us just not
this one I have made.

~Charlie

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







[Non-text portions of this message have been removed]
5
I'm on 8.03.407.



Epricor has them all over the place. Quotes, invoices, AP checks, and
several other places. It's going on in the background. Instead of the
Crystal opening a ODBC into the DB for it's data vantage kicks out a .XML
file that is then read by the crystal report.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Patty Richter
Sent: Wednesday, June 24, 2009 8:44 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BAQ Crystal Report Problem








'canned' BAQ to crystal reports??? This caught my interest - what version
are you on? and what do you mean by 'canned'...

________________________________
From: Charlie Wilson <foamdesigncsw@ <mailto:foamdesigncsw%40yahoo.com>
yahoo.com>
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Sent: Wednesday, June 24, 2009 6:11:01 AM
Subject: [Vantage] BAQ Crystal Report Problem

All,

I have created a nice little report for our QA department that prints up to
nice Corrective actions forms. But I have a problem when I run the report
when I am remoted into the server it works perfectly but if I run it from
any other machine it ask me to specify the location of the dataset and enter
a username and password. Now my guess would be that crystal is getting
passed the location of the dataset (.xml file) in this format
c:\epicor\mfgsysdat a\reports\ username\ ****.xml instead of like this
\\servername\ epicor\mfgsysdat a\reports\ username\ ****.xml. The only
problem
is I can't figure out where the setting is to adjust this. Any ideas?

PS all of the "canned" BAQ to Crystal reports are working for us just not
this one I have made.

~Charlie

[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]
6
In Database expert, create new connection, ADO.Net (XML), if you click
this connection, you can specify the path...



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Charlie Wilson
Sent: Wednesday, June 24, 2009 6:11 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Crystal Report Problem








All,

I have created a nice little report for our QA department that prints up
to
nice Corrective actions forms. But I have a problem when I run the
report
when I am remoted into the server it works perfectly but if I run it
from
any other machine it ask me to specify the location of the dataset and
enter
a username and password. Now my guess would be that crystal is getting
passed the location of the dataset (.xml file) in this format
c:\epicor\mfgsysdata\reports\username\****.xml instead of like this
\\servername\epicor\mfgsysdata\reports\username\****.xml. The only
problem
is I can't figure out where the setting is to adjust this. Any ideas?

PS all of the "canned" BAQ to Crystal reports are working for us just
not
this one I have made.

~Charlie

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





[Non-text portions of this message have been removed]
7
Charlie, did you create that BAQ report while remoted into the server?



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Charlie Wilson
Sent: Wednesday, June 24, 2009 7:56 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ Crystal Report Problem





I'm on 8.03.407.

Epricor has them all over the place. Quotes, invoices, AP checks, and
several other places. It's going on in the background. Instead of the
Crystal opening a ODBC into the DB for it's data vantage kicks out a
.XML
file that is then read by the crystal report.

~Charlie

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Patty Richter
Sent: Wednesday, June 24, 2009 8:44 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] BAQ Crystal Report Problem

'canned' BAQ to crystal reports??? This caught my interest - what
version
are you on? and what do you mean by 'canned'...

________________________________
From: Charlie Wilson <foamdesigncsw@ <mailto:foamdesigncsw%40yahoo.com>
yahoo.com>
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Sent: Wednesday, June 24, 2009 6:11:01 AM
Subject: [Vantage] BAQ Crystal Report Problem

All,

I have created a nice little report for our QA department that prints up
to
nice Corrective actions forms. But I have a problem when I run the
report
when I am remoted into the server it works perfectly but if I run it
from
any other machine it ask me to specify the location of the dataset and
enter
a username and password. Now my guess would be that crystal is getting
passed the location of the dataset (.xml file) in this format
c:\epicor\mfgsysdat a\reports\ username\ ****.xml instead of like this
\\servername\ epicor\mfgsysdat a\reports\ username\ ****.xml. The only
problem
is I can't figure out where the setting is to adjust this. Any ideas?

PS all of the "canned" BAQ to Crystal reports are working for us just
not
this one I have made.

~Charlie

[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]
8
I got it straitened out the first response was right it was pulling the data
saved in the report when I opened it locally. But when I went somewhere else
it tried to find a new dataset that wasn't in the same local. Also the
dataset I used to design the report wasn't right. The "sample data" I used I
pulled from a dashboard I had to pull another set of sample data from the
BAQ itself and redo the majority of the report all is working now.



This is the first BAQ to crystal I have done so I'm figuring it out as I go.
Not the smoothest process in the world to do. Lots of places you can get
hung up.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Rob Bucek
Sent: Wednesday, June 24, 2009 9:23 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ Crystal Report Problem








Charlie, did you create that BAQ report while remoted into the server?

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Charlie Wilson
Sent: Wednesday, June 24, 2009 7:56 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] BAQ Crystal Report Problem

I'm on 8.03.407.

Epricor has them all over the place. Quotes, invoices, AP checks, and
several other places. It's going on in the background. Instead of the
Crystal opening a ODBC into the DB for it's data vantage kicks out a
..XML
file that is then read by the crystal report.

~Charlie

_____

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
Patty Richter
Sent: Wednesday, June 24, 2009 8:44 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] BAQ Crystal Report Problem

'canned' BAQ to crystal reports??? This caught my interest - what
version
are you on? and what do you mean by 'canned'...

________________________________
From: Charlie Wilson <foamdesigncsw@ <mailto:foamdesigncsw%40yahoo.com>
yahoo.com>
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Sent: Wednesday, June 24, 2009 6:11:01 AM
Subject: [Vantage] BAQ Crystal Report Problem

All,

I have created a nice little report for our QA department that prints up
to
nice Corrective actions forms. But I have a problem when I run the
report
when I am remoted into the server it works perfectly but if I run it
from
any other machine it ask me to specify the location of the dataset and
enter
a username and password. Now my guess would be that crystal is getting
passed the location of the dataset (.xml file) in this format
c:\epicor\mfgsysdat a\reports\ username\ ****.xml instead of like this
\\servername\ epicor\mfgsysdat a\reports\ username\ ****.xml. The only
problem
is I can't figure out where the setting is to adjust this. Any ideas?

PS all of the "canned" BAQ to Crystal reports are working for us just
not
this one I have made.

~Charlie

[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]
9
You said that right Charlie, its probably by sheer luck then that it
hasn't happened to me as it is force of habit to not save data in the
reports... it would have had me stumped, and I run reports remotely
quite often.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Charlie Wilson
Sent: Wednesday, June 24, 2009 8:38 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ Crystal Report Problem





I got it straitened out the first response was right it was pulling the
data
saved in the report when I opened it locally. But when I went somewhere
else
it tried to find a new dataset that wasn't in the same local. Also the
dataset I used to design the report wasn't right. The "sample data" I
used I
pulled from a dashboard I had to pull another set of sample data from
the
BAQ itself and redo the majority of the report all is working now.

This is the first BAQ to crystal I have done so I'm figuring it out as I
go.
Not the smoothest process in the world to do. Lots of places you can get
hung up.

~Charlie

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Rob Bucek
Sent: Wednesday, June 24, 2009 9:23 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BAQ Crystal Report Problem

Charlie, did you create that BAQ report while remoted into the server?

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Charlie Wilson
Sent: Wednesday, June 24, 2009 7:56 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] BAQ Crystal Report Problem

I'm on 8.03.407.

Epricor has them all over the place. Quotes, invoices, AP checks, and
several other places. It's going on in the background. Instead of the
Crystal opening a ODBC into the DB for it's data vantage kicks out a
..XML
file that is then read by the crystal report.

~Charlie

_____

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
Patty Richter
Sent: Wednesday, June 24, 2009 8:44 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] BAQ Crystal Report Problem

'canned' BAQ to crystal reports??? This caught my interest - what
version
are you on? and what do you mean by 'canned'...

________________________________
From: Charlie Wilson <foamdesigncsw@ <mailto:foamdesigncsw%40yahoo.com>
yahoo.com>
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Sent: Wednesday, June 24, 2009 6:11:01 AM
Subject: [Vantage] BAQ Crystal Report Problem

All,

I have created a nice little report for our QA department that prints up
to
nice Corrective actions forms. But I have a problem when I run the
report
when I am remoted into the server it works perfectly but if I run it
from
any other machine it ask me to specify the location of the dataset and
enter
a username and password. Now my guess would be that crystal is getting
passed the location of the dataset (.xml file) in this format
c:\epicor\mfgsysdat a\reports\ username\ ****.xml instead of like this
\\servername\ epicor\mfgsysdat a\reports\ username\ ****.xml. The only
problem
is I can't figure out where the setting is to adjust this. Any ideas?

PS all of the "canned" BAQ to Crystal reports are working for us just
not
this one I have made.

~Charlie

[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]
10
How do you save the report without data in it?



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Rob Bucek
Sent: Wednesday, June 24, 2009 12:27 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ Crystal Report Problem








You said that right Charlie, its probably by sheer luck then that it
hasn't happened to me as it is force of habit to not save data in the
reports... it would have had me stumped, and I run reports remotely
quite often.

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Charlie Wilson
Sent: Wednesday, June 24, 2009 8:38 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] BAQ Crystal Report Problem

I got it straitened out the first response was right it was pulling the
data
saved in the report when I opened it locally. But when I went somewhere
else
it tried to find a new dataset that wasn't in the same local. Also the
dataset I used to design the report wasn't right. The "sample data" I
used I
pulled from a dashboard I had to pull another set of sample data from
the
BAQ itself and redo the majority of the report all is working now.

This is the first BAQ to crystal I have done so I'm figuring it out as I
go.
Not the smoothest process in the world to do. Lots of places you can get
hung up.

~Charlie

_____

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
Rob Bucek
Sent: Wednesday, June 24, 2009 9:23 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BAQ Crystal Report Problem

Charlie, did you create that BAQ report while remoted into the server?

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Charlie Wilson
Sent: Wednesday, June 24, 2009 7:56 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] BAQ Crystal Report Problem

I'm on 8.03.407.

Epricor has them all over the place. Quotes, invoices, AP checks, and
several other places. It's going on in the background. Instead of the
Crystal opening a ODBC into the DB for it's data vantage kicks out a
...XML
file that is then read by the crystal report.

~Charlie

_____

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
Patty Richter
Sent: Wednesday, June 24, 2009 8:44 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] BAQ Crystal Report Problem

'canned' BAQ to crystal reports??? This caught my interest - what
version
are you on? and what do you mean by 'canned'...

________________________________
From: Charlie Wilson <foamdesigncsw@ <mailto:foamdesigncsw%40yahoo.com>
yahoo.com>
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Sent: Wednesday, June 24, 2009 6:11:01 AM
Subject: [Vantage] BAQ Crystal Report Problem

All,

I have created a nice little report for our QA department that prints up
to
nice Corrective actions forms. But I have a problem when I run the
report
when I am remoted into the server it works perfectly but if I run it
from
any other machine it ask me to specify the location of the dataset and
enter
a username and password. Now my guess would be that crystal is getting
passed the location of the dataset (.xml file) in this format
c:\epicor\mfgsysdat a\reports\ username\ ****.xml instead of like this
\\servername\ epicor\mfgsysdat a\reports\ username\ ****.xml. The only
problem
is I can't figure out where the setting is to adjust this. Any ideas?

PS all of the "canned" BAQ to Crystal reports are working for us just
not
this one I have made.

~Charlie

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





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



In Crystal Reports, you have the option under File...Save or Save with
report data...



Karen



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Charlie Wilson
Sent: Wednesday, June 24, 2009 11:32 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ Crystal Report Problem








How do you save the report without data in it?

~Charlie

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Rob Bucek
Sent: Wednesday, June 24, 2009 12:27 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BAQ Crystal Report Problem

You said that right Charlie, its probably by sheer luck then that it
hasn't happened to me as it is force of habit to not save data in the
reports... it would have had me stumped, and I run reports remotely
quite often.

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Charlie Wilson
Sent: Wednesday, June 24, 2009 8:38 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] BAQ Crystal Report Problem

I got it straitened out the first response was right it was pulling the
data
saved in the report when I opened it locally. But when I went somewhere
else
it tried to find a new dataset that wasn't in the same local. Also the
dataset I used to design the report wasn't right. The "sample data" I
used I
pulled from a dashboard I had to pull another set of sample data from
the
BAQ itself and redo the majority of the report all is working now.

This is the first BAQ to crystal I have done so I'm figuring it out as I
go.
Not the smoothest process in the world to do. Lots of places you can get
hung up.

~Charlie

_____

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
Rob Bucek
Sent: Wednesday, June 24, 2009 9:23 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BAQ Crystal Report Problem

Charlie, did you create that BAQ report while remoted into the server?

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Charlie Wilson
Sent: Wednesday, June 24, 2009 7:56 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] BAQ Crystal Report Problem

I'm on 8.03.407.

Epricor has them all over the place. Quotes, invoices, AP checks, and
several other places. It's going on in the background. Instead of the
Crystal opening a ODBC into the DB for it's data vantage kicks out a
...XML
file that is then read by the crystal report.

~Charlie

_____

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
Patty Richter
Sent: Wednesday, June 24, 2009 8:44 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] BAQ Crystal Report Problem

'canned' BAQ to crystal reports??? This caught my interest - what
version
are you on? and what do you mean by 'canned'...

________________________________
From: Charlie Wilson <foamdesigncsw@ <mailto:foamdesigncsw%40yahoo.com>
yahoo.com>
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Sent: Wednesday, June 24, 2009 6:11:01 AM
Subject: [Vantage] BAQ Crystal Report Problem

All,

I have created a nice little report for our QA department that prints up
to
nice Corrective actions forms. But I have a problem when I run the
report
when I am remoted into the server it works perfectly but if I run it
from
any other machine it ask me to specify the location of the dataset and
enter
a username and password. Now my guess would be that crystal is getting
passed the location of the dataset (.xml file) in this format
c:\epicor\mfgsysdat a\reports\ username\ ****.xml instead of like this
\\servername\ epicor\mfgsysdat a\reports\ username\ ****.xml. The only
problem
is I can't figure out where the setting is to adjust this. Any ideas?

PS all of the "canned" BAQ to Crystal reports are working for us just
not
this one I have made.

~Charlie

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

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





[Non-text portions of this message have been removed]
12
Make sure to uncheck save with report data



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Karen Schoenung
Sent: Wednesday, June 24, 2009 11:35 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ Crystal Report Problem








Charlie,

In Crystal Reports, you have the option under File...Save or Save with
report data...

Karen

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Charlie Wilson
Sent: Wednesday, June 24, 2009 11:32 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BAQ Crystal Report Problem

How do you save the report without data in it?

~Charlie

_____

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
Rob Bucek
Sent: Wednesday, June 24, 2009 12:27 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BAQ Crystal Report Problem

You said that right Charlie, its probably by sheer luck then that it
hasn't happened to me as it is force of habit to not save data in the
reports... it would have had me stumped, and I run reports remotely
quite often.

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Charlie Wilson
Sent: Wednesday, June 24, 2009 8:38 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] BAQ Crystal Report Problem

I got it straitened out the first response was right it was pulling the
data
saved in the report when I opened it locally. But when I went somewhere
else
it tried to find a new dataset that wasn't in the same local. Also the
dataset I used to design the report wasn't right. The "sample data" I
used I
pulled from a dashboard I had to pull another set of sample data from
the
BAQ itself and redo the majority of the report all is working now.

This is the first BAQ to crystal I have done so I'm figuring it out as I
go.
Not the smoothest process in the world to do. Lots of places you can get
hung up.

~Charlie

_____

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
Rob Bucek
Sent: Wednesday, June 24, 2009 9:23 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BAQ Crystal Report Problem

Charlie, did you create that BAQ report while remoted into the server?

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Charlie Wilson
Sent: Wednesday, June 24, 2009 7:56 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] BAQ Crystal Report Problem

I'm on 8.03.407.

Epricor has them all over the place. Quotes, invoices, AP checks, and
several other places. It's going on in the background. Instead of the
Crystal opening a ODBC into the DB for it's data vantage kicks out a
...XML
file that is then read by the crystal report.

~Charlie

_____

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
Patty Richter
Sent: Wednesday, June 24, 2009 8:44 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] BAQ Crystal Report Problem

'canned' BAQ to crystal reports??? This caught my interest - what
version
are you on? and what do you mean by 'canned'...

________________________________
From: Charlie Wilson <foamdesigncsw@ <mailto:foamdesigncsw%40yahoo.com>
yahoo.com>
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Sent: Wednesday, June 24, 2009 6:11:01 AM
Subject: [Vantage] BAQ Crystal Report Problem

All,

I have created a nice little report for our QA department that prints up
to
nice Corrective actions forms. But I have a problem when I run the
report
when I am remoted into the server it works perfectly but if I run it
from
any other machine it ask me to specify the location of the dataset and
enter
a username and password. Now my guess would be that crystal is getting
passed the location of the dataset (.xml file) in this format
c:\epicor\mfgsysdat a\reports\ username\ ****.xml instead of like this
\\servername\ epicor\mfgsysdat a\reports\ username\ ****.xml. The only
problem
is I can't figure out where the setting is to adjust this. Any ideas?

PS all of the "canned" BAQ to Crystal reports are working for us just
not
this one I have made.

~Charlie

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

[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]
13
Open the report, under file, report options, uncheck save data with
report.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Charlie Wilson
Sent: Wednesday, June 24, 2009 11:32 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ Crystal Report Problem





How do you save the report without data in it?

~Charlie

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Rob Bucek
Sent: Wednesday, June 24, 2009 12:27 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BAQ Crystal Report Problem

You said that right Charlie, its probably by sheer luck then that it
hasn't happened to me as it is force of habit to not save data in the
reports... it would have had me stumped, and I run reports remotely
quite often.

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Charlie Wilson
Sent: Wednesday, June 24, 2009 8:38 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] BAQ Crystal Report Problem

I got it straitened out the first response was right it was pulling the
data
saved in the report when I opened it locally. But when I went somewhere
else
it tried to find a new dataset that wasn't in the same local. Also the
dataset I used to design the report wasn't right. The "sample data" I
used I
pulled from a dashboard I had to pull another set of sample data from
the
BAQ itself and redo the majority of the report all is working now.

This is the first BAQ to crystal I have done so I'm figuring it out as I
go.
Not the smoothest process in the world to do. Lots of places you can get
hung up.

~Charlie

_____

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
Rob Bucek
Sent: Wednesday, June 24, 2009 9:23 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BAQ Crystal Report Problem

Charlie, did you create that BAQ report while remoted into the server?

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Charlie Wilson
Sent: Wednesday, June 24, 2009 7:56 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] BAQ Crystal Report Problem

I'm on 8.03.407.

Epricor has them all over the place. Quotes, invoices, AP checks, and
several other places. It's going on in the background. Instead of the
Crystal opening a ODBC into the DB for it's data vantage kicks out a
...XML
file that is then read by the crystal report.

~Charlie

_____

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
Patty Richter
Sent: Wednesday, June 24, 2009 8:44 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] BAQ Crystal Report Problem

'canned' BAQ to crystal reports??? This caught my interest - what
version
are you on? and what do you mean by 'canned'...

________________________________
From: Charlie Wilson <foamdesigncsw@ <mailto:foamdesigncsw%40yahoo.com>
yahoo.com>
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Sent: Wednesday, June 24, 2009 6:11:01 AM
Subject: [Vantage] BAQ Crystal Report Problem

All,

I have created a nice little report for our QA department that prints up
to
nice Corrective actions forms. But I have a problem when I run the
report
when I am remoted into the server it works perfectly but if I run it
from
any other machine it ask me to specify the location of the dataset and
enter
a username and password. Now my guess would be that crystal is getting
passed the location of the dataset (.xml file) in this format
c:\epicor\mfgsysdat a\reports\ username\ ****.xml instead of like this
\\servername\ epicor\mfgsysdat a\reports\ username\ ****.xml. The only
problem
is I can't figure out where the setting is to adjust this. Any ideas?

PS all of the "canned" BAQ to Crystal reports are working for us just
not
this one I have made.

~Charlie

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

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





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