Crystal Help

Yahoo Archive
1
I need to add a Vantage basic field from my Customer Table to my
Crystal Reports Packing Slip. The Ship head Table contains the CUSTID
as well as the CUSTNUM. Linking these fields does not work, however.
I'm assuming because of the join type. When I go into Visual Linking,
the Join types are grayed out. Can anybody tell why this is and or
how to correct this?

Thanks,
Les
2
What Rick said is very true! I have spent a great deal of time
working on modifying the Vantage Crystal Reports to include
additional data not supplied in the DBF files created by the Vantage
application. The problem here is that the DBF's use a different
database driver than ODBC does and Crystal will only allow the use of
one driver at a time. The ONLY STABLE WAY that I found to include
additional data was to use a subreport in the modified Vantage
Crystal report to display the additional data from the Progress
tables. Using this method you can print the report without any
additional steps so it is invisible to the end user. You can make
this subreport as small as you want in the main report so it displays
just one field and it just looks like any other field in the report.
The subreport will allow you to use a different driver (ODBC driver)
than the one used in the main report (XBASE Driver). Two things that
you should know:
1. It will take slightly longer to print a report that contains a
subreport.
2. ODBC must be installed on every workstation that will print the
report.
Our shop travelers actually have 3 subreports within the main report
that allow us to include the primary bin for the part, the bin
locations and bin quantities of the raw material components and any
salvage parts and their bin locations. I have several reports that I
have modified this way and it works great. I hope this wasn't too
confusing. We are using Vantage 3.00.632 and Crystal 7. Any
questions feel free to contact me directly.

-----Original Message-----
Date: Wed, 16 Aug 2000 10:25:59 -0400
From: Rick Lane <rickl@...>
Subject: RE: Crystal Help

I assume that you are trying to link these tables to the customer
master
table via ODBC? If you are you may want to give up now. Linking the
standard Vantage reports to the actual Progress tables via ODBC is
extremely
flaky at best, and I have never been able to link it to more than one
table.

Two other solutions to consider:

1) Re-write the packing slip in complete ODBC (creates some of it's
own
problems).

2) Better yet, create a VBForm field in the packing slip header that
contains fields you need printed on the packing slip. Create a
button on
the VBForm that calls a simply Progress procedure to copy the VBForm
fields
from the customer master table into the VBForm in the packing slip
header.
These fields are then readily available for printing on the standard
packing
slip.


-----Original Message-----
Date: Wed, 16 Aug 2000 12:47:02 -0000
From: "Les Tingley" <ltingley@...>
Subject: Crystal Help

I need to add a Vantage basic field from my Customer Table to my
Crystal Reports Packing Slip. The Ship head Table contains the CUSTID
as well as the CUSTNUM. Linking these fields does not work, however.
I'm assuming because of the join type. When I go into Visual Linking,
the Join types are grayed out. Can anybody tell why this is and or
how to correct this?

Thanks,
Les
3
I am in the process of setting up some new customer required
reports. I added a VB form to Part and added a character box to use
as a sort and selection method. In Crystal, it will not allow me to
select the "Character02" field as a selection method. If I try to
use the field in a formula, I get the message "Blob field or memo
field cannot be used in a formula."

My overall goal is to get summarized data into an Access Database so
that I can append it to the customers form. I know I can use report
builder to get at the data that I am trying to create but that also
requires a Excel Macro for each report that I build to get it into
Access. Since we are having to provide this data weekly, I want to
be able to hand this off to someone else.

Any info would greatly be appreciated.

Thanks

Paul B. Springfield
Director of Finance

Karlee Company
4
It depends on which version of Vantage and Crystal you are using. In
Vantage 4.0 with Crystal 7.0 using the Merant ODBC driver, Epicor had
instructions to change the size of the field (make it 256 characters instead
of 1000) in the database and then Crystal could recognize it for formulas.

It doesn't seem to work with the SQL 92 driver used with Vantage 5.1 and
Crystal 8.0.

The only way we've been able to get around the problem is to write the
report in Report Builder. It is able to handle the "blob/memo" fields.

Sue Howard
Information Specialist
Image National, Inc.
(208) 287-1904
sueh@...

-----Original Message-----
From: karleembnqa00 [mailto:pspringfield@...]
Sent: Wednesday, August 14, 2002 9:34 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Help


