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@...]
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.
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@...]
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]