-
April 2nd, 2000, 12:15 PM
#1
Problems in IN clause of Crystal Reports
Dear All,
The problem is like this, I collect the Key Id from ListView control and make an array of numbers like
{shelf.id} In [3,4,12,6,89,34,23,56,12,57,35,87,56,45]
It gives the error in crystal reports that there are too many members of array. On going through the documentation, I could not find any such restriction. But when I do it for smaller number it works. Why it is so...
Please help. Is that a bug????
Santulan
-
April 3rd, 2000, 07:59 AM
#2
Re: Problems in IN clause of Crystal Reports
I don't think there is any such limitation. I used 'Like' clause and used upto 50 numbers in the string. It works fine...
-
April 3rd, 2000, 09:28 AM
#3
Re: Problems in IN clause of Crystal Reports
Boss!!!
There is problem this is why I reported to codeguru. You try with In clause and in array give more than 30 values.
Ok
Santulan
-
April 3rd, 2000, 09:47 AM
#4
Re: Problems in IN clause of Crystal Reports
I've used IN in crystal reports with no problems at all and with more than 100 items and it works fine.
I use version 7 so it might be a problem with the version you're using.
-
April 4th, 2000, 11:13 AM
#5
Re: Problems in IN clause of Crystal Reports
MAy be, because, I am using 4.6. Thanks any way
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|