I am in the process of setting up some new customer required
reports. I added a VB form to Part and added a character box to use
as a sort and selection method. In Crystal, it will not allow me to
select the "Character02" field as a selection method. If I try to
use the field in a formula, I get the message "Blob field or memo
field cannot be used in a formula."

My overall goal is to get summarized data into an Access Database so
that I can append it to the customers form. I know I can use report
builder to get at the data that I am trying to create but that also
requires a Excel Macro for each report that I build to get it into
Access. Since we are having to provide this data weekly, I want to
be able to hand this off to someone else.

Any info would greatly be appreciated.

Thanks

Paul B. Springfield
Director of Finance

Karlee Company



Yahoo! Groups Sponsor

ADVERTISEMENT


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
Hi Paul,
You may want to use a combination of Progress code, and MS Access to do
this. I have similar situations where I use two buttons on an Access
Switchboard. The first button calls the progress program to export the data
to a .csv file. The .csv file is linked to an Access table. The second
button opens the report with the updated data. I can supply you with the
code to export the Part Table to a .csv file, and help you with MS Access if
you need it. Once in place, it's a pretty easy tool for the end user.

Note: The Progress code comes from the help, and generousity of people from
this group.
I've been wanting to find the time to find a way to eliminate the
need for the update button, and for that matter the whole
Switchboard. I can launch the update from an autoexec macro, but
the report tries to open before the records have been
updated. I'm sure there has to be a way to keep the report from
opening before the records are updated. Does anybody
know how to do this?

> -----Original Message-----
> From: karleembnqa00 [SMTP:pspringfield@...]
> Sent: Wednesday, August 14, 2002 11:34 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal Help
>
> I am in the process of setting up some new customer required
> reports. I added a VB form to Part and added a character box to use
> as a sort and selection method. In Crystal, it will not allow me to
> select the "Character02" field as a selection method. If I try to
> use the field in a formula, I get the message "Blob field or memo
> field cannot be used in a formula."
>
> My overall goal is to get summarized data into an Access Database so
> that I can append it to the customers form. I know I can use report
> builder to get at the data that I am trying to create but that also
> requires a Excel Macro for each report that I build to get it into
> Access. Since we are having to provide this data weekly, I want to
> be able to hand this off to someone else.
>
> Any info would greatly be appreciated.
>
> Thanks
>
> Paul B. Springfield
> Director of Finance
>
> Karlee Company
>
>
>
> 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/
>
6
I launch my access reports from Vantage. The .r file I used to launch my
Access reports runs any Progress Code I need to export the data before it
opens the Access database.
Jeremy Leonard
IT Manager
K-T Corporation


-----Original Message-----
From: Les Tingley [mailto:ltingley@...]
Sent: Wednesday, August 14, 2002 11:34 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Help


Hi Paul,
You may want to use a combination of Progress code, and MS Access to do
this. I have similar situations where I use two buttons on an Access
Switchboard. The first button calls the progress program to export the data
to a .csv file. The .csv file is linked to an Access table. The second
button opens the report with the updated data. I can supply you with the
code to export the Part Table to a .csv file, and help you with MS Access if
you need it. Once in place, it's a pretty easy tool for the end user.

Note: The Progress code comes from the help, and generousity of people from
this group.
I've been wanting to find the time to find a way to eliminate the
need for the update button, and for that matter the whole
Switchboard. I can launch the update from an autoexec macro, but
the report tries to open before the records have been
updated. I'm sure there has to be a way to keep the report from
opening before the records are updated. Does anybody
know how to do this?

> -----Original Message-----
> From: karleembnqa00 [SMTP:pspringfield@...]
> Sent: Wednesday, August 14, 2002 11:34 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal Help
>
> I am in the process of setting up some new customer required
> reports. I added a VB form to Part and added a character box to use
> as a sort and selection method. In Crystal, it will not allow me to
> select the "Character02" field as a selection method. If I try to
> use the field in a formula, I get the message "Blob field or memo
> field cannot be used in a formula."
>
> My overall goal is to get summarized data into an Access Database so
> that I can append it to the customers form. I know I can use report
> builder to get at the data that I am trying to create but that also
> requires a Excel Macro for each report that I build to get it into
> Access. Since we are having to provide this data weekly, I want to
> be able to hand this off to someone else.
>
> Any info would greatly be appreciated.
>
> Thanks
>
> Paul B. Springfield
> Director of Finance
>
> Karlee Company
>
>
>
> 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/
>


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/
7
Jeremy, could you please send me a code sample?

