URGENT : how to increase the row limit in Crystal Reports.....

[sudhajan]

hi,
i am having more than a one lakh records in the database (ms access) and i am getting the following error while displaying(retrieving ) through crystal reports..

rows/coloumns exceeded the maximum limit....

i would like to rectify this error

help needed urgently ..

thanks

 

[dgillz]

What is a "lakh" ? Please advise

Also, where are you getting this error? Is it on a particular formula? If so please post the formula. Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[Naith]

I think lakh is 100,000 - but I'm sure sudhajan will correct me if I'm blowing it out my hole.

I guess you need to go into File/Options/Reporting Tab, and uncheck then Count Records option, which is most likely checked on and set to warn at 100k records.

Naith

 

[sudhajan]

my table consists of more than 1,00,000 records or rows . And i displaying all the rows or records in the cross tab which is giving error.

one lakh means 100000

 

[sudhajan]

Naith ,
i have seen the reporting option and the count record is not selected and also the warn me option is set to 500 by default.
It is taking only the values from 1 to 32767 only

i tried this option but did not work .

 

[sudhajan]

I am getting error not on formula but only after the reading all the records which i could see on the status bar and before the records could be displayed , I am getting the following error..

"The number of rows or coloumns are too big .Try limiting
the no of unique group values"


i have seen the reporting option and the count record is

not selected and also the warn me option is set to 500 by

default.
It is taking only the values from 1 to 32767 only

i tried this option but did not work .

 

[Naith]

You aren't using Enterprise, are you?

Because if so, you should check ensure that you have added maxDBResultRecords 0 to the page server command line.

Are you just getting this error running the report against CR X.X on the client?

Naith

 

[sudhajan]

I am using crystal report 8.5 developer edition and designed the report through VB and showing with crystal report viewer control .

and where should i set this "maxDBResultRecords 0" ??

 

[Naith]

maxDBResultRecords 0 is a Crystal Enterprise setting. If you're not using CE, it's nothing you need to worry about.

It sounds to me like you don't have very many records (or even just one) per page, on your report - which is resulting in an incredible amount of pages in your report.

I think there is actually a limit of 32767 pages in the Crystal viewer - anything over 32767 pages makes Crystal throw a tantrum. If you think this is the number of records you are getting processed, are you setting New Page After each record? Go into Format Section and check.

If you really do have a 33,000 page report - is anyone really going to read that?

Naith

 

[sudhajan]

i would like to give somwhat more details to get a better idea....
This report is meant to display all the curtomers of the a particular bank .
i am having the ms-access database as following details ...

Table name : master
fields (colomns) :

name address typeofaccount amount

record 1) a xxxx current 1000
2) b yyyy current 2000
3) c zzzz savings 2500
4) d xxyy Fixed 2000
5) a xxxx savings 1000
. . . .
. . . .

and so on ( having one hundred thousand records(100,000+ records))

I am displaying all customers using CROSS-TAB .

In the Cross-Tab , I am taking name+address(combined in formula field) in rows. Typeofaccount in Columns side and Amount in summarised field.

The report would like this....

savings current fixed Total

a, 1000 1000 0 2000
xxxx

b, 0 2000 0 2000
yyyy

c, 2500 0 0 2500
zzzz

d, 0 0 2000 2000
xxyy

It is reading all the records from the database which i could see in the status bar.then the error appears..

"The number of rows or coloumns are too big .Try limiting the number of unique group values"

I am using the formula field for (name + address) which is having following code ...

stringVar x :=trim({Master.Name}) ;

if not isnull({Master.Address}) then
x:=x +trim({Master.Address} )
else
x:=x;

and i was getting about 6000 pages with all those records displayed and i have not set New Page After each record.
hope u got what i was telling and what i want.

naith ,
if i could get ur id , i could send the pic for the error message i am getting , it could be better to understand . u could send to my mail-id "sudhajan2002@rediffmail.com" if u like .

 

[Naith]

You need to check out

http://support.crystaldecisions.com/library/kbase/articles/c2008373.asp

for X-tab limitations.

But, before you do the error you're getting is because you are returning too much data for the report. Your report is bringing back too many groups (32.7k), hence the fallover.

Custom X-tabs are more flexible than the expert, which you might want to try using. Also, I would consider sectioning the report - to perhaps run for people named between A-K, L-R, etc. Also, ensure that you don't have 'Verify on every print' activated in the Database menu too.

Naith

 

[lyanch]

If your backend is MS Access, I would do the crosstab in a query there.. then it would be easy to report on the result set.

Lisa

 

[chelseatech]

I've got two suggestions...
1) One solution is to find a field to group your customers by and place the crosstab in the group header.

It appears there is a limit of 32767 rows or columns in a crosstab. So we jsut break it into smaller pieces

2) If the columns are fairly static: fixed, Savings, Costs, Total, etc. then use a condtional formula for each, and summarise them in Groups in CR. No problem with millions of records for that one. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm