Improve company productivity with a Business Account.Sign Up

x
?
Solved

Cross Tab Row Limit

Posted on 2004-09-16
10
Medium Priority
?
476 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
8 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
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 

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: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

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. …
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 …
Watch the video to know the simple way to remove or recover or reset lost or forgotten passwords of Outlook PST file. With Kernel Outlook Password Recovery tool such operation is very easy to perform. It is a freeware with limitation to use with 500…
Watch the video to know the process of migration of Exchange or Office 365 mailboxes in absence of MS Outlook. It is an eminent tool which can easily migrate Public, Archive user mailboxes from one another Exchange server and Office 365. Kernel Migr…

585 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