Thanks,

Les Tingley
MIS
Decorated Products

> -----Original Message-----
> From: Leonard, Jeremy [SMTP:jleonard@...]
> Sent: Wednesday, August 14, 2002 1:48 PM
> To: 'vantage@yahoogroups.com'
> Subject: RE: [Vantage] Crystal Help
>
> I launch my access reports from Vantage. The .r file I used to launch my
> Access reports runs any Progress Code I need to export the data before it
> opens the Access database.
> Jeremy Leonard
> IT Manager
> K-T Corporation
>
>
> -----Original Message-----
> From: Les Tingley [mailto:ltingley@...]
> Sent: Wednesday, August 14, 2002 11:34 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Crystal Help
>
>
> Hi Paul,
> You may want to use a combination of Progress code, and MS Access to do
> this. I have similar situations where I use two buttons on an Access
> Switchboard. The first button calls the progress program to export the
> data
> to a .csv file. The .csv file is linked to an Access table. The second
> button opens the report with the updated data. I can supply you with the
> code to export the Part Table to a .csv file, and help you with MS Access
> if
> you need it. Once in place, it's a pretty easy tool for the end user.
>
> Note: The Progress code comes from the help, and generousity of people
> from
> this group.
> I've been wanting to find the time to find a way to eliminate the
> need for the update button, and for that matter the whole
>
> Switchboard. I can launch the update from an autoexec macro, but
> the report tries to open before the records have been
> updated. I'm sure there has to be a way to keep the report from
> opening before the records are updated. Does anybody
> know how to do this?
>
> > -----Original Message-----
> > From: karleembnqa00 [SMTP:pspringfield@...]
> > Sent: Wednesday, August 14, 2002 11:34 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Crystal Help
> >
> > I am in the process of setting up some new customer required
> > reports. I added a VB form to Part and added a character box to use
> > as a sort and selection method. In Crystal, it will not allow me to
> > select the "Character02" field as a selection method. If I try to
> > use the field in a formula, I get the message "Blob field or memo
> > field cannot be used in a formula."
> >
> > My overall goal is to get summarized data into an Access Database so
> > that I can append it to the customers form. I know I can use report
> > builder to get at the data that I am trying to create but that also
> > requires a Excel Macro for each report that I build to get it into
> > Access. Since we are having to provide this data weekly, I want to
> > be able to hand this off to someone else.
> >
> > Any info would greatly be appreciated.
> >
> > Thanks
> >
> > Paul B. Springfield
> > Director of Finance
> >
> > Karlee Company
> >
> >
> >
> > 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/
> >
>
>
> 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/
>
>
>
> 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/
>
8
/* Macroscoop: www.macroscoop.nl
-------------------------------------
Program: External.p
Version: 5.00.312 - 1.0
written by R.J. van der Linden
mailto:R.van.der.Linden@...
-------------------------------------
You can put copies of this program in the Vantage\UD
directory. Do not forget that the first two letters of the
program name have to be 'UD'

*/
DEFINE VARIABLE ProgName AS CHARACTER NO-UNDO.
DEFINE VARIABLE ProgOption AS CHARACTER NO-UNDO.
DEFINE VARIABLE hInstanceNum AS INTEGER NO-UNDO.

/* if the program or document has spaces in its name
then you have to put double quotes around it
like the document example:

ASSIGN ProgName = 'winword.exe'
ProgOption = '"c:\eManufacturing TEST Document.doc"'.

ShellExec knows location of the vantage directory.
If you put your documents in a directory called Vantage\Docs
then program option could be:
ProgOption = '"Docs\eManufacturing TEST Document.doc"'.
*/

/* This section exports the DMRCorAct table to a dos txt file. */
OUTPUT TO c:\vntgwork\DMRCorAc.txt.
FOR EACH DMRCorAct:
EXPORT DELIMITER "~011" DMRCorAct.
END.
OUTPUT CLOSE.

