Seperating the records in a Report...

[themanof83]

Hi,

I have a report that shows all the records of a crosstab query. Basically I would like to split the report up into three section. My main field in the report is "Section" which runs from 1-6.
In the report I would like to have Sections 1-3 seperate then section 4 on its own followed by sections 5-6.

Does anyone have an idea on how to make this happen? Thanks in advance.

Regards,

Ashley

 

[neileg]

Not quite sure what you want, but I would try using three subreports, each based on a query that returns just the sections you want.

 

[themanof83]

I've tried sub-reports and they take up too much space. Basically I want to split up the report into three sections after a certain 'Section' is returned in the report. So it'll look something like this:

Section ...............No. of tests
1 .......................3
2 .......................8
3 .......................23


4 .......................2


5 .......................16
6 .......................9

Hope that makes some sense.

 

[themanof83]

Thanks Pat.
Ok, I have figured out how to implement the grouping using the sorting and grouping dialog. But there is still a few problems:

1 - I'm not sure what u mean by add grouping code to the table?
2 - The sections are divided up into e.g. 1a, 1b, 1c etc. and the sorting isn't taking into account the second character. Therefore I am not getting the section in alphabetical order....
3 - Still unable to group the sections together i.e. Section 1-3 etc.

Thanx again for your help.

 

[neileg]

1 - I'm not sure what u mean by add grouping code to the table?

Add a new field into the table with the sole purpose of identifying how the records are grouped.

2 - The sections are divided up into e.g. 1a, 1b, 1c etc. and the sorting isn't taking into account the second character. Therefore I am not getting the section in alphabetical order....
3 - Still unable to group the sections together i.e. Section 1-3 etc.

See above!

 

[themanof83]

Thanks Neil,
Ok, I think I'm gonna stick to what I have at the moment as it gives me pretty much what I need, however I still don't understand why or how to get the "sections to fall into alphabetic order. Could this be to do with the complex crosstab query that is used for the report?

Regards,
Ash

 

[themanof83]

No I understand that, but what I am getting is unusual it goes

1f
1b
1c
1d
1e
1a

Then

2d
2b
2c
2a

But on section 4 it comes out correctly at

4a
4b
4c

Strange?????????