Relationship Variable

[Steverino]

I should probably know how to do this...but I'm a bit stumped right now.

How do you get a particular related record based on a variable? In other words, I've got Companies related to Employees and their job titles. Now I want to produce a columnar report with all of the Companies running down one axis, and the jobs on the other...and the employees in the grid. This seems like it should be easy, no? Do I have to go the html route? Is there a good sample solution I can dissect?

[Søren Dyhr]

Crosstabs have for long been on the wishlist, and yes the new html does it, where you previously were bound to some workarounds:

http://www.kevinfrank.com/download/repeating-lookups.zip

...which doesn't scale well, aggregate functions are optimized to be dealing with some 40 related records max!

--sd