ASSIGN ProgName = 'msaccess.exe'
ProgOption = 'v:\vantage\ud\dmrlkup\access\dmrlkup.mde'.

RUN v:\vantage\lib\ShellExec.r (INPUT ProgName,
INPUT ProgOption,
OUTPUT hInstanceNum).

/* lib\ShellExec.p is a program of Epicor */


-----Original Message-----
From: Les Tingley [mailto:ltingley@...]
Sent: Wednesday, August 14, 2002 2:21 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Help


Jeremy, could you please send me a code sample?

Thanks,

Les Tingley
MIS
Decorated Products

> -----Original Message-----
> From: Leonard, Jeremy [SMTP:jleonard@...]
> Sent: Wednesday, August 14, 2002 1:48 PM
> To: 'vantage@yahoogroups.com'
> Subject: RE: [Vantage] Crystal Help
>
> I launch my access reports from Vantage. The .r file I used to launch my
> Access reports runs any Progress Code I need to export the data before it
> opens the Access database.
> Jeremy Leonard
> IT Manager
> K-T Corporation
>
>
> -----Original Message-----
> From: Les Tingley [mailto:ltingley@...]
> Sent: Wednesday, August 14, 2002 11:34 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Crystal Help
>
>
> Hi Paul,
> You may want to use a combination of Progress code, and MS Access to do
> this. I have similar situations where I use two buttons on an Access
> Switchboard. The first button calls the progress program to export the
> data
> to a .csv file. The .csv file is linked to an Access table. The second
> button opens the report with the updated data. I can supply you with the
> code to export the Part Table to a .csv file, and help you with MS Access
> if
> you need it. Once in place, it's a pretty easy tool for the end user.
>
> Note: The Progress code comes from the help, and generousity of people
> from
> this group.
> I've been wanting to find the time to find a way to eliminate the
> need for the update button, and for that matter the whole
>
> Switchboard. I can launch the update from an autoexec macro, but
> the report tries to open before the records have been
> updated. I'm sure there has to be a way to keep the report from
> opening before the records are updated. Does anybody
> know how to do this?
>
> > -----Original Message-----
> > From: karleembnqa00 [SMTP:pspringfield@...]
> > Sent: Wednesday, August 14, 2002 11:34 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Crystal Help
> >
> > I am in the process of setting up some new customer required
> > reports. I added a VB form to Part and added a character box to use
> > as a sort and selection method. In Crystal, it will not allow me to
> > select the "Character02" field as a selection method. If I try to
> > use the field in a formula, I get the message "Blob field or memo
> > field cannot be used in a formula."
> >
> > My overall goal is to get summarized data into an Access Database so
> > that I can append it to the customers form. I know I can use report
> > builder to get at the data that I am trying to create but that also
> > requires a Excel Macro for each report that I build to get it into
> > Access. Since we are having to provide this data weekly, I want to
> > be able to hand this off to someone else.
> >
> > Any info would greatly be appreciated.
> >
> > Thanks
> >
> > Paul B. Springfield
> > Director of Finance
> >
> > Karlee Company
> >
> >
> >
> > 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/
> >
>
>
> 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/
>
>
>
> 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/
>


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/
9
Thanks. I've got a few places for this code... Les

