Skip to Content
author's profile photo Former Member
Former Member

Crystal Reports 2008 reads only 272 clumns from stored proc resultset

I face this strange issue. I have a sub report connected to a stored procedure. The stored procedure currently returns 271 columns in the resultset. I need the stored procedure to return 8 more columns in the resultset. When I altered the stored procedure and executed the crystal report, i got the error, "One or more fields could not be found". When i removed ALL 8 fields from the stored procedure, my report started working like a charm again. After a lot of struggle, I started adding one oe field at a time. To my surprise, i observed that, I was able to add onle one more column to the existing resultset of the stored procedure. As soon as i added the second column to the resultset, my report started breaking.

There is any limitation in Crystal Reports 2008 on the number of columns it can access. The max limit that i see in my case is 272. Since these are legacy reports, it is not a good suggestion to delete some keys from the existing resultset as this problem may again crop up in future when more columns from the resultset will be required.

Please help at the earliest. Thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 07, 2014 at 06:35 PM

    I am not sure of any limitation or could not find any documentation on limitation of column. It could be a limitation for sub report ; can you add more than 272 field in main report and see if it throws the error.

    Also try with adding more than 272 in sub report but with a direct database as data source..

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2014 at 04:45 AM

    I have not checked this issue myself, however it would be appropriate t figure out the issue in the latest patch of CR 2008 and see if it works.

    Do get more details on this I suggest you to move the thread to Crystal reports forum.

    @Abhilash Kumar Can you help and provide correct information with regards to this

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.