Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Subdatasheet

Posted on 2006-11-24
7
Medium Priority
?
847 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

636 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