| Author |
Message |
hisneha2000
Newbie
Joined: 30 Dec 2007
Location: India
Online Status: Offline
Posts: 29
|
  
Topic: retrieving last row from a group
Posted: 01 Feb 2008 at 3:17am |
Hi ,
I have a report which i have grouped based on a particular column name ... i want my report to display only last row of every group in my report .. how can i do this ?
Thanks in advance
|
|
Sneha
|
 IP Logged |
|
|
|
rahulwalawalkar
Senior Member
Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
|
Posted: 01 Feb 2008 at 4:28am |
Hi
Place the fields you want to display in Group Footer Section and Suppress the details sections.
Cheers
Rahul
|
| IP Logged |
|
hisneha2000
Newbie
Joined: 30 Dec 2007
Location: India
Online Status: Offline
Posts: 29
|
Posted: 01 Feb 2008 at 5:11am |
Here is sample data abt hw exactly i want it ...
Name
A 10
A 12
B 19
A 15
B 12
A 18
Now i hve grouped them according to there names . i just want to display below value in crystal report ...
A 18
B 12
for name "A" 18 is last data
For name "B" 12 is last data
|
|
Sneha
|
| IP Logged |
|
rahulwalawalkar
Senior Member
Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
|
Posted: 01 Feb 2008 at 5:30am |
Ok When you have grouped by Name
you will have display as below
A Group Header
Details Section
10
12
15
18
Group Footer
B Group Header
Details
19
12
Group Footer
Now place the Group Name ,and Field for 18 and 12 in
Group Footer Section
so it will display
A 18
B 12
Don't forget to suppress your details section ,right click details section select section expert and the suppress (no drilldown)
cheers
Rahul
Edited by rahulwalawalkar - 01 Feb 2008 at 5:32am
|
| IP Logged |
|
hisneha2000
Newbie
Joined: 30 Dec 2007
Location: India
Online Status: Offline
Posts: 29
|
Posted: 05 Feb 2008 at 9:35pm |
Thanks alot !!!!!
It worked !!!!!
|
|
Sneha
|
| IP Logged |
|
hisneha2000
Newbie
Joined: 30 Dec 2007
Location: India
Online Status: Offline
Posts: 29
|
Posted: 06 Feb 2008 at 1:38am |
one more question ..in continuation with this topic ....
i have last row data displayed on my report (this was the way i wanted it )..... when i click on any field it opens a new page and displays all data inside my group .....
It also displays last row of data which is there in Group footer section ... i dont want that to be displayed in the new page .... i cant supress Group footer section bcoz i want that in my first page but not on second page ....
Thanks
|
|
Sneha
|
| IP Logged |
|
rahulwalawalkar
Senior Member
Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
|
Posted: 06 Feb 2008 at 2:26am |
Go to Group Footer Section....
Right Click ---Section Expert---- Select X+2 suppress(no drilldown) enter the following code
drilldowngrouplevel >0
Cheers
Rahul
|
| IP Logged |
|
hisneha2000
Newbie
Joined: 30 Dec 2007
Location: India
Online Status: Offline
Posts: 29
|
Posted: 06 Feb 2008 at 2:34am |
Gr8....
Its working fine now ...
Can u tell me what does this drilldowngrouplevel >0 exactly do ?
Thanks Edited by hisneha2000 - 06 Feb 2008 at 2:35am
|
|
Sneha
|
| IP Logged |
|
rahulwalawalkar
Senior Member
Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
|
Posted: 06 Feb 2008 at 2:44am |
Hi Sneha,
I have just copied from Crystal Help...... please read .....
Drilldowngrouplevel
Number
Action
Returns a number that indicates the group level of the current drill down view, or 0 if it is not a drill down view.
Examples
If a report has groups on Country and Region, then DrillDownGroupLevel returns 0 in the view without drill downs. Within the drill down view for a Country, DrillDownGroupLevel returns 1, and within the drill down view of a Region, DrillDownGroupLevel returns 2.
To check if you are in a drill down view, test to see if DrillDownGroupLevel > 0 returns true.
Cheers
Rahul
|
| IP Logged |
|
hisneha2000
Newbie
Joined: 30 Dec 2007
Location: India
Online Status: Offline
Posts: 29
|
Posted: 06 Feb 2008 at 2:53am |
Rahul ,
Thanks for explaination ... i m trying to understand that concept ...
one more question ....
when the new page of grouped data is opened it does not show the field heading ?
Thanks
|
|
Sneha
|
| IP Logged |
|
|
|
