I'm doing a report that require indexing. I know i can do that by
create a new Running Total Field at select the summary type as count.
However, the result only appear for numeric.
Can Crystal come out something for example:-
a.
b.
c.
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Posted: 16 Sep 2009 at 6:13am
you can create a formula to do that. I would probably use a shared variable as a number and increment it as need then display the ChrW() value...65 = A
Joined: 11 May 2009
Location: Australia
Online Status: Offline
Posts: 127
Posted: 16 Sep 2009 at 7:57pm
Where do you want this indexing? for the data in details section?
no need of LONG if - else..write 2 formulas
1. Formula to Initialize and place in RH
Shared numbervar ch:=65;
2. for Indexing
Shared numbervar ch ;
if Onfirstrecord then
ch
else
ch:=ch+1;
Chrw(ch);
Place it in Details
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Posted: 17 Sep 2009 at 6:07am
Jyothi is correct, just the 2 formulas are needed. Depending on your report, and how you want it indexed, you might want to move the Reseting of the variable to another band...many times I have it in a Group Header band, this way each group starts over, but it is the same basic idea.
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
IP Logged
