Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: number of records display on line Post Reply Post New Topic
Author Message
lablab
Newbie
Newbie


Joined: 26 May 2009
Location: France
Online Status: Offline
Posts: 3
Quote lablab Replybullet Topic: number of records display on line
     Posted: 26 May 2009 at 6:17am
Hello,

I need to display the number of records of line of the same shop on a field in the line, it would look like this :

shop          date                     number of records

Auchan       20090403                        3
Auchan       20090504                        3
Auchan       20090506                        3
Carrefour   20090128                         2
Carrefour   20090223                        2
etc...

Any idea how to do this ?

Thank you,



Edited by lablab - 26 May 2009 at 6:18am
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet Posted: 26 May 2009 at 6:30am
if you are using a stored proc to retrieve the data, the proc can calculate it before the data is returned to Crystal, otherwise, this is where I would use a subreport as you need data that is not available at the time that the this record is read.
 
HTH
IP IP Logged
lablab
Newbie
Newbie


Joined: 26 May 2009
Location: France
Online Status: Offline
Posts: 3
Quote lablab Replybullet Posted: 26 May 2009 at 6:33am
Thanks for your answer !
 
So I guess I'll have to go with subreport, could you explain me more in detail how i can do this with subreport ?
 
Thank you
IP IP Logged
lablab
Newbie
Newbie


Joined: 26 May 2009
Location: France
Online Status: Offline
Posts: 3
Quote lablab Replybullet Posted: 26 May 2009 at 7:05am

Someone just gave me the right answer from SDN forum :

 
--Create a group on Shop

--Create a formula like :

Count(date,shop)
--Now place this formula in your detail line

--suppress group header and group footer
 
works great !
IP IP Logged
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