Link to home
Start Free TrialLog in
Avatar of svfafel
svfafel

asked on

Exporting reports to Excel

i am trying to get some reports with limited grouping to export to Excel and look good...Any tips?  My grouping tends to look ugly and the headings are all messed up....Anyone out there an expert at making an Access report export to excel and still look good?

Thanks in advance...
Avatar of tdaoud
tdaoud


I can suggest that you try first to Word then import from Word, it might look better.

Good Luck,

Tarik
My work-around in the past has been to export the reportto my file.  In my file I have a macro that runs on open and does my formatting for me.  There are articles on Microsoft.com that deal with exporting reports if you are seeking further info.
Avatar of svfafel

ASKER

Psycho, any links to microsoft articles?
Forget Excel....Save as/export as .RTF, and open in Word the only formating you will lose is lines. It looks great.  
I have had problems exporting to RTF as well.  Let me look for the article svfafel.
Avatar of svfafel

ASKER

much appreciated...
ASKER CERTIFIED SOLUTION
Avatar of PsychoDazey
PsychoDazey

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
the key is to not use group headers or footers. what you need to do is put ALL your controls on the detail screen and then run your report.

it's a lot harder to get the desired effect, but when you export you won't get ton's of "goofiness" that can happen.

basically all you can do is fiddle. export. fiddle. export. fiddle. export etc. until you get the desired output.

enjoy.

dovholuk
Another one, svfafel.

This is a free technical support site.

Experts who answer questions here receive no pay or other compensation except Expert points as a result answering questions and being awarded points.

As a result, and as a Moderator of this forum, my goal is to ensure that Experts and Askers alike no longer allow questions to get stale.

Please provide that feeback now. It's greatly appreciated!

If you need any help at all in cleaning up this or any other questions, don't hesitate to contact me via email. I will assist in any way that I can.

thanks
amp
community support moderator
amp@experts-exchange.com
svfafel:

You have many open questions:

https://www.experts-exchange.com/jsp/qShow.jsp?qid=20151411
https://www.experts-exchange.com/jsp/qShow.jsp?qid=20142486
https://www.experts-exchange.com/jsp/qShow.jsp?qid=20152290
https://www.experts-exchange.com/jsp/qShow.jsp?qid=20153618
https://www.experts-exchange.com/jsp/qShow.jsp?qid=20155682
https://www.experts-exchange.com/jsp/qShow.jsp?qid=20169125
https://www.experts-exchange.com/jsp/qShow.jsp?qid=20175800
https://www.experts-exchange.com/jsp/qShow.jsp?qid=20180978
https://www.experts-exchange.com/jsp/qShow.jsp?qid=20190767
https://www.experts-exchange.com/jsp/qShow.jsp?qid=20169126
https://www.experts-exchange.com/jsp/qShow.jsp?qid=20146852
https://www.experts-exchange.com/jsp/qShow.jsp?qid=20128521
https://www.experts-exchange.com/jsp/qShow.jsp?qid=20134835
https://www.experts-exchange.com/jsp/qShow.jsp?qid=20136451

To assist you in your cleanup, I'm providing the following guidelines:

1.  Stay active in your questions and provide feedback whenever possible. Likewise, when feedback has not been provided by the experts, commenting again makes them receive an email notification, and they may provide you with further information. Experts have no other method of searching for questions in which they have commented, except manually.

2.  Award points by hitting the Accept Comment As Answer button located above and to the left of that expert's comment.

3.  When grading, be sure to read:
https://www.experts-exchange.com/jsp/cmtyQuestAnswer.jsp#3
to ensure that you understand the grading system here at EE. If you grade less than an A, you must explain why.

4.  Questions that were not helpful to you should be PAQ'd (stored in the database for their valuable content?even if not valuable to you) or deleted. To PAQ or delete a question, you must first post your intent in that question to make the experts aware. Then, if no experts object after three full days, you can post a zero-point question at community support to request deletion or PAQ. Please include the link(s) to the question(s).
CS:  https://www.experts-exchange.com/jsp/qList.jsp?ta=commspt
At that point, a moderator can refund your points and PAQ or delete the question for you. The delete button does not work.

5.  If you fail to respond to this cleanup request, I must report you to the Community Support Administrator for further action.

Our intent is to get the questions cleaned up, and not to embarrass or shame anyone. If you have any questions or need further assistance at all, feel free to ask me in this question or post a zero-point question at CS. We are very happy to help you in this task!


thanks!
amp
community support moderator

2/6