Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
andrewhopkinson
Yak Posting Veteran
63 Posts |
 Posted - 2010-02-08 : 09:44:55
|
| Hi, I am trying to convert a Crystal Reports in Reporting Services and I'm having some trouble. In Crystal the report looks like this:[Parent Group 1][Child Group 1] [Detail line 1] [Detail Line 2] [Detail Line 3] [Totals Child Group 1][Child Group 2] [Detail Line 1] [Detail Line 2] [Detail Line 3] [Totals Child Group 2][Totals Parent Group 1][Parent Group 2][Child Group 3] [Detail Line 1] [Detail Line 2] [Detail Line 3] [Total Child Group 3]etc...This seems exceedingly hard to do in Reporting Services, Whenever you add groups, it moves the detail to the right of the group and it seems very difficult to have it appear below. Any thoughts? thanks for any help in advance. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-08 : 10:11:50
|
| what you need is to apply three levels of grouping on three rows based on your fields. cant understand why you sayThis seems exceedingly hard to do in Reporting Services, Whenever you add groups, it moves the detail to the right of the group and it seems very difficult to have it appear belowcan you elaborate? |
 |
|
|
andrewhopkinson
Yak Posting Veteran
63 Posts |
Posted - 2010-02-08 : 11:06:08
|
| 3 levels of Grouping? There are only 2 levels, the parent team and then the Team. Basically, I drag a table onto the report, and drag the field I want for my detail. I right click on it and add groups each time a group is added, the detail is pushed to the right. I have managed to fiddle with it so the parent and child groups appear on top of each other, but can't get the detail to appear below. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-08 : 11:13:59
|
quote:
Originally posted by andrewhopkinson
3 levels of Grouping? There are only 2 levels, the parent team and then the Team. Basically, I drag a table onto the report, and drag the field I want for my detail. I right click on it and add groups each time a group is added, the detail is pushed to the right. I have managed to fiddle with it so the parent and child groups appear on top of each other, but can't get the detail to appear below.
nope. before dragging and dropping fields first apply grouping and then add the aggregate expressions. Since your last level contains detail data you could create a dummy group there |
|
|
|
andrewhopkinson
Yak Posting Veteran
63 Posts |
Posted - 2010-02-08 : 11:50:16
|
| How do I define my groups without inserting the detail columns? Can you please explain how I make it look like this:Parent 1Child 1Detail 1Detail 2Detail 3Thank you. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-08 : 11:58:43
|
| see this as an examplehttp://www.c-sharpcorner.com/UploadFile/MohanKumar.R/DrillDownReport02212008083910AM/DrillDownReport.aspx |
|
|
|
andrewhopkinson
Yak Posting Veteran
63 Posts |
Posted - 2010-02-08 : 12:04:27
|
| Actually, I think I figured it out by inserting adjacent above the detail line. I am figuring out that the Grouping data to the left of the double dash lines can be hidden. It's not intuitive at all though. Thank you for your help. |
|
|
|
|
|
|
|
|
Parent and Child grouping