> -----Original Message-----
> From: Leonard, Jeremy [SMTP:jleonard@...]
> Sent: Wednesday, August 14, 2002 3:41 PM
> To: 'vantage@yahoogroups.com'
> Subject: RE: [Vantage] Crystal Help
>
>
> /* Macroscoop: www.macroscoop.nl
> -------------------------------------
> Program: External.p
> Version: 5.00.312 - 1.0
> written by R.J. van der Linden
> mailto:R.van.der.Linden@...
> -------------------------------------
> You can put copies of this program in the Vantage\UD
> directory. Do not forget that the first two letters of the
> program name have to be 'UD'
>
> */
> DEFINE VARIABLE ProgName AS CHARACTER NO-UNDO.
> DEFINE VARIABLE ProgOption AS CHARACTER NO-UNDO.
> DEFINE VARIABLE hInstanceNum AS INTEGER NO-UNDO.
>
> /* if the program or document has spaces in its name
> then you have to put double quotes around it
> like the document example:
>
> ASSIGN ProgName = 'winword.exe'
> ProgOption = '"c:\eManufacturing TEST Document.doc"'.
>
> ShellExec knows location of the vantage directory.
> If you put your documents in a directory called Vantage\Docs
> then program option could be:
> ProgOption = '"Docs\eManufacturing TEST Document.doc"'.
> */
>
> /* This section exports the DMRCorAct table to a dos txt file. */
> OUTPUT TO c:\vntgwork\DMRCorAc.txt.
> FOR EACH DMRCorAct:
> EXPORT DELIMITER "~011" DMRCorAct.
> END.
> OUTPUT CLOSE.
>
> ASSIGN ProgName = 'msaccess.exe'
> ProgOption = 'v:\vantage\ud\dmrlkup\access\dmrlkup.mde'.
>
> RUN v:\vantage\lib\ShellExec.r (INPUT ProgName,
> INPUT ProgOption,
> OUTPUT hInstanceNum).
>
> /* lib\ShellExec.p is a program of Epicor */
>
>
> -----Original Message-----
> From: Les Tingley [mailto:ltingley@...]
> Sent: Wednesday, August 14, 2002 2:21 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Crystal Help
>
>
> Jeremy, could you please send me a code sample?
>
> Thanks,
>
> Les Tingley
> MIS
> Decorated Products
>
> > -----Original Message-----
> > From: Leonard, Jeremy [SMTP:jleonard@...]
> > Sent: Wednesday, August 14, 2002 1:48 PM
> > To: 'vantage@yahoogroups.com'
> > Subject: RE: [Vantage] Crystal Help
> >
> > I launch my access reports from Vantage. The .r file I used to launch
> my
> > Access reports runs any Progress Code I need to export the data before
> it
> > opens the Access database.
> > Jeremy Leonard
> > IT Manager
> > K-T Corporation
> >
> >
> > -----Original Message-----
> > From: Les Tingley [mailto:ltingley@...]
> > Sent: Wednesday, August 14, 2002 11:34 AM
> > To: vantage@yahoogroups.com
> > Subject: RE: [Vantage] Crystal Help
> >
> >
> > Hi Paul,
> > You may want to use a combination of Progress code, and MS Access to do
> > this. I have similar situations where I use two buttons on an Access
> > Switchboard. The first button calls the progress program to export the
> > data
> > to a .csv file. The .csv file is linked to an Access table. The second
> > button opens the report with the updated data. I can supply you with the
> > code to export the Part Table to a .csv file, and help you with MS
> Access
> > if
> > you need it. Once in place, it's a pretty easy tool for the end user.
> >
> > Note: The Progress code comes from the help, and generousity of people
> > from
> > this group.
> > I've been wanting to find the time to find a way to eliminate
> the
> > need for the update button, and for that matter the whole
> >
> > Switchboard. I can launch the update from an autoexec macro,
> but
> > the report tries to open before the records have been
> > updated. I'm sure there has to be a way to keep the report from
> > opening before the records are updated. Does anybody
> > know how to do this?
> >
> > > -----Original Message-----
> > > From: karleembnqa00 [SMTP:pspringfield@...]
> > > Sent: Wednesday, August 14, 2002 11:34 AM
> > > To: vantage@yahoogroups.com
> > > Subject: [Vantage] Crystal Help
> > >
> > > I am in the process of setting up some new customer required
> > > reports. I added a VB form to Part and added a character box to use
> > > as a sort and selection method. In Crystal, it will not allow me to
> > > select the "Character02" field as a selection method. If I try to
> > > use the field in a formula, I get the message "Blob field or memo
> > > field cannot be used in a formula."
> > >
> > > My overall goal is to get summarized data into an Access Database so
> > > that I can append it to the customers form. I know I can use report
> > > builder to get at the data that I am trying to create but that also
> > > requires a Excel Macro for each report that I build to get it into
> > > Access. Since we are having to provide this data weekly, I want to
> > > be able to hand this off to someone else.
> > >
> > > Any info would greatly be appreciated.
> > >
> > > Thanks
> > >
> > > Paul B. Springfield
> > > Director of Finance
> > >
> > > Karlee Company
> > >
> > >
> > >
> > > 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/
> > >
> >
> >
> > 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/
> >
> >
> >
> > 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/
> >
>
>
> 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/
>
>
>
> 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
When I run into this problem I change the size of the field in the
database. Works great, Tech Support has a document that will give
you all the steps.

