Report Builder question

Yahoo Archive
1
Hi, all!

Quick question.....is there an easy way to convert the time for a RB report
from military to "normal" time????

Thanks!

Tricia
2
I admit I am lazy to figure this out, but if anyone has done this please
help me out.

I am trying to figure out how I can get a report (filtered by dates) to be
filtered by months. Right now my quality man has to enter the beginning
date of the month and the ending date of the month to get information.
Instead of doing this for each month, he wants to list each month and get
all 12 months on the same report instead of separate reports.

Anyone willing to share their secrets with me?

Thanks in advance,

Manasa Reddy
3
I believe if you make a calculated field containing the text

month( [datefield] )

and group based on that formula, then sort by date, that should do the
trick.

-----Original Message-----
From: Manasa Reddy [mailto:mreddy@...]
Sent: Thursday, September 20, 2001 10:03 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Report Builder question


I admit I am lazy to figure this out, but if anyone has done this please
help me out.

I am trying to figure out how I can get a report (filtered by dates) to be
filtered by months. Right now my quality man has to enter the beginning
date of the month and the ending date of the month to get information.
Instead of doing this for each month, he wants to list each month and get
all 12 months on the same report instead of separate reports.

Anyone willing to share their secrets with me?

Thanks in advance,

Manasa Reddy



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
4
If the month end date is always the actual last date of the month then...
You can extract the month from a date using the MONTH(date) function.
Various combinations of using string functions and DATE(chr) can create
various dates and ranges.

You can get the date of the last day of a month by subtracting 1 from the
date of the first of the next month
Example: Last-Day-Sep = 10/01/2001 - 1
This takes care of figuring out how many days are in a month without using a
CASE or nested IFs

-Todd C.

-----Original Message-----
From: Manasa Reddy [mailto:mreddy@...]
Sent: Thursday, September 20, 2001 10:03 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Report Builder question


I admit I am lazy to figure this out, but if anyone has done this please
help me out.

I am trying to figure out how I can get a report (filtered by dates) to be
filtered by months. Right now my quality man has to enter the beginning
date of the month and the ending date of the month to get information.
Instead of doing this for each month, he wants to list each month and get
all 12 months on the same report instead of separate reports.

Anyone willing to share their secrets with me?

Thanks in advance,

