1. PORel .dbf tables 2. Crystal Web Server

Thanks for the reply, Alan. I would love to hear if you get the Web Component running as a service and what the mysterious missing key is.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Alan Williams
To: Vantage@Egroups. Com
Sent: Tuesday, December 26, 2000 7:26 AM
Subject: [Vantage] Re: 1. PORel .dbf tables 2. Crystal Web Server


Troy,
Thanx for the reply. Sejoon Park beat Seagate to the punch by about
fifteen minutes in getting me the command line (Thanx Sejoon!). For anyone
who's curious, it's "C:\Program Files\Seagate
Software\WCS\pageserver.exe" -cache -deletecache -console. It works like a
charm. In addition to the command line, Seagate provided this tidbit:
"Your reports should run fine if you run the page server as a foreground
process. If it runs fine as a foreground process and not a service, that
means that your database client software only has the appropriate entry in
HKEY_CurrentUser and not in HKEY_LocalMachine."
But they didn't include the registry value! Augh! I'm gonna bug some
more today and see if I can get it running as a service. If I do, I'll post
back.


>> Date: Fri, 22 Dec 2000 17:33:25 -0800
> From: "Troy Funte" <tfunte@...>
>Subject: Re: RE:1. PORel .dbf tables 2. Crystal Web Server

Alan,

I believe the Seagate solution to 'loop around' (er, I mean workaround)
the looping logon is to run the Web Component from a command line, which
leaves the program running on your taskbar (instead of running it as a
service). But I know that somehow Ted Kitch has the thing running right on
the Vantage Server and has it running as a Service. I don't know how he
does it. The Seagate workaround works, but you have that thing on your
taskbar all the time. I can check the command line on Tuesday if you're
interested..

Troy

----- Original Message -----
From: Alan Williams
To: Vantage@Egroups. Com
Sent: Friday, December 22, 2000 6:05 AM
Subject: [Vantage] RE:1. PORel .dbf tables 2. Crystal Web Server


Anton,
I set up Crystal Web ServerThursday on a Win2000 machine, called the
sample
reports right the first time, thought, "Wow, that was easy", then built a
simple Part/PartBin report out of Vantage. Boom! There went my delusions
of
grandeur. I instantly got the infamous "Looping Logon". I rummaged
around
Seagate's support until I found this:
http://support.seagatesoftware.com/library/kbase/articles/c2006539.asp.
It
specifically addresses this. It also says to contact Progress tech
support,
who sent me an exerpt from their kbase dealing w/ environment variables.
I
tried their method w/ no result. I called back and the rep dug a little
deeper and found that they had referred everyone back to Seagate. That's
where I'm at right now. I'm holding in queue (your place: 1,459,217.
Serving: 3) If I have any luck, I'll post back.


Message: 8
Date: Fri, 22 Dec 2000 09:12:40 -0000
From: <it@...>
Subject: 1. PORel .dbf tables 2. Crystal Web Server

Troy,

many thanks for your input.

I have a VB Form on the Purchase Release Line that contains a checkbox
called "Suppress Print". It is possible for the Purchaser to tick this
after printing the PO, so that when that Release is closed, it will not
appear on the next Order placed on that PO.

Alternatively we can re-open that Release Line, tick Suppress Print, then
Close the Release again, although that is less tidy.

I'd need access to the PORel.OpenRelease field in an ideal world, but we
do
have the above workarounds.

Because it's one of the built-in reports, I can't do anything fancy like
creating my own .dbf files unfortunately, and ODBC... licensing issues!

I do use ODBC, but only on my machine and then the reports are distributed
over the intranet (for non-built-in reports).

We'll live with it for now I guess, hopefully the field will appear in the
super-duper sounding "eManufacturing"!

It surprises me that Epicor choose to leave ANY fields out when creating
the
...dbf's, surely they'd keep a lot of people happier if they included them
all...?

On a separate note, I'd love to hear how everybody is getting on with the
Crystal Web Component Server. Wonder how many Vantage users are taking
advantage of it? I think it's an incredible tool, and as soon as I can
sort
out the "refresh" option then I'm really getting somewhere on our
reporting
(currently it asks everyone to log on to the database, but I have no idea
what password and userid it is asking for - I've tried all of my
combinations!)


