Index value is too long

Yahoo Archive
1
Patrick - the sort was the problem. Thank you!!

John

--- In vantage@yahoogroups.com, pjw@s... wrote:
> Sounds like your sorting on the part description field, try
creating a
> calculated field substring(part.partdescription,1,30) then sorting
on that.
>
>
> Patrick Winter
>
>
> -----Original Message-----
> From: John Meier [mailto:jmeier@n...]
> Sent: Thursday, October 28, 2004 10:49 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] index value is too long
>
>
>
> Trying to edit a report that lists parts beginning with a string.
> Keep getting "index value is too long". Only using the part
table.
> Any ideas? Thanks, John
>
>
>
>
>
>
> ------------------------ Yahoo! Groups Sponsor --------------------
~-->
> $9.95 domain names from Yahoo!. Register anything.
> http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/PhFolB/TM
> -------------------------------------------------------------------
-~->
>
> 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
2
Trying to edit a report that lists parts beginning with a string.
Keep getting "index value is too long". Only using the part table.
Any ideas? Thanks, John
3
What are you using to write this report in? Report Builder or
Crystal Reports?
4
Report Builder.

--- In vantage@yahoogroups.com, "fselliott1" <fselliott1@y...> wrote:
>
> What are you using to write this report in? Report Builder or
> Crystal Reports?
5
Sounds like your sorting on the part description field, try creating a
calculated field substring(part.partdescription,1,30) then sorting on that.


Patrick Winter


-----Original Message-----
From: John Meier [mailto:jmeier@...]
Sent: Thursday, October 28, 2004 10:49 AM
To: vantage@yahoogroups.com
Subject: [Vantage] index value is too long



Trying to edit a report that lists parts beginning with a string.
Keep getting "index value is too long". Only using the part table.
Any ideas? Thanks, John






------------------------ Yahoo! Groups Sponsor --------------------~-->
$9.95 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/PhFolB/TM
--------------------------------------------------------------------~->

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