Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Cross Tab Row Limit

Posted on 2004-09-16
10
Medium Priority
?
472 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
How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

 

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

[Webinar] Cloud Security

In this webinar you will learn:

-Why existing firewall and DMZ architectures are not suited for securing cloud applications
-How to make your enterprise “Cloud Ready”, and fix your aging DMZ architecture
-How to transform your enterprise and become a Cloud Enabler

Question has a verified solution.

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

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…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Loops Section Overview
Suggested Courses

972 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