It’s getting traditional — or at least seasonal. Tonight’s meeting of the Seattle VFP Special Interest Group was almost as wet as last month’s, but the attendance was a bit better – including one first-time attendee who claimed he had been drawn in by the pizza. :-)
Richard Stanton led us through a demo of the latest features in Europa reporting — in fact, this was the first time the reporting features had been presented in the US. He explained that there was a huge emphasis on extending the reporting features, rather than replacing them, so that our existing investment in FRXs would be protected.
The first thing he demonstrated was multi-detail bands. The example he used was an employee – orders and employee – territories pair of relations. He set up the employee table in the group, and then created two detail bands: one with orders for the controlling alias, and one with territories for a controlling alias. The report he generated looked like this:
Employee1
Territories
Territory1
Territory2
Orders
Order1
Order2
Employee2
etc.
This is… umm… non-trivial to do in earlier versions of VFP, but is almost trivial in Europa. Another thing he showed us was the possibilities of including the same detail band twice. He added another orders band, but instead of outputting the records in the detail band, he used report variables that reset after each detail band, and put the order count, total, and average order in the detail footer, which then displayed directly below the Employee header.
Another new feature is the PROTECTED keyword. Since the Report Writer is included in the runtime, it’s not uncommon to allow the end-users to modify the reports. This allows you to lock down given items so they can’t be modified, edited, or deleted.
Europa will also include a report builder. One example Richard gave was that now, if you double-click on a label, you don’t get a positioning dialog: you get a five-tab dialog that gives you access to all sorts of info, including the ability to edit the label text and to set absolute positioning (watermarks, anyone?). The architecture for this will be fairly open, so if you don’t like the supplied ReportBuilder.app, you can build your own.
If you open a Europa report in VFP8, it will open correctly if you’re only using a single band. If you have multiple bands, VFP8 won’t mess it up for you: it will just refuse to open it.
After that, we had some extra time, so YAG, Ken, and Richard collaborated on some free-flowing demonstrations of other Europa features. We saw auto-anchoring controls, that remained in the correct place as the form was resized. We saw rotating text and polygons (not just rectangles anymore!). We saw the different ways you can now put a picture on a CommandButton. In fact, we saw so many things I forgot to take notes, so those are just the highlights. :-)
We had two special guests tonight: Susan Graham, former Fox Software employee and VFP manager elaborated a bit on a story from Fox Tales involving Dave Fulton, a new 4-wheel-drive truck, an Ohio snowstorm, and an enforced workday; and Robert Scoble popped in to see the new Europa stuff that I invited him to check out.
The next meeting will be Monday, December 15th. We have a tentative speaker: I’ll post in the usual places as things finalize. See you there!