Well, time to get back to it.... and just in case this is my last mail of
the day to you all...


M E R R Y C H R I S T M A S ! ! !

;-)

Anton Wilson,
Systems Analyst,
Deanestor Healthcare

Thanx,
Alan


eGroups Sponsor


We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)



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

many thanks for your input.

I have a VB Form on the Purchase Release Line that contains a checkbox
called "Suppress Print". It is possible for the Purchaser to tick this
after printing the PO, so that when that Release is closed, it will not
appear on the next Order placed on that PO.

Alternatively we can re-open that Release Line, tick Suppress Print, then
Close the Release again, although that is less tidy.

I'd need access to the PORel.OpenRelease field in an ideal world, but we do
have the above workarounds.

Because it's one of the built-in reports, I can't do anything fancy like
creating my own .dbf files unfortunately, and ODBC... licensing issues!

I do use ODBC, but only on my machine and then the reports are distributed
over the intranet (for non-built-in reports).

We'll live with it for now I guess, hopefully the field will appear in the
super-duper sounding "eManufacturing"!

It surprises me that Epicor choose to leave ANY fields out when creating the
.dbf's, surely they'd keep a lot of people happier if they included them
all...?

On a seperate note, I'd love to hear how everybody is getting on with the
Crystal Web Component Server. Wonder how many Vantage users are taking
advantage of it? I think it's an incredible tool, and as soon as I can sort
out the "refresh" option then I'm really getting somewhere on our reporting
(currently it asks everyone to log on to the database, but I have no idea
what password and userid it is asking for - I've tried all of my
combinations!)


Well, time to get back to it.... and just in case this is my last mail of
the day to you all...


M E R R Y C H R I S T M A S ! ! !

;-)

Anton Wilson,
Systems Analyst,
Deanestor Healthcare
it@... wrote:
>
> Troy,
>
> many thanks for your input.
>
> I have a VB Form on the Purchase Release Line that contains a checkbox
> called "Suppress Print". It is possible for the Purchaser to tick this
> after printing the PO, so that when that Release is closed, it will not
> appear on the next Order placed on that PO.
>
> Alternatively we can re-open that Release Line, tick Suppress Print, then
> Close the Release again, although that is less tidy.
>
> I'd need access to the PORel.OpenRelease field in an ideal world, but we do
> have the above workarounds.
>
> Because it's one of the built-in reports, I can't do anything fancy like
> creating my own .dbf files unfortunately, and ODBC... licensing issues!
>
> I do use ODBC, but only on my machine and then the reports are distributed
> over the intranet (for non-built-in reports).
>
> We'll live with it for now I guess, hopefully the field will appear in the
> super-duper sounding "eManufacturing"!


I just checked and it's not there. It's hard to believe this hasn't
been included yet.
Anton,
I set up Crystal Web ServerThursday on a Win2000 machine, called the sample
reports right the first time, thought, "Wow, that was easy", then built a
simple Part/PartBin report out of Vantage. Boom! There went my delusions of
grandeur. I instantly got the infamous "Looping Logon". I rummaged around
Seagate's support until I found this:
http://support.seagatesoftware.com/library/kbase/articles/c2006539.asp. It
specifically addresses this. It also says to contact Progress tech support,
who sent me an exerpt from their kbase dealing w/ environment variables. I
tried their method w/ no result. I called back and the rep dug a little
deeper and found that they had referred everyone back to Seagate. That's
where I'm at right now. I'm holding in queue (your place: 1,459,217.
Serving: 3) If I have any luck, I'll post back.


Message: 8
Date: Fri, 22 Dec 2000 09:12:40 -0000
From: <it@...>
Subject: 1. PORel .dbf tables 2. Crystal Web Server

Troy,

many thanks for your input.

I have a VB Form on the Purchase Release Line that contains a checkbox
called "Suppress Print". It is possible for the Purchaser to tick this
after printing the PO, so that when that Release is closed, it will not
appear on the next Order placed on that PO.

Alternatively we can re-open that Release Line, tick Suppress Print, then
Close the Release again, although that is less tidy.

I'd need access to the PORel.OpenRelease field in an ideal world, but we do
have the above workarounds.

