?
Solved

Subdatasheet

Posted on 2006-11-24
7
Medium Priority
?
849 Views
Last Modified: 2008-02-01
How do I get the formatted results of a query with a subdatasheet to Excel?  Needs to be emailed so I need it in Excel.  I want the reader to be able to collapse the summarized totals of the query to see the details in the subdatasheet.
0
Comment
Question by:error_prone
  • 5
  • 2
7 Comments
 
LVL 34

Expert Comment

by:jefftwilley
ID: 18008902
Do you mean a report?
0
 

Author Comment

by:error_prone
ID: 18008909
Will if you export the report in Snapshot view, will it still allow the expand/collapse capability?  
0
 

Author Comment

by:error_prone
ID: 18008927
automatically...
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 34

Accepted Solution

by:
jefftwilley earned 1500 total points
ID: 18008948
No, snapshot view is just that...it's non-interactive after that. You can however export as html then you can open it in excel. I do this when I want to keep the report formatting. I wrote a code module that exports my report as html, renames it as .xls

Give that a try and let us know if that's what you're after.

J
0
 

Author Comment

by:error_prone
ID: 18008950
nevermind, I did it in Excel.
0
 

Author Comment

by:error_prone
ID: 18008952
There's a Subtotal option in Excel
0
 

Author Comment

by:error_prone
ID: 18009530
Saving it as html is an interesting idea, although it doesn't really save all of the formatting.  The color and any bordering applied is gone.
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question