Thanks for your help with report builder & crystal. I will do it in
report builder.
report builder.
--- In vantage@yahoogroups.com, "Aaron Hoyt" <hoyt@h...> wrote:
> This is the reason I would build this in Report Builder. Crystal
is not
> able to use a memo (blob) field in a calculation therefore it is
> unavailable. This will work in RB though.
>
>
>
> Aaron
>
>
>
> -----Original Message-----
> From: brucewbrannan [mailto:bruce.brannan@w...]
> Sent: Wednesday, March 24, 2004 4:38 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Crystal Report - Date Collection (Plant
Floor)
> Notes Field
>
>
>
> Aaron,
>
> I used the proper table and now I get all the labor edit records.
> Now I need to filter them down by a wildcard search in the note
> field and a date. I think I filter through Report, Select
Expert.
> When I try this the LaborNote field is not in the list. Any ideas
> why not?
>
> Bruce
>
> --- In vantage@yahoogroups.com, "Aaron Hoyt" <hoyt@h...> wrote:
> > Bruce,
> >
> > Simple answer, if it was me, I would build this in Report
Builder.
> > Crystal 8.X does not handle Memo fields well, and this may be
your
> > problem. If you use Report Builder, this should overcome the
> problem.
> >
> > If you have to use Crystal, you will need to truncate the notes
> field to
> > something Crystal can deal with.
> >
> > Hope this helps.
> >
> > Aaron Hoyt
> >
> > Hittite Microwave Corporation
> >
> >
> >
> > -----Original Message-----
> > From: brucewbrannan [mailto:bruce.brannan@w...]
> > Sent: Wednesday, March 24, 2004 3:20 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Crystal Report - Date Collection (Plant
Floor)
> Notes
> > Field
> >
> >
> >
> > Our Crystal guru left the company. We are trying to use the
Notes
> > field on the Data Collection entry screen to track gauge serial
> > numbers. As the workers end activities they can scan the
barcodes
> > of any gauges they use into this field. What I need to do is
> create
> > a report to query by note and then refine by a date range. I
> > created the report in Crystal (Vantage 5.2) and used the table
> > called LbrLoad. I inserted the LaborNote field and a few
others,
> > job, oper, sequence and date. When I preview the report there
is
> no
> > data in it. How can I have it query all labor entries and
filter
> by
> > the note field? I have ODBC setup and when I can verify that
the
> > database connection is working. I remember in the past how we
had
> > to open a PO for the POform report to display that data. I
> believe
> > it pulled the data from c:\vntgwk52 directory but I need to
search
> > the whole database and not just one record.
> >
> > Thanks for any help,
> >
> > Bruce Brannan
> > Engineered Products Department
> >
> >
> >
> > 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/>
> > <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://rd.yahoo.com/SIG=12c6037gs/M=268585.4521611.5694062.1261774/D
> =eg
> >
>
roupweb/S=1705007183:HM/EXP=1080246022/A=1950447/R=0/SIG=1245hvqf1/*h
> ttp
> > :/ashnin.com/clk/muryutaitakenattogyo?YH=4521611&yhad=1950447>
> click
> > here
> >
> >
> >
> > <http://us.adserver.yahoo.com/l?
> M=268585.4521611.5694062.1261774/D=egrou
> > pweb/S=:HM/A=1950447/rand=479804157>
> >
> >
> >
> > _____
> >
> > 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
> > <http://docs.yahoo.com/info/terms/> Service.
> >
> >
> >
> > [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/.
> <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
> <http://docs.yahoo.com/info/terms/> Service.
>
>
>
> [Non-text portions of this message have been removed]