Brian Stenglein
Clow Stamping Co.


--- In vantage@y..., "karleembnqa00" <pspringfield@k...> wrote:
> I am in the process of setting up some new customer required
> reports. I added a VB form to Part and added a character box to
use
> as a sort and selection method. In Crystal, it will not allow me
to
> select the "Character02" field as a selection method. If I try to
> use the field in a formula, I get the message "Blob field or memo
> field cannot be used in a formula."
>
> My overall goal is to get summarized data into an Access Database
so
> that I can append it to the customers form. I know I can use
report
> builder to get at the data that I am trying to create but that also
> requires a Excel Macro for each report that I build to get it into
> Access. Since we are having to provide this data weekly, I want to
> be able to hand this off to someone else.
>
> Any info would greatly be appreciated.
>
> Thanks
>
> Paul B. Springfield
> Director of Finance
>
> Karlee Company
11
Good morning. I am attempting to modify the sales order form by
adding customer information mainly company name, address, etc if
bill to and ship are different. Anyhow, I have been unsuccessful in
trying to pull the customer table into the working directory of a
local machine. I tried using ODBC (pulling directly from DB), but I
encounter an issue of not retaining the 'HEADMSC' table, and
formulas getting messed up.

I am I missing something very obvious here? If any of you crystal
guru's could offer a bit of assistance I would greatly appreciated
it.

Thanks in advance,

Mark Smith
12
Mark,
This is an issue that get's bunches of attention on this list.
You need to create a subreport with the ODBC (Progress DB) table in it
connected to the main report Via the SO # converted to a number. In the
subreport you will pull OrderHed based on the SO # converted above and your
company ID (hard coded). Then you will need to pull the customer table in
via the CustNum and Company fields linked to the OrderHed table. From there
you should be set. Add fields as desired.
Good luck,
Aaron Hoyt
Vantage Plastics


-----Original Message-----
From: innerpac_il [mailto:mark_smith@...]
Sent: Friday, February 11, 2005 10:42 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Help




Good morning. I am attempting to modify the sales order form by
adding customer information mainly company name, address, etc if
bill to and ship are different. Anyhow, I have been unsuccessful in
trying to pull the customer table into the working directory of a
local machine. I tried using ODBC (pulling directly from DB), but I
encounter an issue of not retaining the 'HEADMSC' table, and
formulas getting messed up.

I am I missing something very obvious here? If any of you crystal
guru's could offer a bit of assistance I would greatly appreciated
it.

Thanks in advance,

Mark Smith






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
13
Aaron:

I kind did this using a parameter field, which isn't as nice as what you're purposing (pulling fields directly). I see how to insert a sub report that's created using ODBC, but I don't see how to link reports, so as to pull desired fields from tables in sub report. I am supposed to link.

Mark Smith
Director of Information Systems
Innerpac, Inc
(p) 708-863-8300
(f) 708-863-9770

________________________________

From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Fri 2/11/2005 2:30 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Help


Mark,
This is an issue that get's bunches of attention on this list.
You need to create a subreport with the ODBC (Progress DB) table in it
connected to the main report Via the SO # converted to a number. In the
subreport you will pull OrderHed based on the SO # converted above and your
company ID (hard coded). Then you will need to pull the customer table in
via the CustNum and Company fields linked to the OrderHed table. From there
you should be set. Add fields as desired.
Good luck,
Aaron Hoyt
Vantage Plastics


-----Original Message-----
From: innerpac_il [mailto:mark_smith@...]
Sent: Friday, February 11, 2005 10:42 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Help




Good morning. I am attempting to modify the sales order form by
adding customer information mainly company name, address, etc if
bill to and ship are different. Anyhow, I have been unsuccessful in
trying to pull the customer table into the working directory of a
local machine. I tried using ODBC (pulling directly from DB), but I
encounter an issue of not retaining the 'HEADMSC' table, and
formulas getting messed up.

I am I missing something very obvious here? If any of you crystal
guru's could offer a bit of assistance I would greatly appreciated
it.

Thanks in advance,

