Solved

Cross Tab Row Limit

Posted on 2004-09-16
10
464 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
Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying 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

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. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

828 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