Access 2007 Reports Demo

You're welcome! Yay for design in browse.

Looks great! Question is the fix for the reports not working in Access runtime for adp files coming soon?

William, we're working on getting that fix for Reports in ADPs out now. It is done and in our final testing and release process.

Hate to post this in a place like this, but that what happens whe the runtime blog is closed after 7 days. Is there any white papers that discuss using the Quiet Install of Access 2007 Runtime on Windows Vista. I have installshield installing the AccessRuntime.exe with the /Q switch and it works fine on Windows XP HOWEVER, on windows vista, it is failing and I suspect it has something to do with the new vista security. So how can we have the quiet install of AccessRuntime.exe on Windows vista and actually have it install when the AccessRuntime.exe is kicked off by InstallShield?

Nice touch on the Layout Reports Demo~! I really appreciated the overview as I have been a little frustrated with the Layout view when working with Forms. Seeing how the Layout view simplifies the building and formating of reports in fact will help me with the challenges I experienced earlier with the Forms.

Great feedback Danny! The primary goal for the Layout view work we did in 12 was to make report building easer. We know it isn't ideal for forms, yet... expect some improvements there in 14 :).

I can get my data out, but how do I get my data definitions exported in 2007. I can not find a way to build a report or use an export function that lists table name, data element, data type and description. I used to have a special report for older versions, but doesn't work on 2007. Help, I don't want to have to retype over 600 data elements into excel.....

Not sure why your old report doesn't work. Can you give us more information about that? You can use the database documentor to export table name, data elements, and data types to XPS/PDF. The database documentor is found on the database tools tab.

I have to say that I am impressed with the changes to reports. As well as the stuff shown in the demo, enabling controls like buttons and option groups to work on reports is really helpful. Now we can get all the benefits of the groupings and summaries that reports give us yet still do things like filter depending on the value in an option group on the actual report and alter that value without having to leave the report to go back to a form if we open the report in Report view. The lack of formatting events has not been a major problem with my work so far.

Also, and it is a really simple thing, but one customer really likes just being able to scroll the entire length of the report without having to click to move between pages.

Dave T: if you're trying to export a report to Excel, Access 2007 no longer has that functionality. Microsoft was inconveniently required to remove that functionality. In this case, I recommend exporting a continuous form or a query instaed. Thanks!