Hi there,
Does anyone know of a good solution to printing reports based on Objects and Collections? The free bit of Crystal Reports that comes with Access looks good for printing from Recordsets - but I have an Object-y data layer in my app, and I want to design and print reports on the data as simply as possible, without talking directly to the database (because this would break the "tiered" design of the app).
The best I can think of at the moment is to write a whole chunk of code that controls Word through VBA, accepts Objects and Collections, formats their contents, and prints them. Having to use Word seems a bit over the top (resource-wise) for a little printing - can anyone advise any better approaches?
Thanks a lot
Does anyone know of a good solution to printing reports based on Objects and Collections? The free bit of Crystal Reports that comes with Access looks good for printing from Recordsets - but I have an Object-y data layer in my app, and I want to design and print reports on the data as simply as possible, without talking directly to the database (because this would break the "tiered" design of the app).
The best I can think of at the moment is to write a whole chunk of code that controls Word through VBA, accepts Objects and Collections, formats their contents, and prints them. Having to use Word seems a bit over the top (resource-wise) for a little printing - can anyone advise any better approaches?
Thanks a lot
