Izenda Reports 6.4: deducing logical data joins

by Izenda Eng on June 13, 2011

(This is the start of a series of posts on the new Izenda Reports 6.4, presently at the Release Candidate stage.)

Smart joining of data sources

Ever try to explain what SQL joins are to a user? Izenda Reports in version 6.4 adds a very nice feature that takes the mystery and guesswork – and the calls for tech support – out of situations where users are unsure of which joins in a complicated relationships can be included in a report.

With a few clicks– Izenda Reports deduces the table joining relationships for the user. A new simplified data sources GUI automatically disable data selections that would create nonsensical joins.

You can try Smart Joins in our online demo of Izenda Reports.

Code sample:

AdHocSettings.ShowDataSourcesAsCheckBoxes = true;
AdHocContext.Driver.AddConstraint(“User.Id”, “Account.OwnerId”);

Here’s a screencast of Izenda Reports deducing valid data joins in action:

Comments on this entry are closed.

Previous post:

Next post: