How to Generate Report Using Crystal Report

I have a database with two tables( Master, Detail) I want to create the report using Crystal Report so that Each Name has one page with displaying all the records  from Detail Table( fields). Once I generate report Using Crystal Report Wizard its show all the records of all the names. But I want each “Name” having separate page showing all the records of that individual (Name, Rank, Category, Number from Maser, and then Number,Date,Time,Condition,Comments from Detail). Can Some one guide me


Name, Rank, Category, Number

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

In the crystal report you need to group by the Master Name.

In the master name group area you can insert each of the fields i.e. Name, rank, category, number

In the detail section add the detail you want.  

If you right mouse click on hte Master group there is an option to pagebreak after the group.  This way it will print all of one group  and its details then go to a new page to work with the 2nd group etc.

The comment which abaldwin has written is right.You need to create a group as Name and then click on format and then click on Section.A new form opens up on that go to the group footer section and then tick the option new page after.
This will ensure that every name comes on a new page.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
fmuftiAuthor Commented:
Can u tell me the steps to follow, as in step 4 the tab which is labelled sort, the grouping option is availbale but once I grouped it by NAME:MASTER there is no option like "create a group as Name and then click on format and then click on Section.A new form opens up on that go to the group footer section and then tick the option new page after. "
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

First you have to create a group.
In the group you can place all the items which are of the table master and in the detail sections you can keep all the detail table stuff.

Once the group is created then you can say pick format from the main menu option and click on section.Another form pops up which has all the headers of the report like Report Header Page header Group Header Details report footer group footer etz.
Highlight the group footer and there is a list of options available on the right hand side select the new page after
This will ensure that on change of every name it will print in the new page
I hope you got what is to be done if not leave a comment and i will ans it
fmuftiAuthor Commented:
Yes I'll able to do so but the Group Caption is missing e.g as grouping is done by name so each page has records of different name now but there is no caption that these records belong to XYZ, although on the page if XYX has 5 records then it written as
XYX   (1)
XYZ   (2)
XYZ   (10)
I want it like


Hope to hear from u asp, Still thanx for guiding me.
I am not sure what caption you are talking of well if you have a field as caption then you can paste it next to the group name or you can actually not choose to print the name and remove the name which is to be printed

for eg
if you have created a group by name then it appears as

Group1 Name

if you want you can remove the text name
Group1 name
 What i mean is that you can remove the text and place some other text depending upon what you want to see for that group

I hope I have answered to your question.
If not leave a comment i will answer it
fmuftiAuthor Commented:
Once I view the report in VB, the records are old one, why report doent get updated. Although  this may not prtain to my question but still if u could help me. However ur poitns have been awarded!!!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.