Izenda Reports easily works with databases having thousands, millions, or billions of rows. By default Izenda reports will not limit exports. This code will limit the exports to a certain number of rows if it is needed for security or performance reasons:
public override void PreExecuteReportSet(Izenda.AdHoc.ReportSet reportSet)
{
foreach (Report r in reportSet.Reports.AllValues)
{
r.Top = 10000;
}
}
The "show all" setting and "show all in viewer" settings will need to be set to false.