Manasa Reddy



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=194081.1566666.3122752.1261774/D=egroupweb/S=17050071
83:HM/A=793313/R=1/*http://www.ediets.com/start.cfm?code=3256>


<http://rd.yahoo.com/M=194081.1566666.3122752.1261774/D=egroupweb/S=17050071
83:HM/A=793313/R=2/*http://www.ediets.com/start.cfm?code=3256>

<http://us.adserver.yahoo.com/l?M=194081.1566666.3122752.1261774/D=egroupmai
l/S=1705007183:HM/A=793313/rand=251339335>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
5
Create a calculated field using MONTH(date) with your target date in the
parenthases, this will give you the numeric value of that dates month. Next
use the YEAR(DATE) to generate the year of the date, 09/11/01 would be 2001.
Group and sort on year then group and sort on your calculated field. Then
filter out the year you want. IE cacluated field YEAR = 2001

Shirley H. Graver
(End User)
Systems Administrator
Rubber Associates Inc.

-----Original Message-----
From: Manasa Reddy [mailto:mreddy@...]
Sent: Thursday, September 20, 2001 11:03 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Report Builder question

I admit I am lazy to figure this out, but if anyone has done this please
help me out.

I am trying to figure out how I can get a report (filtered by dates) to be
filtered by months. Right now my quality man has to enter the beginning
date of the month and the ending date of the month to get information.
Instead of doing this for each month, he wants to list each month and get
all 12 months on the same report instead of separate reports.

Anyone willing to share their secrets with me?

Thanks in advance,

Manasa Reddy




Yahoo! Groups Sponsor
ADVERTISEMENT

<http://rd.yahoo.com/M=194081.1566666.3122752.1261774/D=egroupweb/S=17050071
83:HM/A=793313/R=1/*http://www.ediets.com/start.cfm?code=3256>
<http://rd.yahoo.com/M=194081.1566666.3122752.1261774/D=egroupweb/S=17050071
83:HM/A=793313/R=2/*http://www.ediets.com/start.cfm?code=3256>



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .


[Non-text portions of this message have been removed]
6
Thanks for the suggestions, guys! I'll give them a try!

Manasa Reddy
7
I have a report that provides information for all PO Release lines issued to
a job or project. I have a calculated field for ordered quantity less
received quantity to let us know the open quantity for any given PO Release.
I would like this calculated field to be bold for any results >= 0, to
highlight the open releases. Could anyone offer a suggestion of how to do
this in Report Builder?

Also, in trying to accomplish this task, I wanted to use an "if" statement
like
If {field >= 0,field,""}
In other words, if the field is >= 0, print the field, otherwise print
nothing. Report Builder tells me it is an invalid argument. Where am I
goofing up with this statement?
Thanks,
Nora Story
Spectra Technologies, Inc.
Nora_Story@...
8
For the 2nd part of your question, since the field is a numerica field, I
don't think report builder will let you print a blank. You probably have to
print ?, i.e. Iff(field >= 0,field,?).

On the first part of the question, you know there is an 'open release'
field, you can use that. You would set-up 2 record lines, containing the
same information. Bold each field on the 2nd line. Then go to 'band line
properties' and 'print conditional field' and check 'enable conditional
printing' for the first record line. Choose the porel.openrel field and
click 'print when field is false or unknown. Then do the same for the
bolded line, except choose, print when field is true.



[Non-text portions of this message have been removed]
9
Part 1) create two calculated fields, one when the results are > 0, the
other <= zero. Format the first one to BOLD print. Place one ontop of the
other in the report.

Part 2) just change the fields format to ">>>>>>" instead of ">>>>>9" if you
don't want it to display.

Patrick Winter


-----Original Message-----
From: Nora Story [mailto:Nora_Story@...]
Sent: Thursday, March 13, 2003 10:07 AM
To: vantage@yahoogroups. Com
Subject: [Vantage] Report Builder question


I have a report that provides information for all PO Release lines issued to
a job or project. I have a calculated field for ordered quantity less
received quantity to let us know the open quantity for any given PO Release.
I would like this calculated field to be bold for any results >= 0, to
highlight the open releases. Could anyone offer a suggestion of how to do
this in Report Builder?

Also, in trying to accomplish this task, I wanted to use an "if" statement
like
If {field >= 0,field,""}
In other words, if the field is >= 0, print the field, otherwise print
nothing. Report Builder tells me it is an invalid argument. Where am I
goofing up with this statement? Thanks, Nora Story Spectra Technologies,
Inc. Nora_Story@...


------------------------ Yahoo! Groups Sponsor ---------------------~--> Get
128 Bit SSL Encryption!
http://us.click.yahoo.com/xaxhjB/hdqFAA/xGHJAA/PhFolB/TM
---------------------------------------------------------------------~->

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
10
Another way I do this is to make two versions of the field (depending on condition) and convert them to string (with appropriate formatting symbols) and each version will have eith erht etrue or false condition be all spaces. Then format one field BOLD (or color or larger, etc...) and place them right on top of each other. Bold spaces are invisible.
-Todd C.

-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Thursday, March 13, 2003 9:54 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder question


For the 2nd part of your question, since the field is a numerica field, I
don't think report builder will let you print a blank. You probably have to
print ?, i.e. Iff(field >= 0,field,?).

On the first part of the question, you know there is an 'open release'
field, you can use that. You would set-up 2 record lines, containing the
same information. Bold each field on the 2nd line. Then go to 'band line
properties' and 'print conditional field' and check 'enable conditional
printing' for the first record line. Choose the porel.openrel field and
click 'print when field is false or unknown. Then do the same for the
bolded line, except choose, print when field is true.



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



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/M=246920.2960106.4328965.2848452/D=egroupweb/S=1705007183:HM/A=1481646/R=0/*http://www.gotomypc.com/u/tr/yh/cpm/grp/300_flake/g22lp?Target=mm/g22lp.tmpl>
<http://us.adserver.yahoo.com/l?M=246920.2960106.4328965.2848452/D=egroupmail/S=:HM/A=1481646/rand=993935430>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
11
Need ideas from all you experts out there! ;)

Trying to write a report which will list all the inventory items by part
number with their respective bin location. Problem I run into is for those
items with zero balance at the moment. Can't figure out how to get it to
print the bin location rather than a "?". Can anyone help??????
Please????????????

TIA!

Tricia Simon, Controller
Riten Industries, Inc.
12
In my experience, a '?' only shows up when the value is unknown. Make sure
that those parts have a bin associated with them.

Jim Selinger
Kocsis Bros. Machine Co.
11755 S. Austin Avenue / 4321 Railroad Avenue
Alsip, IL 60803 / East Chicago, IN 46312

Phone: (708) 597-8110
Fax: (708) 389-0792

-----Original Message-----
From: Tricia Simon [mailto:t.simon@...]
Sent: Tuesday, September 09, 2003 5:49 AM
To: Vantage One-List (E-mail)
Subject: [Vantage] Report Builder question


Need ideas from all you experts out there! ;)

Trying to write a report which will list all the inventory items by part
number with their respective bin location. Problem I run into is for those
items with zero balance at the moment. Can't figure out how to get it to
print the bin location rather than a "?". Can anyone help??????
Please????????????

TIA!

Tricia Simon, Controller
Riten Industries, Inc.



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=251812.3856299.5103760.1261774/D=egroupweb/S=17050071
83:HM/A=1754451/R=0/SIG=11tkldm5d/*http://www.netflix.com/Default?mqso=60178
323&partid=3856299> click here

<http://us.adserver.yahoo.com/l?M=251812.3856299.5103760.1261774/D=egroupmai
l/S=:HM/A=1754451/rand=686077256>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
13
Do you mean default bin location rather than "?" because if the inventory is
zero there is no bin location their fore you get "?" meaning no bin record
available.


Patrick Winter


-----Original Message-----
From: Tricia Simon [mailto:t.simon@...]
Sent: Tuesday, September 09, 2003 6:49 AM
To: Vantage One-List (E-mail)
Subject: [Vantage] Report Builder question


Need ideas from all you experts out there! ;)

Trying to write a report which will list all the inventory items by part
number with their respective bin location. Problem I run into is for those
items with zero balance at the moment. Can't figure out how to get it to
print the bin location rather than a "?". Can anyone help??????
Please????????????

TIA!

Tricia Simon, Controller
Riten Industries, Inc.



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
14
Coming back to the wise ones for another question! ;)

I have several reports from RB linked into Vantage via Custom Report Link.

Something has happened...not sure what. It seems the other users don't have
a problem; however, when I try to use any of them, I get the following
error - "unable to open convmap file 'e:\epic51\progress\convmap.cp' ". To
add insult to injury....I'm the one that writes the reports and links
them!!! ;( They used to work! ;(

We had to reload Vantage....wondering if possibly that did something???????

Any help....much appreciated.

BTW....please don't get too technical on me.....I'm one of those dreaded
bean counters! ;)

Thanks all!

Tricia Simon, Controller
Riten Industries, Inc.
15
Someone posted the following info from the Epicor site sometime back. I dug it out of the archives. Perhaps something in here will help point to a solution?
-Todd C.
----------------------------------------------------------
Summary: RB, unable to open convmap with custom report links
Book: Support Solutions
Page: 1229MPS

XA 5.00

Problem: Opening custom report links in Vantage generates error: unable
to
open convmap

Resolution: Vantage 5.00 no longer uses the registry to connect to
report
builder

1.) Open the report builder.vtg and edit the "other parameters" line it
should look like this, with reference to the proper mapped drive and
server:

[Vantage Startup]
Executable=V:\Progress\bin\prorb32.exe
Database=V:\Vantage\db\vantage
IniFile=V:\Vantage\Vantage.ini
ParameterFile=V:\Vantage\db\Vantage.pf
ConnectOptions=-N TCP -H mntech -S epic50
TempDirectory=C:\Vntg50
StartupProcedure=
OtherParameters=

Note: the 'OtherParameters=' line is blanked out

Apparently this causes no problem with the database engine because it
uses
the registry so. You will also need to edit the
progress\Bin\progress.ini
to reference the mapped drive path instead of the physical drive path.
The
startup section should look something like this:

[Startup]
V6Display=no
;ImmediateDisplay=yes
;MultitaskingInterval=100
DefaultFont=MS Sans Serif, size=8
DefaultFixedFont=Courier New, size=8
DLC=V:\progress
Use-3D-Size=Yes
PROBUILD=V:\progress\PROBUILD
PROPATH=.,V:\progress\gui,V:\progress,V:\progress\bin,V:\progress\PROBUILD\E

UCAPP\EUC.PL,V:\progress\PROBUILD\EUCAPP
UseSourceEditor=yes
EditorConfigPath=V:\prowork\proedit

Where V is a mapped drive.
Pay special attention to the DLC path, that it says V:\progress, NOT
V:\epic50\progress

XA 5.00



-----Original Message-----
From: Tricia Simon [mailto:t.simon@...]
Sent: Friday, January 09, 2004 2:06 PM
To: Vantage One-List (E-mail)
Subject: [Vantage] Report Builder question


Coming back to the wise ones for another question! ;)

I have several reports from RB linked into Vantage via Custom Report Link.

Something has happened...not sure what. It seems the other users don't have
a problem; however, when I try to use any of them, I get the following
error - "unable to open convmap file 'e:\epic51\progress\convmap.cp' ". To
add insult to injury....I'm the one that writes the reports and links
them!!! ;( They used to work! ;(

We had to reload Vantage....wondering if possibly that did something???????

Any help....much appreciated.

BTW....please don't get too technical on me.....I'm one of those dreaded
bean counters! ;)

Thanks all!

Tricia Simon, Controller
Riten Industries, Inc.



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




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

OK...finally finished year-end, so I have time to look into this further.
We are on 5.1 - don't know if this still applies. Also....I warned you I
wasn't the techie!....where do I find the text to edit????? This seems to
be just on my terminal...all others are working fine.

Appreciate any and all help.....no time to make more of a mess! ;)

Thanks!

Tricia


-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Friday, January 09, 2004 3:21 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder question


Someone posted the following info from the Epicor site sometime back. I dug
it out of the archives. Perhaps something in here will help point to a
solution?
-Todd C.
----------------------------------------------------------
Summary: RB, unable to open convmap with custom report links
Book: Support Solutions
Page: 1229MPS

XA 5.00

Problem: Opening custom report links in Vantage generates error: unable
to
open convmap

Resolution: Vantage 5.00 no longer uses the registry to connect to
report
builder

1.) Open the report builder.vtg and edit the "other parameters" line it
should look like this, with reference to the proper mapped drive and
server:

[Vantage Startup]
Executable=V:\Progress\bin\prorb32.exe
Database=V:\Vantage\db\vantage
IniFile=V:\Vantage\Vantage.ini
ParameterFile=V:\Vantage\db\Vantage.pf
ConnectOptions=-N TCP -H mntech -S epic50
TempDirectory=C:\Vntg50
StartupProcedure=
OtherParameters=

Note: the 'OtherParameters=' line is blanked out

Apparently this causes no problem with the database engine because it
uses
the registry so. You will also need to edit the
progress\Bin\progress.ini
to reference the mapped drive path instead of the physical drive path.
The
startup section should look something like this:

[Startup]
V6Display=no
;ImmediateDisplay=yes
;MultitaskingInterval=100
DefaultFont=MS Sans Serif, size=8
DefaultFixedFont=Courier New, size=8
DLC=V:\progress
Use-3D-Size=Yes
PROBUILD=V:\progress\PROBUILD
PROPATH=.,V:\progress\gui,V:\progress,V:\progress\bin,V:\progress\PROBUILD\E

UCAPP\EUC.PL,V:\progress\PROBUILD\EUCAPP
UseSourceEditor=yes
EditorConfigPath=V:\prowork\proedit

Where V is a mapped drive.
Pay special attention to the DLC path, that it says V:\progress, NOT
V:\epic50\progress

XA 5.00



-----Original Message-----
From: Tricia Simon [mailto:t.simon@...]
Sent: Friday, January 09, 2004 2:06 PM
To: Vantage One-List (E-mail)
Subject: [Vantage] Report Builder question


Coming back to the wise ones for another question! ;)

I have several reports from RB linked into Vantage via Custom Report Link.

Something has happened...not sure what. It seems the other users don't have
a problem; however, when I try to use any of them, I get the following
error - "unable to open convmap file 'e:\epic51\progress\convmap.cp' ". To
add insult to injury....I'm the one that writes the reports and links
them!!! ;( They used to work! ;(

We had to reload Vantage....wondering if possibly that did something???????

Any help....much appreciated.

BTW....please don't get too technical on me.....I'm one of those dreaded
bean counters! ;)

Thanks all!

Tricia Simon, Controller
Riten Industries, Inc.



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




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


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/



[Non-text portions of this message have been removed]
17
I wasn't really familiar with this issue. I just found a reference to it in a search of the old group messages.

One other thought I had - in case you have not tried it yet would be to re-install Vantage Client (with report builder checked) on your PC. Ichecked for this and there is an answerbook case about drive letters. By chance did your PC once use a different mapped drive letter to reference the EPIC50 folder's drive on the server? Uninstall Vantage Client from your PC and re-install it and perhaps it will fix the drive letter reference in the registry. Just a wild guess but since it is only your PC the problem may be in the local registry entries.

-Todd C.

-----Original Message-----
From: Tricia Simon [mailto:t.simon@...]
Sent: Friday, January 23, 2004 3:41 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder question



Todd,

OK...finally finished year-end, so I have time to look into this further.
We are on 5.1 - don't know if this still applies. Also....I warned you I
wasn't the techie!....where do I find the text to edit????? This seems to
be just on my terminal...all others are working fine.

Appreciate any and all help.....no time to make more of a mess! ;)

Thanks!

Tricia


-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Friday, January 09, 2004 3:21 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder question


Someone posted the following info from the Epicor site sometime back. I dug
it out of the archives. Perhaps something in here will help point to a
solution?
-Todd C.
----------------------------------------------------------
Summary: RB, unable to open convmap with custom report links
Book: Support Solutions
Page: 1229MPS

XA 5.00

Problem: Opening custom report links in Vantage generates error: unable
to
open convmap

Resolution: Vantage 5.00 no longer uses the registry to connect to
report
builder

1.) Open the report builder.vtg and edit the "other parameters" line it
should look like this, with reference to the proper mapped drive and
server:

[Vantage Startup]
Executable=V:\Progress\bin\prorb32.exe
Database=V:\Vantage\db\vantage
IniFile=V:\Vantage\Vantage.ini
ParameterFile=V:\Vantage\db\Vantage.pf
ConnectOptions=-N TCP -H mntech -S epic50
TempDirectory=C:\Vntg50
StartupProcedure=
OtherParameters=

Note: the 'OtherParameters=' line is blanked out

Apparently this causes no problem with the database engine because it
uses
the registry so. You will also need to edit the
progress\Bin\progress.ini
to reference the mapped drive path instead of the physical drive path.
The
startup section should look something like this:

[Startup]
V6Display=no
;ImmediateDisplay=yes
;MultitaskingInterval=100
DefaultFont=MS Sans Serif, size=8
DefaultFixedFont=Courier New, size=8
DLC=V:\progress
Use-3D-Size=Yes
PROBUILD=V:\progress\PROBUILD
PROPATH=.,V:\progress\gui,V:\progress,V:\progress\bin,V:\progress\PROBUILD\E

UCAPP\EUC.PL,V:\progress\PROBUILD\EUCAPP
UseSourceEditor=yes
EditorConfigPath=V:\prowork\proedit

Where V is a mapped drive.
Pay special attention to the DLC path, that it says V:\progress, NOT
V:\epic50\progress

XA 5.00



-----Original Message-----
From: Tricia Simon [mailto:t.simon@...]
Sent: Friday, January 09, 2004 2:06 PM
To: Vantage One-List (E-mail)
Subject: [Vantage] Report Builder question


Coming back to the wise ones for another question! ;)

I have several reports from RB linked into Vantage via Custom Report Link.

Something has happened...not sure what. It seems the other users don't have
a problem; however, when I try to use any of them, I get the following
error - "unable to open convmap file 'e:\epic51\progress\convmap.cp' ". To
add insult to injury....I'm the one that writes the reports and links
them!!! ;( They used to work! ;(

We had to reload Vantage....wondering if possibly that did something???????

Any help....much appreciated.

BTW....please don't get too technical on me.....I'm one of those dreaded
bean counters! ;)

Thanks all!

Tricia Simon, Controller
Riten Industries, Inc.



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
< http://docs.yahoo.com/info/terms/> .




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


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/



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



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
18
Hey All
Is it possible to write a report that would compare last years
Part.StdMaterialCost with the current Part.StdMaterialCost. I'm drawing a
blank. If you give a date range for 2003 to pick up last years cost how do
you get the current cost ?? I'm sure someone has figured it out.

Cliff Drumeller
IT Manager
Mass Precision Sheetmetal
408 954 0200 x 217
19
You could try having to fields right next to each other. Both fields would be the part.stdmaterial cost.

Then have a calculation to sum up each field but also have a stipulation that takes the date into account.

See if that works,
Jasper

-----Original Message-----
From: Cliff Drumeller [mailto:cliff@...]
Sent: Wednesday, April 07, 2004 10:04 AM
To: VantageGroup (E-mail)
Subject: [Vantage] Report Builder question


Hey All
Is it possible to write a report that would compare last years
Part.StdMaterialCost with the current Part.StdMaterialCost. I'm drawing a
blank. If you give a date range for 2003 to pick up last years cost how do
you get the current cost ?? I'm sure someone has figured it out.

Cliff Drumeller
IT Manager
Mass Precision Sheetmetal
408 954 0200 x 217




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
20
Cliff,

Forget my last email, I was thinking it was a different field. I'm not sure how you could do it.

Jasper

-----Original Message-----
From: Cliff Drumeller [mailto:cliff@...]
Sent: Wednesday, April 07, 2004 10:04 AM
To: VantageGroup (E-mail)
Subject: [Vantage] Report Builder question


Hey All
Is it possible to write a report that would compare last years
Part.StdMaterialCost with the current Part.StdMaterialCost. I'm drawing a
blank. If you give a date range for 2003 to pick up last years cost how do
you get the current cost ?? I'm sure someone has figured it out.

Cliff Drumeller
IT Manager
Mass Precision Sheetmetal
408 954 0200 x 217




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links