Access 2007 Reports Demo

Published 23 August 07 05:20 PM
I can't resist doing a quick post to let you all know about the new report demo that just got published to OfficeOnline.  This is a quick little video, just a few minutes long, which gives a great overview of some of our new reporting features in 2007.  Big thanks to my engineers, Steve Lesser, Abigail Short, and Nishant Kumar for helping me to make these features a reality!

Comments

# Abigail said on August 23, 2007 1:41 PM:

You're welcome! Yay for design in browse.

# William said on August 23, 2007 2:45 PM:

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

# Zac Woodall said on August 23, 2007 3:34 PM:

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.  

# M. David Matney said on August 23, 2007 6:44 PM:

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?

# Danny Sands said on August 24, 2007 8:48 AM:

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.

# Zac Woodall said on August 24, 2007 11:39 AM:

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 :).

# Dave T said on August 24, 2007 7:05 PM:

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.....

# clintc said on August 24, 2007 11:56 PM:

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.

# Alan Cossey said on August 25, 2007 12:43 PM:

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.

# Zac Woodall said on August 25, 2007 8:17 PM:

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!  

New Comments to this post are disabled

About Zac Woodall

Zac is a Program Manager at Microsoft on the team designing Access’s next generation platform infrastructure. He advocates easy to use designs, organizes community efforts, and is the author of The Rational Guide to Microsoft® Office Access 2007 Templates. Zac has been working at Microsoft Corporation since 1999. Before that time, he attended the University of Idaho, from which he holds a B.S. in Computer Science.
Page view tracker