UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Report Formatting similar to Excel    
 
   
Dangerous_
post Aug 25 2005, 04:43 PM
Post #1

UtterAccess Enthusiast
Posts: 59
From: NorCal - nuff said.
Hey there, I can't seem to get a handle on formatting reports to look as close to the way I format the same info in Excel.

I don't mind racking my brain, but I just wanted to see if anyone had some quick fixes or suggestions. Thanks!
Go to the top of the page
 
+
strive4peace
post Aug 25 2005, 05:42 PM
Post #2

UtterAccess VIP
Posts: 20,209
From: Colorado
how about using a query?

are you wanting the final output to be rows and columns?

do you have groups and subtotals?
Go to the top of the page
 
+
Dangerous_
post Aug 26 2005, 10:17 AM
Post #3

UtterAccess Enthusiast
Posts: 59
From: NorCal - nuff said.
I'm pretty sure I've got the query(s) set up correctly, and should be able to adjust them accordingly. The only thing is finding a way to apply the asthetic formatting (color, layout, conditional formatting, scaling to page) all automatically.

I haven't yet started digging in today, but that's next on the list.
Go to the top of the page
 
+
strive4peace
post Aug 26 2005, 01:13 PM
Post #4

UtterAccess VIP
Posts: 20,209
From: Colorado
I know there are posts in the archives about this -- I will look later. If you find something, please let me know so I don't look too.
Go to the top of the page
 
+
DReneau
post Aug 26 2005, 01:40 PM
Post #5

UtterAccess Enthusiast
Posts: 68
Greetings,

Here is the link to the file:

http://64.233.167.104/search?q=cache:7TqW5...ports&hl=en


and the file itself is attached. Found it @mvps.org it's the work of Pierre Tessier.
Attached File(s)
Attached File  GridReport.zip ( 16.68K ) Number of downloads: 2
 
Go to the top of the page
 
+
strive4peace
post Aug 26 2005, 01:52 PM
Post #6

UtterAccess VIP
Posts: 20,209
From: Colorado
thanks, David (IMG:http://www.utteraccess.com/forum/style_emoticons/default/wink.gif)
Go to the top of the page
 
+
« Next Oldest · Access Reports · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 23rd May 2013 - 05:50 PM