Rhonda,
It's been a while since I've had to do this, but if memory serves,
after we upgraded to the Vantage 6 and started using the ODBC driver
that comes with it, there were 2 places I needed to make a change.
One was in the Data Dictionary field properties, and the other was in
the Data Dictionary -> Options -> SQL Properties -> Adjust Field
Width.
My original instructions did not include that second step, so maybe
that is where your problem lies.
HTH,
Brian Stenglein
Clow Stamping Co.
It's been a while since I've had to do this, but if memory serves,
after we upgraded to the Vantage 6 and started using the ODBC driver
that comes with it, there were 2 places I needed to make a change.
One was in the Data Dictionary field properties, and the other was in
the Data Dictionary -> Options -> SQL Properties -> Adjust Field
Width.
My original instructions did not include that second step, so maybe
that is where your problem lies.
HTH,
Brian Stenglein
Clow Stamping Co.
--- In vantage@yahoogroups.com, "Reilly, Rhonda" <rreilly@e...> wrote:
> Brian,
> I have change the field size of several Blob fields in vantage but I
> still can't seem to get them to work in Crystal reports. I still
don't
> see them to be able to select them. I have restarted the DB
thinking
> that would help but it doesn't. Any clue.
>
> Thanks
>
> Rhonda Reilly
> Information Resource Manager
> American Aero / Titan
> 985.893.1818
> 985.893.1879 fax
>
> -----Original Message-----
> From: Brian Stenglein [mailto:bstenglein@c...]
> Sent: Friday, January 30, 2004 3:22 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Crystal Reports field missing-MEMO fields
>
> Hey guys,
>
> Just wanted to remind you all of a solution I've mentioned a couple
> of times previously on this issue.
>
> Tech Support has instructions on changing the field size of DB
> fields. You enter the Data Dictionary of your Progress DB and
shrink
> the field size from 1000 characters to 255 and it works great in
> Crystal and Access after that.
>
> I've used it for VB form Character fields, I've used it for the
Order
> Header Rep List, and various other times when I've wanted to use a
> memo field in a formula or selection criteria.
>
> Once you get the instructions its really simple to do. Only catch
is
> you have to be the only one in the DB when you make the change.
>
> Really Freezing in Northern MN -32 this morning.
>
> HTH,
>
> Brian Stenglein
> Clow Stamping Co.
>
>
> --- In vantage@yahoogroups.com, Adam Ellis <aellis@s...> wrote:
> > Sorry to reply to my own post, but one more thing...
> >
> > > One trick I have found to work around this in Crystal 8.0 and
> above is
> > > to create an SQL Expression Field like so:
> > >
> > > {fn SUBSTRING(vantage.blobfield, 1, 255)}
> > >
> > > and use *this* in your formulas. The 1 is the beginning
> character and
> > > the 255 is the ending character. This slices up the blob field
> > > nicely.
> >
> > Note that the blob field WILL NOT show up in the field list as
you
> are
> > writing the formula...you must manually type it in. However, the
> > formual will check OK and work fine.
> >
> > --
> > Adam Ellis <aellis@s...>
> > SaberLogic
>
>
>
> 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
> Service <http://docs.yahoo.com/info/terms/> .
>
>
> [Non-text portions of this message have been removed]