Solved

Cross Tab Row Limit

Posted on 2004-09-16
10
468 Views
Last Modified: 2008-02-01
Hi,

I have a cross tab report in Crystal 10 which is giving me problems when displaying more than 495 rows. When viewing the dataset from the Crystal designer all the rows (698) are displayed correctly. However when the report is run through an ASP .net application i get an error saying: "Specified argument was out of the range of valid values. Parameter name: value"
the stack trace is as follows: -
ArgumentOutOfRangeException: Specified argument was out of the range of valid values.
Parameter name: value]
   System.Web.UI.WebControls.Unit..ctor(Int32 value)
   CrystalDecisions.Web.ReportAgent.(Boolean i)
   CrystalDecisions.Web.CrystalReportViewer.OnPreRender(EventArgs e)
   System.Web.UI.Control.PreRenderRecursiveInternal()
   System.Web.UI.Control.PreRenderRecursiveInternal()
   System.Web.UI.Control.PreRenderRecursiveInternal()
   System.Web.UI.Control.PreRenderRecursiveInternal()
   System.Web.UI.Control.PreRenderRecursiveInternal()
   System.Web.UI.Control.PreRenderRecursiveInternal()
   System.Web.UI.Control.PreRenderRecursiveInternal()
   System.Web.UI.Control.PreRenderRecursiveInternal()
   System.Web.UI.Page.ProcessRequestMain()


Cheers
0
Comment
Question by:jbonello
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
10 Comments
 
LVL 42

Expert Comment

by:frodoman
ID: 12076886
Have you applied CR10 Service Pack 1 which was released in August?  I'm not certain this is the problem, but there was a reported issue of crosstab COLUMNS being cutoff when viewed on the web and that was suppossed to be fixed.  I haven't seen any documentation but it isn't unreasonable to guess that perhaps too many rows could be cutoff by a related issue.

frodoman
0
 

Author Comment

by:jbonello
ID: 12082123
I have installed the following service packs but still have the same problem:

crnet11win_en_sp2.exe
cr10win_en_sp1.exe

Any more ideas please?
0
 
LVL 42

Expert Comment

by:frodoman
ID: 12083843
Sorry - I don't have any other thoughts. - frodoman
0
[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

 

Author Comment

by:jbonello
ID: 12083879
I have been in contact with Business Objects support and it is looking more likely that this is a Crystal bug.


Cheers

0
 
LVL 42

Expert Comment

by:frodoman
ID: 12298919
Delete / Refund
0
 

Author Comment

by:jbonello
ID: 12305487
Currently I'm in touch with Business Objects over this issue. It seems that the problem is inherintly Crystal not supporting more than 32 pages on a Cross-Tab report. Basically, it is a problem with their object model. This has been confirmed by their support personel, and pausibly issue a hot fix for it, in the nearby future.

Thanks.
0
 
LVL 42

Expert Comment

by:frodoman
ID: 12307456
jbonello - Thanks for the update.

TheLearnedOne - Please PAQ / Refund on this one with the new info.
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 12364107
PAQed, with points refunded (300)

Computer101
E-E Admin
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question