Izenda, LLC

Ad Hoc Reports & Dashboards for ASP.NET Apps

Free Trial

Izenda Reports is licensed on a "per user" or "per server" basis. Please complete this form to receive a price quote.

All fields are required.

The live demo demonstrates Izenda reports with the Northwind Sample database. To login, please register below.

All fields are required.

You can download a full time-limited trial version here. Or, email a CSV file to data@izenda.com and our sales team will create several complementary reports on our demo environment.

All fields are required.

How do I add Field & Record Level Security Integration?

Expand / Collapse
 

How do I add Field & Record Level Security Integration?


Field Level Security Integration

Field Level Access

The field level property FieldFilterRegex is a regular expression property which filters based upon the string it's given. The user would not see any fields containing the words pass, admin or pw. Please see this example.

Record Level Security Integration

Row and Cell Level Access

Izenda Reports supports the unique feature of being able to hide report data on-the-fly on a per user basis. Consider this scenario: Bill, Mary, and John are all sales people. You want to generate the same report for each of them, but with different sales territory data. With Izenda Reports, simply generate one report, give each user a link to that report and change the filter for each user to show the specific sales data.

In this example, the PreExecuteReportSet method adds hidden filters to limit data on-the-fly.

public override void PreExecuteReportSet(Izenda.AdHoc.ReportSet reportSet)
{
  Izenda.AdHoc.Filter f = new Izenda.AdHoc.Filter("TerritoryID");
  f.Value = GetCurrentUserTerritory();
  reportSet.Filters.AddHidden(f);
}


Details
Type: FAQ
Options