How to Increase 8000 rows report output limit in CUIC

[cdnadmin]

Subject: RE: How to Increase 8000 rows report output limit in CUIC
Replied by: Dattatraya Rooyikar on 02-12-2011 02:43:53 AM
Hi,
 
We can not increase this number. System is verified with these limits. So even if there is back entry where it allows to change this number but system behavior can not be predicted after.
 
So this max limit can not be changed.
 
Thanks,
Datta
 

Hi,
 
I am wondering if we casn increase maximum number of row return limit in CUIC reports. Currently it is returing maximum 8000 rows for each reports. Can we increase it ?
 
Regards,
Hammad.

This document was generated from CDN thread

Created by: Hammad Saleem on 02-12-2011 02:37:16 AM
Hi,
 
I am wondering if we casn increase maximum number of row return limit in CUIC reports. Currently it is returing maximum 8000 rows for each reports. Can we increase it ?
 
Regards,
Hammad.

[slyroman-87]

Hi All,

Can be used sql statement in query text or stored proc text:

SET ROWCOUNT X,

where X is  enough value

It was helpful for my custom report solution.

[Vinod Patil]

Hi Roman,

I am looking for similar solution so it possible for to share the Stored procedure or query text ? else explain the logic you have already used.

Please help me.

Best regards,

Vinod

[jacparke]

The 8K row limit for historical reports through CUIC is set in stone.  The reasoning is that too much of a good thing will overload the HDS or whatever other DB you have behind the curtains.  Also, if you are pulling 8K rows, you're not looking for information, you're looking for data - in which case it might make more sense to export it.

You can however, summarize within SQL in any way shape or form you like to return an aggregate that represents more than 8K rows.  An example would be the monthly summary reports.

Regards,

Jack Parker