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

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Reports as "letters"    
 
   
ant0access
post Feb 7 2005, 01:27 PM
Post #1

New Member
Posts: 6



Hello
I have a quick question about data formatting. My data are grouped by a unique record ID number (say"01/2005", "02/2005", and so on...) and several features (say "1st category", "2nd category", and so on...). I would like to have the report looking like a list of bullets grouped by the category, as in the example below:

Report n. 01/2005
1st category
- first 1st category
- second 1st category
- ...
2nd category
- first 2nd category
- second 2nd category
- ...

How can I do that??

Thanks in advance
Go to the top of the page
 
+
jmcwk
post Feb 7 2005, 07:39 PM
Post #2

UtterAccess VIP
Posts: 12,201
From: Tacoma, WA.



Firstly Welcome to UA,

Open your report in Design view
Go to the top within the menu bar you will see a sorting and grouping Icon
Place your unigue ID on the first line
You will see at the bottom after doing this a window that will say Group header footer etc.
change Header to yes
place your unique ID control within this header
place your detail controls below in the detail section.

HTH
Go to the top of the page
 
+
AllinaLibrary
post Feb 8 2005, 04:58 PM
Post #3

UtterAccess Enthusiast
Posts: 53



I've just joined and have a related question to this...

I've got the group header and details for each group.

I put a page break in the group footer.

Everything looks great, but I'm having a problem with blank pages.

I don't understand because the report itself, in most cases, is a couple inches. It's the page formatting.

I got so frustrated I went into an entirely different database and was able to duplicate the problem.
Go to the top of the page
 
+
jmcwk
post Feb 8 2005, 05:12 PM
Post #4

UtterAccess VIP
Posts: 12,201
From: Tacoma, WA.



Did you check your margins on your print detail? File>page setup>margins

why do you need a page break? Just curious
Go to the top of the page
 
+
AllinaLibrary
post Feb 8 2005, 05:53 PM
Post #5

UtterAccess Enthusiast
Posts: 53



The margins are fine.

I need a page break because these are form letters.

Each letter is addressed to a customer detailing the charges for each cost center the person is responsible for.

In some cases, a person is responsible for more than one cost center.

I have the customer and cost center in a group header and a page break in a group footer.
Go to the top of the page
 
+
jmcwk
post Feb 8 2005, 06:54 PM
Post #6

UtterAccess VIP
Posts: 12,201
From: Tacoma, WA.



I can not see your report or visualize precisely what you are after but have you tried to use the force new page in the format of your header?
Open your report in design view
Go to your Header line in your report
right click
Go To Properties
Go To format
Force New page (look in here)
Also look at the other selections and play around with them

I am sure your are aware you can preview the report without saving to see what occurs when you make a change to the formating. Just for grins take your page break out and have a go with the formating of the header/s. that are based on your grouping/s.

If you want attach a zipped copy of your DB no more than 500000kb no sensitive data and I will be glad to take a look.

HTH
Go to the top of the page
 
+
HiTechCoach
post Feb 8 2005, 07:41 PM
Post #7

UtterAccess VIP
Posts: 18,396
From: Oklahoma City, Oklahoma



Putting a page break in the group footer will cause a blank page after each section including the last one.

Change it to the group header to page break before section. This will fix the problem.
Go to the top of the page
 
+
ant0access
post Feb 9 2005, 10:42 AM
Post #8

New Member
Posts: 6



Thanks to you all. I found your suggestions very effective.
Go to the top of the page
 
+
AllinaLibrary
post Feb 10 2005, 12:18 PM
Post #9

UtterAccess Enthusiast
Posts: 53



Thanks a bunch... the page break in the footer was the issue...

never needed page breaks before. THanks!
Go to the top of the page
 
+

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

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 20th May 2013 - 10:16 AM