July 22, 200619 yr 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?
July 22, 200619 yr 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
Create an account or sign in to comment