Search results for query: *

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.

Hi RTag, Actually in my company they are using in that way (WITH (NOLOCK)) to retrieve the data fast. So, just to go with the company we have to do that. Thanks for the help though! --Krshtej.

Hi, I have a general question. When we see the code behind in crystal reports it is not showing any 'With (NOLOCK)' for the tables. Wont this result in dead lock situation or performance issues? Is there a way to insert that 'With (NOLOCK)' while designing a report. (General designing not using...

Hi I got a answer for this. Thanks.

Hi, I have a report that i need to schedule. It has to run every month to give previous months records (eg: June 1st it has to run from May 1 to 31). what i need to do, so that when i schedule it on Crystal management console it will run every month for previous month 1st to 30th or 1st to...

It is actually not student id it is the confirmation number when student register for a test. when he fails the test and reschedule it a new confirmation number will be given. when the report is ran it is giving out both the numbers and the request came to edit the report to show only new...