Solved

Cross Tab Row Limit

Posted on 2004-09-16
10
462 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
  • 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
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

 

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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
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…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
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…

786 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