Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks
Message Icon Topic: Expand rows Post Reply Post New Topic
Author Message
ipavlova
Newbie
Newbie
Avatar

Joined: 30 May 2012
Online Status: Offline
Posts: 3
Quote ipavlova Replybullet Topic: Expand rows
    Posted: 30 May 2012 at 11:00pm
Hi,
 i have report that shows users and their learning results the result is:

User 1 - Course 1
              Course 2
-------------------------
User 2 - Course 1
              Course 2
              Course 3

and the desired result is:

User 1 - Course 1 {expand}
User 2 - Course 1 {expand}

So - i want every one user to be on one row with option to expand all data, i did not find option for this, did someone know how to do that?


IP IP Logged
rkrowland
Senior Member
Senior Member
Avatar

Joined: 20 Dec 2011
Location: England
Online Status: Offline
Posts: 259
Quote rkrowland Replybullet Posted: 30 May 2012 at 11:56pm

-Create a group on the user field

-Put course field into the details section
-Right click on the details section (on the section bar to the left) and select "Hide (Drill-down OK)".
 
If you preview your report you should see a list of user names, if you double click one of those names the courses should appear below.
 
Regards,
Ryan.
IP IP Logged
ipavlova
Newbie
Newbie
Avatar

Joined: 30 May 2012
Online Status: Offline
Posts: 3
Quote ipavlova Replybullet Posted: 02 Jun 2012 at 4:53am
Thank you so  much, that was helpful info
i have question about average options.
I have the data:
GROUP 1
user1 - course1 score 50
           - course 2 score 100
                       average  75 // RTotal field which use average option for group of courses//
 
user2 - course 1 score 25
          - course 2 score 50
                      average 37,5
                        Group average: 56,25
did you know how to get Group average of average
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.