Manage groups in Crystal Report

Phillip Burton
A free video tutorial from Phillip Burton
Best Selling Instructor - over 250,000 students so far
4.5 instructor rating • 40 courses • 255,366 students

Lecture description

Suppose we wanted to make changes to our grouping. Let's find out how to manage groups.

Learn more from the full course

SAP Crystal Reports 2016 - An Introduction

How to create reports quickly and easily. For SAP Crystal Reports 2008, 2011, 2013 and 2016

05:44:29 of on-demand video • Updated October 2020

  • Have a good knowledge of Crystal Reports, having installed it on your laptop.
  • Know about the different types of data sources, and how to create a report from scratch, including grouping, sorting and filtering/selecting.
  • Be able to format dates, numbers, text and other fields, insert and format graphics and other objects, and know when and why to insert additional sections.
  • Find out why hard-coded figures do not give the best interaction to the end-user, and use parameters to overcome this problem.
  • Add all manner of graphs, from bar charts to pie charts, radar charts and more.
  • Create subreports and drill-down reports, including using Cross-tab (PivotTables) in these reports.
  • Know what types of formulas are available, and how they can be used.
English [Auto] Write well just want to talk about managing the groups. If you remember we've got two groups set up so we've got one group which is based on the older date in ascending order and one which is based on the ship via an ascending order. Now we can manage that in the sense of we can change it how we want. And this is the great way of quickly creating alternate reports based on the same information just a different view. So for instance we've got everything good which is in date order so we start off native every 90 for every first if ever. And then we have the ship here. But what if you wanted to look at all the ship Viers first. So we wanted to have his first Lemus or whatever it is is first alphabetical order and then we have a look at all of the dates. So the set of here is a list of all the dates. And this is when the ship how the ship. Why not have here is how this shipped. And in each one of these are the dates so we can do that quite easily by going back to our group ex-parte which is also cycled here. So here we have our two groups and you can see the hierarchy. This is why this second one is indented. Now we can trace the hierarchy just by going up or down. So I can either make this one or the data go down. So it puts it below what was immediately below it or arc can make the older date go up and up. So now we found much ado and you can now see that we got the ship fear on the top and all the data at the bottom. So good I can see what happened over here. So now we have the ship at the top and the other day. And the second one and the previous report instantly we got all of the FedEx's together and only if I just flipped through it will then go to the next one or train Lumines altogether in data folder and then we just start with the result with parcel post and that sort of thing altogether. Alternatively you may say well I now want to. So I want to group instead of by date. I want to group all them all of them together. So I've actually got all the orders or to date you can say this section will be printed for each day so we can change that to for each month. So for now click OK. A quick preview. You can see that we have a whole number of orders which were for February 2000 and for. And here we have Fabri 2003 altogether. So I would use the amount of headers or you could say I want it for each week. Or each two weeks so each half. Oh. If you if this was a timed field which isn't true you say second minute how or half a day. So if I say I just want to show for each week then there you go. We have the first year from November 7th December which is a week later 21st of December and so forth. Now we had previously deleted the actual date in here. So you can see exactly which days it is. So if you wanted that then you need to put you back in that sort of thing. So I can. So they can see all of these which are the 17 are grouped together not necessarily the date order so 24 27 26 36 and so forth. So what we can then do is go back to our soft expert record salt exposure and say I want them sorted. In another moment we are sorting in order amount. So in descending order that's the day. So that's why in this week we have all of these in descending order so you can say see I want to change that. I want it to be so that they are all in all the day and. OK. OK. Tonight you see only not today but we're not will see all the £76 4:26 1061. So then you can say I don't want it to be in the amount descending order. So once you start setting up groups you can then change which group comes first and correct different reports from it very quickly very easily. For instance if I just wanted to go back to my previous vault area we are now in that they told her she's come in we called us all to change that if I watched go back to the experts and say I wanted a day which allows you to play with the data very quickly allows you to explore things that you won't necessarily have found before. And it just allows you to be a better analyst if you know what data is there and you can go wow I can show you that in a different view. There you go. Does it allows you to just be more productive and effective and just more efficient. So don't forget that there is more than one tab so we have this option tabs Well both are explored all that but that is how you make.