Because it's one of the built-in reports, I can't do anything fancy like
creating my own .dbf files unfortunately, and ODBC... licensing issues!

I do use ODBC, but only on my machine and then the reports are distributed
over the intranet (for non-built-in reports).

We'll live with it for now I guess, hopefully the field will appear in the
super-duper sounding "eManufacturing"!

It surprises me that Epicor choose to leave ANY fields out when creating the
...dbf's, surely they'd keep a lot of people happier if they included them
all...?

On a separate note, I'd love to hear how everybody is getting on with the
Crystal Web Component Server. Wonder how many Vantage users are taking
advantage of it? I think it's an incredible tool, and as soon as I can sort
out the "refresh" option then I'm really getting somewhere on our reporting
(currently it asks everyone to log on to the database, but I have no idea
what password and userid it is asking for - I've tried all of my
combinations!)


Well, time to get back to it.... and just in case this is my last mail of
the day to you all...


M E R R Y C H R I S T M A S ! ! !

;-)

Anton Wilson,
Systems Analyst,
Deanestor Healthcare




Thanx,
Alan Williams
Alan,

I believe the Seagate solution to 'loop around' (er, I mean workaround) the looping logon is to run the Web Component from a command line, which leaves the program running on your taskbar (instead of running it as a service). But I know that somehow Ted Kitch has the thing running right on the Vantage Server and has it running as a Service. I don't know how he does it. The Seagate workaround works, but you have that thing on your taskbar all the time. I can check the command line on Tuesday if you're interested.

Troy

----- Original Message -----
From: Alan Williams
To: Vantage@Egroups. Com
Sent: Friday, December 22, 2000 6:05 AM
Subject: [Vantage] RE:1. PORel .dbf tables 2. Crystal Web Server


Anton,
I set up Crystal Web ServerThursday on a Win2000 machine, called the sample
reports right the first time, thought, "Wow, that was easy", then built a
simple Part/PartBin report out of Vantage. Boom! There went my delusions of
grandeur. I instantly got the infamous "Looping Logon". I rummaged around
Seagate's support until I found this:
http://support.seagatesoftware.com/library/kbase/articles/c2006539.asp. It
specifically addresses this. It also says to contact Progress tech support,
who sent me an exerpt from their kbase dealing w/ environment variables. I
tried their method w/ no result. I called back and the rep dug a little
deeper and found that they had referred everyone back to Seagate. That's
where I'm at right now. I'm holding in queue (your place: 1,459,217.
Serving: 3) If I have any luck, I'll post back.


Message: 8
Date: Fri, 22 Dec 2000 09:12:40 -0000
From: <it@...>
Subject: 1. PORel .dbf tables 2. Crystal Web Server

Troy,

many thanks for your input.

I have a VB Form on the Purchase Release Line that contains a checkbox
called "Suppress Print". It is possible for the Purchaser to tick this
after printing the PO, so that when that Release is closed, it will not
appear on the next Order placed on that PO.

Alternatively we can re-open that Release Line, tick Suppress Print, then
Close the Release again, although that is less tidy.

I'd need access to the PORel.OpenRelease field in an ideal world, but we do
have the above workarounds.

Because it's one of the built-in reports, I can't do anything fancy like
creating my own .dbf files unfortunately, and ODBC... licensing issues!

I do use ODBC, but only on my machine and then the reports are distributed
over the intranet (for non-built-in reports).

We'll live with it for now I guess, hopefully the field will appear in the
super-duper sounding "eManufacturing"!

It surprises me that Epicor choose to leave ANY fields out when creating the
...dbf's, surely they'd keep a lot of people happier if they included them
all...?

On a separate note, I'd love to hear how everybody is getting on with the
Crystal Web Component Server. Wonder how many Vantage users are taking
advantage of it? I think it's an incredible tool, and as soon as I can sort
out the "refresh" option then I'm really getting somewhere on our reporting
(currently it asks everyone to log on to the database, but I have no idea
what password and userid it is asking for - I've tried all of my
combinations!)


Well, time to get back to it.... and just in case this is my last mail of
the day to you all...


M E R R Y C H R I S T M A S ! ! !

;-)

Anton Wilson,
Systems Analyst,
Deanestor Healthcare




