Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jk2802

    Cross tab limitation for displayinf more than 65k rows

    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%...
  2. jk2802

    Cross tab limitation for displayinf more than 65k rows

    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...
  3. jk2802

    Cross tab limitation for displayinf more than 65k rows

    A Stored procedure is pulling the data from sybase 12.5 DB using an OleDbConnection with VB
  4. jk2802

    Cross tab limitation for displayinf more than 65k rows

    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
  5. jk2802

    Cross tab limitation for displayinf more than 65k rows

    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...
  6. jk2802

    Cross tab limitation for displayinf more than 65k rows

    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...
  7. jk2802

    Crystal Reports 10 - Cross Tab Limitation on displaying > 65k rows

    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...

Part and Inventory Search

Back
Top