Recent content by krshtej

Hi CoSpringsGuy, you know there will be crystal built in special fields like date time, page number etc. similarly there is one called 'record number'. i created a formula in basic syntax (not crystal syntax) in the formula editor as: formula = totext(recordnumber,0) & ". " &...

Hi all, I used the 'Record Number' special field and my issue is solved. Thanks for all the help. I learnt some new things with the codes you all provided. Thanks, Tej.

Now it is coming something weird. For some only "1." and for some 1,2,1,2,1,2... Thanks for all the help CoSringsGuy, seems this is something i need to talk to db people and ask them to validate the data. Even I was spending too much time to figure out this, but doesn't seems logic problem...

stringvar x := {myfield}; Local numbervar i; local stringvar array AllPoints := split(x,"<br/>"); local stringvar results :=""; for i := 1 to count(AllPoints) do ( Results := Results & ToText(i,0,"") + ". " + AllPoints[i]+chr(13) ); Results data: Avai on a mo.<br />Incls Lel tions as ayed at...

Hi CoSpringsGuy, When I am using you code(with just field name)nothing is coming. So, i removed the -1 (count(AllPoints)-1) and results are coming but number coming always "1.". Just to let you know i am using this in subreport (details section). This subreport is placed in the main report's...

Hi CospringsGuy, I can see the problem, that it is storing only one point that's why loop is not running and displaying only '1.' But how to make the point get stored in the array. I have tried the LB's code also yours, using the split but same thing only '1.' is coming. I am using replace...

Hi CoSpringGuy, I am using this as the end of points is having '<br/>'. Local numbervar i; local stringvar array AllPoints := Replace(Replace(Replace({table.field}, "<br/>", chr(13)), "< br/>", chr(13)), "<br />", chr(13)); local stringvar results :=""; for i:=1 to count(AllPoints) do...

Hi LB, Now numbers are not coming at all in front of the points. Thanks, Tej.

I am using 'i' Ido, but the number is not increasing. Thanks, Tej.

Hi Madawc, I tried but, this code is not working for me. Also the points will be variable, I cannot hard code it to 3. The one i specified above is giving me all I need except that the number is not increasing. Any help? Thanks, Tej.

Hi Bruce, I have edited the code as per my needs and this is how it is now. But the number is not repeating (even when i changed it to 'can grow'), it is always '1.' Local numbervar i; local stringvar array AllPoints := Replace(Replace(Replace({table.field}, "<br/>", chr(13)), "< br/>"...

Sorry Bruce, I think i dint check the can grow option. Its good now. Thanks, Tej.

Thanks Bruce, it worked. But thing is the number is not increasing, only '1.' is coming in front of all the points. How to increase the 'i' value. Thanks, Tej.

Hi, I have a text field which is a paragraph of notes. I want to display it as point. ex: abcdabcdabcd.efghefhefh.ijklijklijkl. display: 1. abcdabcdabcd 2. efghefghefgh 3. ijklijklijkl Thanks.

Thanks Tuckbear that information is helpful.