PO Form/Crystal help

Butch,
I just checked out the video and now it seems pretty easy.
Thanks alot!
Julie

----- Original Message -----
From: "Butch Menge" <bmenge@...>
To: <vantage@yahoogroups.com>
Sent: Thursday, September 23, 2004 10:47 AM
Subject: RE: [Vantage] PO Form/Crystal help


> On Epicor's website in their tech videos section, they have a couple on
> how to do subreports. Might want to check it out.
>
> http://support.epicor.com/Support/MfgSolutions/Vantage/CustomerCenter/vt
> ngtechsupvideosdef.htm?ExpLeftNavigation1ExpandValue=MainLeft1_ExpLeftNa
> vigation1{A3FF237E-6AD6-423B-8002-0DC25C309E81}
>
> Butch
>
> ________________________________
>
> From: Julie Lehmann [mailto:jlehmann@...]
> Sent: Thursday, September 23, 2004 6:07 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] PO Form/Crystal help
>
>
> Thanks Aaron - I also got some advice from Dan from States Electric on
> sub-reports and this will really help. I would have never thought to go
> that route on my own (being a rookie Crystal person). I sure am
> grateful
> for all you guys and gals on this list!
> Julie
>
> ----- Original Message -----
> From: "Aaron Hoyt" <hoyt@...>
> To: <vantage@yahoogroups.com>
> Sent: Thursday, September 23, 2004 6:55 AM
> Subject: RE: [Vantage] PO Form/Crystal help
>
>
> >
> > Julie,
> > There is an easier way. You can't bring in a field directly, but you
> > can create a subreport and use that to bring in data via ODBC.
> > We use this on several of our canned Crystal reports to bring in
> > additional data.
> > If you need additional info, let us know, if not me personally, this
> > list will guide you.
> > Aaron Hoyt
> > Hittite Microwave
> >
> > -----Original Message-----
> > From: Julie Lehmann [mailto:jlehmann@...]
> > Sent: Wednesday, September 22, 2004 3:46 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] PO Form/Crystal help
> >
> >
> > Hi all:
> > I'm so frustrated with this - I guess I need help! I need to
> > show partial receipts against PO releases. I've already revised the
> > form to exclude complete Lines and Releases, but the partial receipt
> is
> > still a problem. As far as I know, you can't bring a field into a
> > canned Crystal report (porel.receivedqty), which would be all I need,
> > so my struggles are with starting over and re-creating the PO form.
> How
> > do you bring "sidlabls" into a Crystal report and where does "ormisc"
> in
> > the canned report come from? Does anyone have a revised PO Form
> > they've created for this same purpose that would be willing to share
> it
> > with me? I would think ALOT of companies would have this issue. Any
> > help is appreciated. Thanks!
> >
> > Julie Lehmann, MIS Director
> > MERCURY MINNESOTA INC.
> > 507-332-1149
> >
> >
> > [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 Sponsor
> > ADVERTISEMENT
> > click here
> >
> <http://us.ard.yahoo.com/SIG=129mqv2dt/M=295196.4901138.6071305.3001176/
> >
> D=groups/S=1705007183:HM/EXP=1095969200/A=2128215/R=0/SIG=10se96mf6/*htt
> > p://companion.yahoo.com>
> >
> >
> <http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
> > s/S=:HM/A=2128215/rand=244371468>
> >
> >
> > ________________________________
> >
> > 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/vantag
> e/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
> click here
> <http://us.ard.yahoo.com/SIG=129j1e31u/M=295196.4901138.6071305.3001176/
> D=groups/S=1705007183:HM/EXP=1096031218/A=2128215/R=0/SIG=10se96mf6/*htt
> p://companion.yahoo.com>
>
> <http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
> s/S=:HM/A=2128215/rand=196512178>
>
> ________________________________
>
> 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
>
>
>
>
>
>
Hi all:
I'm so frustrated with this - I guess I need help! I need to show partial receipts against PO releases. I've already revised the form to exclude complete Lines and Releases, but the partial receipt is still a problem. As far as I know, you can't bring a field into a canned Crystal report (porel.receivedqty), which would be all I need, so my struggles are with starting over and re-creating the PO form. How do you bring "sidlabls" into a Crystal report and where does "ormisc" in the canned report come from? Does anyone have a revised PO Form they've created for this same purpose that would be willing to share it with me? I would think ALOT of companies would have this issue. Any help is appreciated. Thanks!

Julie Lehmann, MIS Director
MERCURY MINNESOTA INC.
507-332-1149


[Non-text portions of this message have been removed]
Julie,
There is an easier way. You can't bring in a field directly, but you
can create a subreport and use that to bring in data via ODBC.
We use this on several of our canned Crystal reports to bring in
additional data.
If you need additional info, let us know, if not me personally, this
list will guide you.
Aaron Hoyt
Hittite Microwave

-----Original Message-----
From: Julie Lehmann [mailto:jlehmann@...]
Sent: Wednesday, September 22, 2004 3:46 PM
To: vantage@yahoogroups.com
Subject: [Vantage] PO Form/Crystal help


Hi all:
I'm so frustrated with this - I guess I need help! I need to
show partial receipts against PO releases. I've already revised the
form to exclude complete Lines and Releases, but the partial receipt is
still a problem. As far as I know, you can't bring a field into a
canned Crystal report (porel.receivedqty), which would be all I need,
so my struggles are with starting over and re-creating the PO form. How
do you bring "sidlabls" into a Crystal report and where does "ormisc" in
the canned report come from? Does anyone have a revised PO Form
they've created for this same purpose that would be willing to share it
with me? I would think ALOT of companies would have this issue. Any
help is appreciated. Thanks!

Julie Lehmann, MIS Director
MERCURY MINNESOTA INC.
507-332-1149


[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 Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129mqv2dt/M=295196.4901138.6071305.3001176/
D=groups/S=1705007183:HM/EXP=1095969200/A=2128215/R=0/SIG=10se96mf6/*htt
p://companion.yahoo.com>

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=244371468>


________________________________

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]
Thanks Aaron - I also got some advice from Dan from States Electric on
sub-reports and this will really help. I would have never thought to go
that route on my own (being a rookie Crystal person). I sure am grateful
for all you guys and gals on this list!
Julie

----- Original Message -----
From: "Aaron Hoyt" <hoyt@...>
To: <vantage@yahoogroups.com>
Sent: Thursday, September 23, 2004 6:55 AM
Subject: RE: [Vantage] PO Form/Crystal help


>
> Julie,
> There is an easier way. You can't bring in a field directly, but you
> can create a subreport and use that to bring in data via ODBC.
> We use this on several of our canned Crystal reports to bring in
> additional data.
> If you need additional info, let us know, if not me personally, this
> list will guide you.
> Aaron Hoyt
> Hittite Microwave
>
> -----Original Message-----
> From: Julie Lehmann [mailto:jlehmann@...]
> Sent: Wednesday, September 22, 2004 3:46 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] PO Form/Crystal help
>
>
> Hi all:
> I'm so frustrated with this - I guess I need help! I need to
> show partial receipts against PO releases. I've already revised the
> form to exclude complete Lines and Releases, but the partial receipt is
> still a problem. As far as I know, you can't bring a field into a
> canned Crystal report (porel.receivedqty), which would be all I need,
> so my struggles are with starting over and re-creating the PO form. How
> do you bring "sidlabls" into a Crystal report and where does "ormisc" in
> the canned report come from? Does anyone have a revised PO Form
> they've created for this same purpose that would be willing to share it
> with me? I would think ALOT of companies would have this issue. Any
> help is appreciated. Thanks!
>
> Julie Lehmann, MIS Director
> MERCURY MINNESOTA INC.
> 507-332-1149
>
>
> [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 Sponsor
> ADVERTISEMENT
> click here
> <http://us.ard.yahoo.com/SIG=129mqv2dt/M=295196.4901138.6071305.3001176/
> D=groups/S=1705007183:HM/EXP=1095969200/A=2128215/R=0/SIG=10se96mf6/*htt
> p://companion.yahoo.com>
>
> <http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
> s/S=:HM/A=2128215/rand=244371468>
>
>
> ________________________________
>
> 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/vantag
e/messages
> (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
On Epicor's website in their tech videos section, they have a couple on
how to do subreports. Might want to check it out.

http://support.epicor.com/Support/MfgSolutions/Vantage/CustomerCenter/vt
ngtechsupvideosdef.htm?ExpLeftNavigation1ExpandValue=MainLeft1_ExpLeftNa
vigation1{A3FF237E-6AD6-423B-8002-0DC25C309E81}

Butch

________________________________

From: Julie Lehmann [mailto:jlehmann@...]
Sent: Thursday, September 23, 2004 6:07 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] PO Form/Crystal help


Thanks Aaron - I also got some advice from Dan from States Electric on
sub-reports and this will really help. I would have never thought to go
that route on my own (being a rookie Crystal person). I sure am
grateful
for all you guys and gals on this list!
Julie

----- Original Message -----
From: "Aaron Hoyt" <hoyt@...>
To: <vantage@yahoogroups.com>
Sent: Thursday, September 23, 2004 6:55 AM
Subject: RE: [Vantage] PO Form/Crystal help


>
> Julie,
> There is an easier way. You can't bring in a field directly, but you
> can create a subreport and use that to bring in data via ODBC.
> We use this on several of our canned Crystal reports to bring in
> additional data.
> If you need additional info, let us know, if not me personally, this
> list will guide you.
> Aaron Hoyt
> Hittite Microwave
>
> -----Original Message-----
> From: Julie Lehmann [mailto:jlehmann@...]
> Sent: Wednesday, September 22, 2004 3:46 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] PO Form/Crystal help
>
>
> Hi all:
> I'm so frustrated with this - I guess I need help! I need to
> show partial receipts against PO releases. I've already revised the
> form to exclude complete Lines and Releases, but the partial receipt
is
> still a problem. As far as I know, you can't bring a field into a
> canned Crystal report (porel.receivedqty), which would be all I need,
> so my struggles are with starting over and re-creating the PO form.
How
> do you bring "sidlabls" into a Crystal report and where does "ormisc"
in
> the canned report come from? Does anyone have a revised PO Form
> they've created for this same purpose that would be willing to share
it
> with me? I would think ALOT of companies would have this issue. Any
> help is appreciated. Thanks!
>
> Julie Lehmann, MIS Director
> MERCURY MINNESOTA INC.
> 507-332-1149
>
>
> [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 Sponsor
> ADVERTISEMENT
> click here
>
<http://us.ard.yahoo.com/SIG=129mqv2dt/M=295196.4901138.6071305.3001176/
>
D=groups/S=1705007183:HM/EXP=1095969200/A=2128215/R=0/SIG=10se96mf6/*htt
> p://companion.yahoo.com>
>
>
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
> s/S=:HM/A=2128215/rand=244371468>
>
>
> ________________________________
>
> 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/vantag
e/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
click here
<http://us.ard.yahoo.com/SIG=129j1e31u/M=295196.4901138.6071305.3001176/
D=groups/S=1705007183:HM/EXP=1096031218/A=2128215/R=0/SIG=10se96mf6/*htt
p://companion.yahoo.com>

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=196512178>

________________________________

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]