Displaying a menu structure via Crystal reports

Hi,

I have just started to use crystal reports and im trying to show a menu via the reports. I was going ok until I found that you can have a subreport with subreport, which leads me to believe that im doing things slightly wrong.

Here are the tables :

Menu
-------
MenuID
MenuName

MenuCourse
--------------
MenuCourseID
MenuID
CourseID

MenuCourseSection
----------------------
MenuCourseSectionID
MenuCourseID
SectionID

MenuCourseSctionDish
--------------------------
MenuCourseSctionDishID
MenuCourseSectionID
DishID
Description
Price

What im looking to do is to represent this data in this format :

MENU
  COURSE
    SECTION
      DISH
       DESCRIPTION      - PRICE

Can some point me in the direction of where to start looking. I have all the tables being pushed from a .net app, im using a xsd dataset based on the stored procuedure that fetches the data structure descrbed as above. I have all the tables linked. I guess what I needed to know is how to make this looping structure in crystal reports with subreports in subreports.

Thanks


jonnovAsked:
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.

Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
There is no need for subreports for this.  Simply use 5 levels of grouping.

As a side note, you CANNOT have a subreport within a subreport in Crystal.

- Ido
Mike McCrackenSenior ConsultantCommented:
You only really need 4 groups.  The Description and price will be the details in the DISH group

mlmcc
jonnovAuthor Commented:
Im going to need a little bit more information on this, as at the moment im in over my head with understanding CR.

I have added a group. I was kind of expecting it to work a little like subreports, with a detail body that I could use to repeat the grouped rows. But instead all I was supplied with was a group header and a group footer. Unsuprisngly neither of which provide what im looking for.

So I have added the group and selected to group by the MenuID in the MenuCourse table. Can some explain the next step please ?

Thanks
Exploring SharePoint 2016

Explore SharePoint 2016, the web-based, collaborative platform that integrates with Microsoft Office to provide intranets, secure document management, and collaboration so you can develop your online and offline capabilities.

jonnovAuthor Commented:
Just to expand a little more : In the detail I have added MenuName and underneath it have tried to add a group - like I would have done with a subreport.
jonnovAuthor Commented:
Sorry to keep adding to my own post - but group appears to be working like a group would in a database query, such as a group and sum, but can this give me the structure of :

MENU
  COURSE
    SECTION
      DISH
       DESCRIPTION      - PRICE
  COURSE
    SECTION
      DISH
       DESCRIPTION      - PRICE
  COURSE
    SECTION
      DISH
       DESCRIPTION      - PRICE

Etc
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Yes, it can.  Unlike SQL Group BY, which returns only summary info, Grouping in a report generatot returns all the detail and organizes it in a hierarchy of group levels.

Insert Group on Menu Name.
Insert Group on Course
Insert Group on Section
Insert Group on Dish

In the detail section, show the detail info you'd like to see.

Suppress GF1, GF2, GF3, GF4.

- Ido

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
dylanyeeCommented:
What Ido suggested is right.
CR group works like a hierarchy display of data.
Just put your Menu Name, Course, Section, Disk in the group header and description and detail section. supperss all group footer will do.
Try play around with the group thing and you will find it is what you want.

good luck~
dylan
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
Crystal Reports

From novice to tech pro — start learning today.