Overflow and group by genre

[Guest]

I am making a DVD database with reports listing the movies. I have
two columns of text boxes listing the titles of the movies on one page of the
report. So when the text gets to the end of a page, instead of stating a new
page, overflow into the next column on the page then when that column is full
go to the next page. For example titles 1-25 in the first column one page 1,
titles 26-50 in the second column on page 1 and titles 51-75 in column one on
page 2.

I have movies Listed by Genrei would like to make a report with all movies
listed my genre and then alphabetcal order. Say there are 9 only movies per
genre. I want the title of the group to be Comedy and then a 3X3 block of the
movie titles. 3 down 3 across. then the next to be documentries., three down
the three across.

 

[Marshall Barton]

I am making a DVD database with reports listing the movies. I have
two columns of text boxes listing the titles of the movies on one page of the
report. So when the text gets to the end of a page, instead of stating a new
page, overflow into the next column on the page then when that column is full
go to the next page. For example titles 1-25 in the first column one page 1,
titles 26-50 in the second column on page 1 and titles 51-75 in column one on
page 2.

I have movies Listed by Genrei would like to make a report with all movies
listed my genre and then alphabetcal order. Say there are 9 only movies per
genre. I want the title of the group to be Comedy and then a 3X3 block of the
movie titles. 3 down 3 across. then the next to be documentries., three down
the three across.

Use Sorting and Grouping (View menu) to specify the grouping
by genre and sorting by title.

 

[Guest]

I cant get the group to go down then across, and stay in the group. is should
look like this. this is with 3 columns

Group 1
1 4 7
2 5 8
3 6 9

Group 2
10 13 16
11 14 17
12 15 18

 

[Marshall Barton]

But that's normal behavior, there should be no problem
getting down then across columns, unless this is in a
subreport.

Maybe you're complaning about the group header being in the
column with the first data item??? If you want the group
header to span the entire page, then the multi column data
will have to go in a subreport. But then it will have to be
across then down and to arrange the data so it looks like it
would if Down then Across worked in subreports requires a
calculated field in the subreport's record source query.

The main report's query would just be:

SELECT DISTINCT genre
FROM thetable

The subreport's record source query would look something
like:

SELECT T.genre, T.title,
numcolumns * (SELECT Count(*)
FROM thetable As X
WHERE X.genre = T.genre
AND X.title < T.title) \
(SELECT Count(*)
FROM thetable As Y
WHERE Y.genre = T.genre)
As ColNum
FROM thetable As T

And the subreport control's Link Master/Chile properties
would be set to the genre field. And the subreport's would
use the ColNum field to sort the data.

 

[Marshall Barton]

No, don't send it. I get paid for doing that kind of work
and I'm too busy to get to it in any reasonable amount of
time.

You should try to explain what you've done and what the
results were as I requested.

Are my suggestions confusing you so you don't know what I'm
talking about or are you having trouble translating what I
said to your situation?