Thanx,
Alan Williams


eGroups Sponsor


We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)



[Non-text portions of this message have been removed]
Troy,
Thanx for the reply. Sejoon Park beat Seagate to the punch by about
fifteen minutes in getting me the command line (Thanx Sejoon!). For anyone
who's curious, it's "C:\Program Files\Seagate
Software\WCS\pageserver.exe" -cache -deletecache -console. It works like a
charm. In addition to the command line, Seagate provided this tidbit:
"Your reports should run fine if you run the page server as a foreground
process. If it runs fine as a foreground process and not a service, that
means that your database client software only has the appropriate entry in
HKEY_CurrentUser and not in HKEY_LocalMachine."
But they didn't include the registry value! Augh! I'm gonna bug some
more today and see if I can get it running as a service. If I do, I'll post
back.


>> Date: Fri, 22 Dec 2000 17:33:25 -0800
> From: "Troy Funte" <tfunte@...>
>Subject: Re: RE:1. PORel .dbf tables 2. Crystal Web Server

Alan,

I believe the Seagate solution to 'loop around' (er, I mean workaround)
the looping logon is to run the Web Component from a command line, which
leaves the program running on your taskbar (instead of running it as a
service). But I know that somehow Ted Kitch has the thing running right on
the Vantage Server and has it running as a Service. I don't know how he
does it. The Seagate workaround works, but you have that thing on your
taskbar all the time. I can check the command line on Tuesday if you're
interested..

Troy

----- Original Message -----
From: Alan Williams
To: Vantage@Egroups. Com
Sent: Friday, December 22, 2000 6:05 AM
Subject: [Vantage] RE:1. PORel .dbf tables 2. Crystal Web Server


Anton,
I set up Crystal Web ServerThursday on a Win2000 machine, called the
sample
reports right the first time, thought, "Wow, that was easy", then built a
simple Part/PartBin report out of Vantage. Boom! There went my delusions
of
grandeur. I instantly got the infamous "Looping Logon". I rummaged
around
Seagate's support until I found this:
http://support.seagatesoftware.com/library/kbase/articles/c2006539.asp.
It
specifically addresses this. It also says to contact Progress tech
support,
who sent me an exerpt from their kbase dealing w/ environment variables.
I
tried their method w/ no result. I called back and the rep dug a little
deeper and found that they had referred everyone back to Seagate. That's
where I'm at right now. I'm holding in queue (your place: 1,459,217.
Serving: 3) If I have any luck, I'll post back.


Message: 8
Date: Fri, 22 Dec 2000 09:12:40 -0000
From: <it@...>
Subject: 1. PORel .dbf tables 2. Crystal Web Server

Troy,

many thanks for your input.

I have a VB Form on the Purchase Release Line that contains a checkbox
called "Suppress Print". It is possible for the Purchaser to tick this
after printing the PO, so that when that Release is closed, it will not
appear on the next Order placed on that PO.

Alternatively we can re-open that Release Line, tick Suppress Print, then
Close the Release again, although that is less tidy.

I'd need access to the PORel.OpenRelease field in an ideal world, but we
do
have the above workarounds.

Because it's one of the built-in reports, I can't do anything fancy like
creating my own .dbf files unfortunately, and ODBC... licensing issues!

I do use ODBC, but only on my machine and then the reports are distributed
over the intranet (for non-built-in reports).

We'll live with it for now I guess, hopefully the field will appear in the
super-duper sounding "eManufacturing"!

It surprises me that Epicor choose to leave ANY fields out when creating
the
...dbf's, surely they'd keep a lot of people happier if they included them
all...?

On a separate note, I'd love to hear how everybody is getting on with the
Crystal Web Component Server. Wonder how many Vantage users are taking
advantage of it? I think it's an incredible tool, and as soon as I can
sort
out the "refresh" option then I'm really getting somewhere on our
reporting
(currently it asks everyone to log on to the database, but I have no idea
what password and userid it is asking for - I've tried all of my
combinations!)


Well, time to get back to it.... and just in case this is my last mail of
the day to you all...


M E R R Y C H R I S T M A S ! ! !

;-)

Anton Wilson,
Systems Analyst,
Deanestor Healthcare

Thanx,
Alan