473,320 Members | 2,107 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Help with MS Acces which relates with reports!!!!!!!

I had produced a report with a list of nurses in that ward. Know, i need to show each ward on a separate page, when all are on 1 page! How do i solve this?
Nov 9 '06 #1
1 1158
NeoPa
32,556 Expert Mod 16PB
Open the report in design mode.Click on 'Sorting and Grouping' from the Report Toolbar.
Make sure you set up a group for the ward field, whatever you've called it, and ensure that 'Group Header' is set to Yes.
Close 'Sorting and Grouping' and select the newly created section of the report - named 'Ward Header' or something similar.
Set 'Height' property to 0 and 'Force New Page' property to 'Before Section'.

Obviously there's a lot more in there that you can play with but that's the basics of what you're after.
Nov 9 '06 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Maqsood Ahmed | last post by:
Hello! I am new to Crystal Reports and I have been trying this for last 3, 4 days. Scenario 1: I have a strongly typed DataSet (.xsd) and I don't populate it from Database. I have added a...
1
by: BiATZIFLOM | last post by:
Hi there i need some help with quick reports for borland. i have the following: C++ builder 5 Form with a QuickReport on Using BDE SQL Query: select * from contact, contactperson where...
2
by: matthew | last post by:
Hi all, Excuse the ignorance, but I'm like a blind man trying to navigate a maze here... I have two access tables called "material" and "job". I need to make a report that lists all...
1
by: Charles | last post by:
Hello, Questions 1. Can I use stored procedures with Crystal in VS ASP VB 2003 and if so how? 2. Is there a good how to white paper for VB the Crystal people have their examples in C#.
3
by: Deasun | last post by:
I need some help please! Crystal is driving me nuts. Heres my code so far, see below. Problem: On the .export() line it comes back with error #5 Login failed! I know the login info is good so...
7
by: John | last post by:
I am using Crystal Reports in my application I made using Visual Studio.NET. I installed my application on the client machine, with all the DLLs required(added the merge modules), the engine and...
0
by: KK | last post by:
Hi, How to combine summary, detail reports into one report? I have a summary report summary.rpt, detail report detail.rpt I want to export these reports into a pdf file. I want to display...
0
by: rfrenken | last post by:
I am trying to write a database query in an old version of Crystal Reports (7.0) that finds all of the accounts with multiple late fees and then prints out the details of those lines. I have the SQL...
4
by: gnawz | last post by:
I need to generate 3 kinds of reports... I have a date field in MySQl database whose data type id DATETIME daily I need to show reports of sales of the day so my SQL should be sth like $sql =...
5
by: gggram2000 | last post by:
hi there, I have a windows based program in visual studio 2005 using C# and sql server 2005 as backend. It's the first time I am trying to use Crystal reports, from what I have now is simply a...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.