Report Question

[DavidW]

I have got a very short report
in the detail it is only 5 lines long
how do you make the detail area equal your report instead of it filling the
detail area the entire length of the sheet.example

line1
line2
line3
line4
line5
then stop, instead of
line1
line2
line3
line4
line5
line1
line2
line3
line4
line5
line1
line2
line3
line4
line5
line1
line2
line3
line4
line5

thanks
david

 

[Marshall Barton]

I have got a very short report
in the detail it is only 5 lines long
how do you make the detail area equal your report instead of it filling the
detail area the entire length of the sheet.example

line1
line2
line3
line4
line5
then stop, instead of
line1
line2
line3
line4
line5
line1
line2
line3
line4
line5
line1
line2
line3
line4
line5
line1
line2
line3
line4
line5

That's confusing. Are Line1, 2, ... controls in the report
or are they supposed to represent records in the report's
record source?

Is there a subreport involved?

What is the record source for the report?

If it's a table or a query, open it from the database window
and check if the report is displaying the same data.

 

[Fons Ponsioen]

I suspect you have the report based on a query, and I
suspect the query is the cause of the repetition of the
data.
Look first at the underlying query in design view and than
run the query and see what the result is.
If, as I suspect the query repeats the data you may want
to look at the query design to eliminate the duplication
or otherwiase set possibly the property of the query to
show unique values only.
Hope this helps.
Fons

 

[DavidW]

That's confusing. Are Line1, 2, ... controls in the report

or are they supposed to represent records in the report's
record source?

they are from a record source

Is there a subreport involved?
no

What is the record source for the report?
query

If it's a table or a query, open it from the database window
and check if the report is displaying the same data.

same

problem maybe that I need to add row information(as in a label) that changes
with different lines, I only need 1 sheet, what it does is it prints the
label that I have added to the detail area over and over.
Is there a way to limit the report to one sheet and be able to add labels
inside of the detail area?

Marsh
MVP [MS Access]

 

[Marshall Barton]

they are from a record source


same

problem maybe that I need to add row information(as in a label) that changes
with different lines, I only need 1 sheet, what it does is it prints the
label that I have added to the detail area over and over.
Is there a way to limit the report to one sheet and be able to add labels
inside of the detail area?

Before you worry about the report, you have to get the query
to return the correct number of records. Please post the
query.

 

[DavidW]

It does return the correct info, the problem is I am trying to replicate an
old spreadsheet report. I am putting labels in the detail area, and I
believe that is where my problems lye. I can delete the labels and
everything is fine. Unfortunatly I have some people here that want to keep
the looks of the old form.
And I want to get rid of the spreadsheet senerio.
Is there a way to limit a report to one page only? I can get a page to work
out but there a 3 other pages associated with it.
A good example of my problem would be to start a new report and put a label
in the detail area. This will recreate my problem.
I need a report that will have different rows of information from different
fields, example

supplier type address gallons recieved
charlies gas miami,fl 15,000 august
21,050 september
31,800 october

billys diesel ny,ny 10,000 august
1,000 september
500 october
any ideals?

 

[Marshall Barton]

It does return the correct info, the problem is I am trying to replicate an
old spreadsheet report. I am putting labels in the detail area, and I
believe that is where my problems lye. I can delete the labels and
everything is fine. Unfortunatly I have some people here that want to keep
the looks of the old form.
And I want to get rid of the spreadsheet senerio.
Is there a way to limit a report to one page only? I can get a page to work
out but there a 3 other pages associated with it.
A good example of my problem would be to start a new report and put a label
in the detail area. This will recreate my problem.
I need a report that will have different rows of information from different
fields, example

supplier type address gallons recieved
charlies gas miami,fl 15,000 august
21,050 september
31,800 october

billys diesel ny,ny 10,000 august
1,000 september
500 october

I really don't understand what effect you're trying to
achieve.

Whatever it is, the data for the report needs to be
controled from the query. As a wild guess, maybe you can
limit the query to the number of records that will fit on
one page by setting its Top Values property to an
appropriate number.

 

[DavidW]

Have you ever had one of those things that you couldnt get off the tip of
your tongue- well, this is one of them.

Its almost like I need to group.

I can get it to work in columns but not seperated.

{This started with 5 lines-progressed to 6 lines}

If you had a textbox named "1", and you had 3 different entries in the
record, this would produce 3 records (different lines) on the report.