Mark Smith






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









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 Sponsor
ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129sb0kod/M=298184.6018725.7038619.3001176/D=groups/S=1705007183:HM/EXP=1108240220/A=2532114/R=2/SIG=12kj5qmq1/*http://clk.atdmt.com/NFX/go/yhxxxnfx0020000014nfx/direct/01/&time=1108153820035198>


________________________________

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]
14
Mark,
Once you have created the subreport you can right click on the subreport and
you should have available "subreport links". That will allow you to link
something from the main report to determine what is pulled from the
subreport.
If you are using the subreport wizard, as soon as you have finished telling
all the fields and filters, you will have a second tab for links that will
allow you to set up the same as above.
Basically it creates a parameter field that is passed to the subreport as a
filter.
Good luck,
Aaron Hoyt
Vantage Plastics


-----Original Message-----
From: Mark Smith [mailto:mark_smith@...]
Sent: Friday, February 11, 2005 3:54 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Help



Aaron:

I kind did this using a parameter field, which isn't as nice as what you're
purposing (pulling fields directly). I see how to insert a sub report
that's created using ODBC, but I don't see how to link reports, so as to
pull desired fields from tables in sub report. I am supposed to link.

Mark Smith
Director of Information Systems
Innerpac, Inc
(p) 708-863-8300
(f) 708-863-9770

________________________________

From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Fri 2/11/2005 2:30 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Help


Mark,
This is an issue that get's bunches of attention on this list.
You need to create a subreport with the ODBC (Progress DB) table in it
connected to the main report Via the SO # converted to a number. In the
subreport you will pull OrderHed based on the SO # converted above and your
company ID (hard coded). Then you will need to pull the customer table in
via the CustNum and Company fields linked to the OrderHed table. From there
you should be set. Add fields as desired.
Good luck,
Aaron Hoyt
Vantage Plastics


-----Original Message-----
From: innerpac_il [mailto:mark_smith@...]
Sent: Friday, February 11, 2005 10:42 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Help




Good morning. I am attempting to modify the sales order form by
adding customer information mainly company name, address, etc if
bill to and ship are different. Anyhow, I have been unsuccessful in
trying to pull the customer table into the working directory of a
local machine. I tried using ODBC (pulling directly from DB), but I
encounter an issue of not retaining the 'HEADMSC' table, and
formulas getting messed up.

I am I missing something very obvious here? If any of you crystal
guru's could offer a bit of assistance I would greatly appreciated
it.

Thanks in advance,

Mark Smith






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









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 Sponsor
ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129sb0kod/M=298184.6018725.7038619.3001176/D=g
roups/S=1705007183:HM/EXP=1108240220/A=2532114/R=2/SIG=12kj5qmq1/*http://clk
.atdmt.com/NFX/go/yhxxxnfx0020000014nfx/direct/01/&time=1108153820035198>


________________________________

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
15
Need a little Crystal help. I have a field (Company Code) that I would
like to combine with a five digit sequential number (created by Crystal
starting at 00001) and incrementing by 1 for each record. So if my
company code for example is PHT, this formula would create a value of:

PHT00001

For the first record on the report

PHT00002

for the next record and so on for every record.

Can anyone lend a hand on how to accomplish this?

Thanks

Todd Hofert
IT Director
Spartan Graphics, Inc.



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

[Non-text portions of this message have been removed]
16
How about something like

(tablename.company) + tostring(incrementing number)

Mike

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Todd Hofert
Sent: Wednesday, February 01, 2006 1:01 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Help


Need a little Crystal help. I have a field (Company Code) that I would
like to combine with a five digit sequential number (created by Crystal
starting at 00001) and incrementing by 1 for each record. So if my
company code for example is PHT, this formula would create a value of:

PHT00001

For the first record on the report

PHT00002

for the next record and so on for every record.

Can anyone lend a hand on how to accomplish this?

Thanks

Todd Hofert
IT Director
Spartan Graphics, Inc.



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

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



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



* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.


* 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]
17
Not to sound too stupid but how do you create "incrementing number"

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mike Lowe
Sent: Wednesday, February 01, 2006 4:03 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Help


How about something like

(tablename.company) + tostring(incrementing number)

Mike

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Todd Hofert
Sent: Wednesday, February 01, 2006 1:01 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Help


Need a little Crystal help. I have a field (Company Code) that I would
like to combine with a five digit sequential number (created by Crystal
starting at 00001) and incrementing by 1 for each record. So if my
company code for example is PHT, this formula would create a value of:

PHT00001

For the first record on the report

PHT00002

for the next record and so on for every record.

Can anyone lend a hand on how to accomplish this?

Thanks

Todd Hofert
IT Director
Spartan Graphics, Inc.



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

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



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



* Visit your group " vantage
<http://groups.yahoo.com/group/vantage> " on the web.


* 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



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

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


________________________________




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

[Non-text portions of this message have been removed]
18
Oh sorry, thought you had that.

Try something like...

(tablename.company) + tostring(count(fieldtobecounted)))

I don't have crystal up right now so the syntax may be a little off but should be close.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Todd Hofert
Sent: Wednesday, February 01, 2006 1:35 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Help


Not to sound too stupid but how do you create "incrementing number"

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mike Lowe
Sent: Wednesday, February 01, 2006 4:03 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Help


How about something like

(tablename.company) + tostring(incrementing number)

Mike

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Todd Hofert
Sent: Wednesday, February 01, 2006 1:01 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Help


Need a little Crystal help. I have a field (Company Code) that I would
like to combine with a five digit sequential number (created by Crystal
starting at 00001) and incrementing by 1 for each record. So if my
company code for example is PHT, this formula would create a value of:

PHT00001

For the first record on the report

PHT00002

for the next record and so on for every record.

Can anyone lend a hand on how to accomplish this?

Thanks

Todd Hofert
IT Director
Spartan Graphics, Inc.



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

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



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



* Visit your group " vantage
< http://groups.yahoo.com/group/vantage> " on the web.


* 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



* Visit your group "vantage
< http://groups.yahoo.com/group/vantage> " on the web.

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


________________________________




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

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



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



* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.


* 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]
19
Sounds like what you are looking for is


On Field Explorer --> Special Fields --> Record Number


Hope this helps

Dale E. Schuerman
Senior Consultant
RAM Software Systems, Inc.
972-669-0763 x233 (voice)
972-669-9603 (fax)
mailto:dale.schuerman@... (email)
http://www.ramsys.com (website)

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Hofert
Sent: Wednesday, February 01, 2006 3:35 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Help

Not to sound too stupid but how do you create "incrementing number"

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mike Lowe
Sent: Wednesday, February 01, 2006 4:03 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Help


How about something like

(tablename.company) + tostring(incrementing number)

Mike

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Todd Hofert
Sent: Wednesday, February 01, 2006 1:01 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Help


Need a little Crystal help. I have a field (Company Code) that I would
like to combine with a five digit sequential number (created by Crystal
starting at 00001) and incrementing by 1 for each record. So if my
company code for example is PHT, this formula would create a value of:

PHT00001

For the first record on the report

PHT00002

for the next record and so on for every record.

Can anyone lend a hand on how to accomplish this?

Thanks

Todd Hofert
IT Director
Spartan Graphics, Inc.



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

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



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



* Visit your group " vantage
<http://groups.yahoo.com/group/vantage> " on the web.


* 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



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

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


________________________________




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

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



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






########################################################################
Attention:
This email message is privileged and confidential. If you are not the
intended recipient please delete the message and notify the sender.
Any views or opinions presented are solely those of the author.

This email message has been scanned for Viruses and Content and cleared
by MailMarshal SMTP

For more information go to http://www.ramsys.com
########################################################################
20
Can anyone tell me how to select only the most recent transaction record
for an operation. I have a sub report that lists every operation a job
will go through with a formula field that gives the status of the
operation.



if {LaborDtl.ActiveTrans}=True

Then "In Progress" & "-" & Totext({LaborDtl.ClockInDate}&"
"&{LaborDtl.ClockinTime}&" "&{EmpBasic.Name})



Else if {LaborDtl.ActiveTrans}=False

Then "Work Stopped"& "-" & totext({LaborDtl.ClockInDate}&"
"&{LaborDtl.ClockOutTime}&" "&{EmpBasic.Name})

Else ""



Problem is that when my operators don't complete the operation on the
first clock in I end up with multiple transactions showing up for each
operation and I only need to see the most recent for each operation.



Thanks,

Chris



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