Crystal report summary page and detail pages
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22148
Printed Date: 05 May 2024 at 5:33am
Topic: Crystal report summary page and detail pages
Posted By: Jimm
Subject: Crystal report summary page and detail pages
Date 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.
|
Replies:
Posted By: Valert16
Date 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.
|
Posted By: Jimm
Date 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.
|
Posted By: Jimm
Date Posted: 18 Nov 2016 at 4:58am
Valert16,
It works well. Thanks for your help and I learn little by little.
|
Posted By: Valert16
Date 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!!
|
Posted By: Jimm
Date 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.
|
|