Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by krshtej

  1. krshtej

    Numbering in Crystal Reports

    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) & ". " &...
  2. krshtej

    Numbering in Crystal Reports

    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.
  3. krshtej

    Numbering in Crystal Reports

    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...
  4. krshtej

    Numbering in Crystal Reports

    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...
  5. krshtej

    Numbering in Crystal Reports

    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...
  6. krshtej

    Numbering in Crystal Reports

    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...
  7. krshtej

    Numbering in Crystal Reports

    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...
  8. krshtej

    Numbering in Crystal Reports

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

    Numbering in Crystal Reports

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

    Numbering in Crystal Reports

    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.
  11. krshtej

    Numbering in Crystal Reports

    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/>"...
  12. krshtej

    Numbering in Crystal Reports

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

    Numbering in Crystal Reports

    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.
  14. krshtej

    Numbering in Crystal Reports

    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.
  15. krshtej

    Using 'With Nolock' in Crystal Reports

    Thanks Tuckbear that information is helpful.
See more

Part and Inventory Search

Back
Top