Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: retrieving last row from a group Post Reply Post New Topic
<< Prev  Page  of 2
Author Message
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 06 Feb 2008 at 3:13am
Yes it will not show ,if you see carefully,when new page of Grouped data is opened their is no Page Header Section .
 
so to display the field headings you need to create the same Field Headings in your Group Header Section
 
then in those field heading right click ---Format Text --- Common Tab --- Suppress x+2 enter
 
drilldowngrouplevel = 0
 
so they will not be displayed on inital page when you click on group heading they will be displayed.
 
So you need to create the same field headings in your Group Header Section as in your Page Header Section .
 
Cheers
Rahul
IP IP Logged
hisneha2000
Newbie
Newbie


Joined: 30 Dec 2007
Location: India
Online Status: Offline
Posts: 29
Quote hisneha2000 Replybullet Posted: 06 Feb 2008 at 10:28pm

 

Hi Rahul,

Thanks for the help ...

 
 
Sneha
IP IP Logged
hisneha2000
Newbie
Newbie


Joined: 30 Dec 2007
Location: India
Online Status: Offline
Posts: 29
Quote hisneha2000 Replybullet Posted: 07 Feb 2008 at 1:44am

i want to supress fields with a certain value .In load event of report only groupfooter data is displayed ... In supress section of groupfooter i already have a formula    drilldowngrouplevel =0 ....

I also want to supress rows with coloumn having a particular value...
{Table.column} ='value'
 
 But it is not accepting other formula {Table.column} ='some value' ...
 
Gives an error remaining text does not appear as part of the formula ...
 
Hw can i supress rows then ??
 
 


Edited by hisneha2000 - 08 Feb 2008 at 4:53am
Sneha
IP IP Logged
hisneha2000
Newbie
Newbie


Joined: 30 Dec 2007
Location: India
Online Status: Offline
Posts: 29
Quote hisneha2000 Replybullet Posted: 08 Feb 2008 at 4:54am
 
Hi,
 
Is there any way to do this?
 
Thanks
Sneha
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 08 Feb 2008 at 7:29am
Hi....
 
Can u tell me which section the fields are ....
 
if you want to suppress field values right click the field then format field then common tab then suppress x+2 enter the  condition
 
{Table.column} ='value'
 
cheers
 
Rahul


Edited by rahulwalawalkar - 08 Feb 2008 at 7:36am
IP IP Logged
hisneha2000
Newbie
Newbie


Joined: 30 Dec 2007
Location: India
Online Status: Offline
Posts: 29
Quote hisneha2000 Replybullet Posted: 12 Feb 2008 at 4:56am

 

I got it !!!!!!

 
Thanks
Sneha
IP IP Logged
CRMSFDC
Newbie
Newbie


Joined: 04 Dec 2008
Online Status: Offline
Posts: 13
Quote CRMSFDC Replybullet Posted: 12 Feb 2009 at 1:26am
Here is sample data abt hw exactly i want it ...
Name
A            10 1/11/06
A            12 2/20/07
B            19 1/11/06
A            15 1/1/08
B            12 1/11/09
A            18 1/1/08


Now i hve grouped them according to there names . i just want to display below value in crystal report ...



currently my report displaying only last row of group (in group footer) like below.

A    18 1/1/08
B    12 1/11/09

but I want to display not only last row of group but also if other record also has entries(one or more) on same date belongs to same group.

like below,
Group no posting date
A    18 1/1/08
A    15 1/1/08
B    12 1/11/09

How to implement?
Help me out!
IP IP Logged
<< Prev  Page  of 2
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | BAEZL

© 2004-2026 Brian Bischof. All Rights Reserved.