CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 1999
    Location
    India-Delhi
    Posts
    106

    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

  2. #2
    Join Date
    Mar 2000
    Posts
    175

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


  3. #3
    Join Date
    Aug 1999
    Location
    India-Delhi
    Posts
    106

    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

  4. #4
    Join Date
    Feb 2000
    Location
    Ireland
    Posts
    808

    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.


  5. #5
    Guest

    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
  •  





Click Here to Expand Forum to Full Width

Featured