Hi, I have found various threads and such like regarding this. However, none of them make a great deal of sense to me. Could someone please explain to me how I would specify the number of records to be displayed on a single page. A way without code (or very little code) is prefered if possible but I can use code if absolutely necessary. It is for a school question and I just feel like there has to be a way without programming as it specifically says in the syllabus that no programming ability is expected... but anyway, any help would be appreciated. I am using a query bringing in fields from different tables and basing the report on this query. I want to have only four entries per page.

Thanks Hugely in advance

Jason

Hi, I have found various threads and such like regarding this. However, none of them make a great deal of sense to me. Could someone please explain to me how I would specify the number of records to be displayed on a single page. A way without code (or very little code) is prefered if possible but I can use code if absolutely necessary. It is for a school question and I just feel like there has to be a way without programming as it specifically says in the syllabus that no programming ability is expected... but anyway, any help would be appreciated. I am using a query bringing in fields from different tables and basing the report on this query. I want to have only four entries per page.

Thanks Hugely in advance

Jason

Jason,

Since this is a class assignment, you really should review the course ware/book/lecture notes/etc. to see how you should do it.

We can give you solutions, but it may not he the one that the instructor is expecting as the correct answer.

Thanks for your reply HighTechCoach. I see what your saying and that issue has crossed my mind with problems such as this one. However, on reviewing thew syllabus and such, I think with this it really is just do it as you see fit, as long as you have a method of doing it' and its watertight', it's fine. I think it's just trying to get me thinking how I could do it as there isn't anything specifically on this issue in the syllabus. It just states that, basically, I have to have knowledge with working with reports and there are no specific answers in any resources I have and, typically, my teacher is ill and has been for over a week now! The syllabus says "no knowledge of programming is expected but any solutions that incorperate programming is totally acceptable."

So any solution ideas would be appreciated just to help me along a bit if you don't mind because my knowledge of reports is my weakest area currently as the knowledge just isn't there and I have no clear cut way of obtaining the knowledge at the moment.

Thanks again

Okay, here's a general idea:

Create a group in your report based on the PK field and set the Group Interval to be 5 and then in the report have a group header and in the group header properties set the FORCE NEW PAGE to be one of the options listed (one of them will give you what you want).

There - a more specific hint but with some left for you to figure out.

Thanks a lot for you response boblarson. I'll try what you said right away :)

Right, I have set the 'force new page' property to 'before section' and this breaks each group up onto separate pages which is fine. I assume the 'group interval' property somehow allows me to include more than 1 group per page when used in conjunction with the 'force new page' property. However, I have changed the 'group interval' to 5 in the 'grouping and sorting' section and it seems to make very little change to anything. I can sort of see what the 'group interval' property might do but I can't quite get it to work the way I want.

Any extra hints would be appreciated

Thanks

What did you group on? What field?

Also, it is Force New Page AFTER Section that you want.

If I force new page after section, only the field in the 'first layer' of the group is included on a page and the other layers are put onto a new page. Before section seems to do half the job though... but anyway, I set group interval on the field in the 'top layer' of the group.

Thanks

What field would that be? What type of data? What are some of the values?

Also, since you have other groupings ("layers" as you are calling them), you would have to include a footer for the top group (it can be sized to nothing) and then the Force New Page after that section should work better.

It's the 'PerformanceDate' field and it is a date/time data type (short date format). I have created the footer for this field and the 'after section' value does now work as in each page contains single, but completed sets, of groups. Now just to add 3 more groupings to each page...

Thanks a lot

It's the 'PerformanceDate' field and it is a date/time data type (short date format). I have created the footer for this field and the 'after section' value does now work as in each page contains single, but completed sets, of groups. Now just to add 3 more groupings to each page...

Thanks a lot

When you set the group interval did you also set the GROUP ON property to INTERVAL as well?

Now for a date field that would group by day (5 days) if you have that. So what you need is some sort of numbering added to the query to just number the records so you can group on that to start with.

There is no value called 'interval' that I can select. There is only 'prefix characters' and 'each value' that is selectable. If I use the 'ticket number' field as the top group, would that make it easy to do/ The ticket number field is a text field and each value takes BKR0... plus a three digit number at the end that varies, obviously, with each ticket?

Thanks

I have tried it on the ticket number field (with it as the top group) and I get the same result. There is only a single grouping on each page. The group interval still seems to be having no effect...

Any further help would be appreciated

Thanks

As this is a project that doesn't appear to have sensitive data, how about uploading a copy of what you have and I'll take a look to see what might need to happen?

That would be great - Thanks. Here is the database. It's a bit messy cos it is only a practice database at this stage but hopefully you can find your way around easy enough. All the data is just test data created by me...

Thanks a lot for your time

Note:Please Use 01/01/2010 for the parameter asked for when loading the report

I have now achieved what I needed to achieve everybody. Thanks for all your help on this.

Jason