| Author |
Message |
Jimm
Newbie
Joined: 10 Nov 2016
Online Status: Offline
Posts: 32
|
   Topic: Crystal report summary page and detail pages
Posted: 16 Nov 2016 at 9:54am |
|
I have one already built report with format like:
total_orders total_offcie_visits
Doctor1 3 24
order on Med_name MRN order_id
01/23/2016 XXXX XXX 32567
10/8/2016 XXXXXX XX 496899
11/2/2016 XXXXX XXXX 546372
total_orders total_offcie_visits
Doctor2 4 5
order on Med_name MRN order_id
03/2/2016 XXX XXX 231127
1/4/2016 XXXXX XX 849699
12/5/2016 XXXXX XXXX 559372
12/5/2016 XXXXX XXXX 559372
total_orders total_offcie_visits
Doctor3 34 34
....... ...... .... .......
..... .... ... ......
... .... .... ........
other doctors
report works well, however, users asked to have front page only shows total number like:
total_orders total_offcie_visits
Doctor1 3 24
Doctor2 4 5
Doctor3 34 34
Other doctors ... ..
then when click total numbers, report can go to detail
pages:
Doctor1 order on Med_name MRN order_id
01/23/2016 XXXX XXX 32567
10/8/2016 XXXXXX XX 496899
11/2/2016 XXXXX XXXX 546372
Doctor2
order on Med_name MRN order_id
03/2/2016 XXX XXX 231127
1/4/2016 XXXXX XX 849699
12/5/2016 XXXXX XXXX 559372
12/5/2016 XXXXX XXXX 559372
I tried to use Hidden drill down, but my difficulty is: since both summary front page and detail pages use same column names, front page became:
total_orders total_offcie_visits
Doctor1 3 24
order on Med_name MRN order_id
total_orders total_offcie_visits
Doctor2 4 5
total_orders total_offcie_visits
Doctor3 34 34
my question is what I need to change ( or how can I remove repeat column names) so front page only show like:
total_orders total_offcie_visits
Doctor1 3 24
Doctor2 4 5
Doctor3 34 34
Other doctors ... ..
Thanks.
|
 IP Logged |
|
|
Valert16
Groupie
Joined: 21 Mar 2016
Location: Spain
Online Status: Offline
Posts: 57
|
Posted: 17 Nov 2016 at 11:57pm |
|
There may be many ways to achieve the layout you want. You can try this one.
1) Put the sumary labels ("total_orders" and "total_offcie_visits") in page header.
2) Split the group header so you'll have 2 GHs: GH1a and GH1b.
3) Put the group name and summary values in GH1a.
4) Put field labels ("order on", "Med_name", "MRN" and "order_id") in GH1b.
5) Hide Details (Drill-Down OK).
6) Supress conditionally GH1b. Goto to Section Expert and select GH1b.Click the conditional format button and use this code (Crystal syntax):
(DrillDownGroupLevel = 0)
This code shows field labels only when you drill-down on the GH1a values.
That's all.
|
|
IP Logged |
|
Jimm
Newbie
Joined: 10 Nov 2016
Online Status: Offline
Posts: 32
|
Posted: 18 Nov 2016 at 1:54am |
|
Valert16,
I am new to Crystal report, so lot of things I need to learn.
Thanks so much for your detail instruction. I am trying it now.
|
|
IP Logged |
|
Jimm
Newbie
Joined: 10 Nov 2016
Online Status: Offline
Posts: 32
|
Posted: 18 Nov 2016 at 4:58am |
|
Valert16,
It works well. Thanks for your help and I learn little by little.
|
|
IP Logged |
|
Valert16
Groupie
Joined: 21 Mar 2016
Location: Spain
Online Status: Offline
Posts: 57
|
Posted: 18 Nov 2016 at 6:18am |
|
Glad it works. There are many important concepts in this few steps, so try to understand all them well.
Happy reporting!!
|
|
IP Logged |
|
Jimm
Newbie
Joined: 10 Nov 2016
Online Status: Offline
Posts: 32
|
Posted: 18 Nov 2016 at 7:43am |
|
I thought it is very hard to changes, however I feel so confident after I knew how to try to move around the columns into different pages, headers,etc.
what is the best resource for such kinds of concepts, I understand working on different reports will accumulate experience, reading books, google, etc.
|
|
IP Logged |
|
|
|