now if you had a textbox named "2" and you had 3 different entries in the
record, this would produce 3 records (different lines) on the report.

how would you group all records for "1"
then go below "1" totals and start with "2"
example

group for "1"
line1
line2
line3
total for "1"

group for "2"
line1
line2
line3
total for "2"

instead of

line1-"1"
line1-"2"
line2-"1"
line2-"2"
line3-"1"
line3-"2"

this is almost like a mathmatical blackhole!

 

[Marshall Barton]

Have you ever had one of those things that you couldnt get off the tip of
your tongue- well, this is one of them.

Its almost like I need to group.

I can get it to work in columns but not seperated.

{This started with 5 lines-progressed to 6 lines}

If you had a textbox named "1", and you had 3 different entries in the
record, this would produce 3 records (different lines) on the report.

now if you had a textbox named "2" and you had 3 different entries in the
record, this would produce 3 records (different lines) on the report.

how would you group all records for "1"
then go below "1" totals and start with "2"
example

group for "1"
line1
line2
line3
total for "1"

group for "2"
line1
line2
line3
total for "2"

instead of

line1-"1"
line1-"2"
line2-"1"
line2-"2"
line3-"1"
line3-"2"

this is almost like a mathmatical blackhole!

I'm beginning to suspect that your table/query is poorly
organized and that this is the source of a lot of my
confusion.

OTOH, maybe there's some terminology confusion. I'm not
even sure we're using the word "record" to mean the same
thing.

At this point, I don't see how I can proceed on this problem
until you explain the fields in the table (not the report)
and post a copy of the query's SQL statement.

 

[DavidW]

My query is fine, it is displaying all the information needed for the
report, my problem is, I cant get it on the report like I need.
The query is a quarter query that has entries from 3 months. This query does
pull all of the information needed for the report for the past 3 months, my
problem is I am trying to group by rows and not by columns. If I leave
things as is on the report ,I have an alternating report month by month by
each product. What I am wanting to do is too group by rows and end up with
product by quarter on the same report.
example
onroad is txtb 1
onroad gallons is txtb2
offroad is txtb 3
onroad gallons is txtb4
month is txtb 5

(this is what I currently have on the report)
on-road diesel october 2000
offroad-diesel october 3100
on-road diesel november 5300
offroad-diesel november 1100
on-road diesel december 6100
offroad-diesel december 3300

what I would like to end up with is
on-road diesel october 2000
on-road diesel november 5300
on-road diesel december 6100

offroad-diesel october 3100
offroad-diesel november 1100
offroad-diesel december 3300

there are many ways to get the same result
like a mathmatical blackhole

prime 3 4 5 to infinety
multiply by 6 18 24 30
add 12 30 36 42
divide by 3 10 12 14
subtract your prime twice 4 4 4
you will always end up with 4 with the above equasion

Thanks
David

 

[Marshall Barton]

I'm still real fuzzy about this, but try using the report's
Sorting and Grouping window to specify a group on whatever
field has the onroad/offroad values.

 

[DavidW]

how does grouping work?
this is the first time I have used grouping in reports, my results of what I
did were not desirable!
how would you sort/group what was disscussed earlier?

 

[Marshall Barton]

how does grouping work?
this is the first time I have used grouping in reports, my results of what I
did were not desirable!
how would you sort/group what was disscussed earlier?

In the Sorting and Grouping window, under the
Field/Expression heading, select whatever field from the
report's record source contains the values "onroad" or
"offroad" .

This means that you want to sort by the values in that
field. In other words, you want all the offroad details
together and all the onroad details together.

If you also go down to the list of properties in the bottom
section of the Sorting and Grouping window, you can enter
Yes in the Header property. This will create a group header
section where you can place labels, text boxes, and other
controls to display values specific to the group (i.e.
values that are the same for all the details in the group).
You could also create a group footer section for similar
values that you might want to appear after the details.

One important feature of group headers and footers is that
you can use a text box with an aggregate funtion to display
a group total. E.g. a text box with the expression
=Count(*) will display the number of details in the group,
or another text box could use the expression
=Sum(gallonsfieldname) to display the total gallons in the
group. It is very important to keep the terminology
straight here, a field is a column in a table or query,
while a control (e.g. text box) is a tool that displays
values on the report. The aggregate functions only know
about fields, they are unaware of controls. so keep the
names straight.