The FundName (FundA,FundB etc) is selected as the Column value and Investment% as the summary in the cross tab.
In the stored procedure result set I would be getting 5 records with InvestorID = 1 and for InvestorID = 2
InvestorID Name FundA FundB FundC FundD Fund E
1 abd 10%...
Actually the report gets executed in any case - but the data is not appearing in the report.
From Crystal the exception is thrown first and a blank section is shown where crosstab is placed, with VB this exception is not caught but a blank cross tab itself is generated.
Actually I am...
Ian,
Thanks for your reply.
I was having the crosstab in the header section with grouping on Investor.
But it looks like even if I am restricting the no:of rows while reading the records, crytal ( not sure if this is possible ) identifies there are more than 65k records and the crosstab fails
Thank you for your thoughts.
The second approach seemed very much possible , by using a filter in 'Record Selection Formula' for restricting the records upto 30K. And then using a sub report for the rest.
But in the end the same exception was thrown, even though the no:of records being...
Hi
I am using Crystal 10 and one the cross tab reports throws an exception "the number of rows or columns are too big: Try limiting the number of Unique group values" when the cross tab processes a large no:of rows. For smaller data the report runs good.
Have you seen this kind of behaviour...
Hi
I am using Crystal 10 and one the cross tab reports throws an exception "the number of rows or columns are too big: Try limiting the number of Unique group values" when the cross tab processes a large no:of rows. For smaller data the report runs good.
Have you seen this kind of behaviour...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.