insert text in selected record

[Palmtree]

I want disply my query result(result1, result2, result3) like this:

A. result1
B. result2
C. result3

How can I insert the A, B, and C in it? Thanks.

[King_George]

I want disply my query result(result1, result2, result3) like this:

A. result1
B. result2
C. result3

How can I insert the A, B, and C in it? Thanks.

I can think of at least one way, but just to be sure, how is the report obtaining data? Directly from the database, ttx file or ...?

[Palmtree]

Thanks for the reply. I get data from database.

[King_George]

Thanks for the reply. I get data from database.

Here's a quick and dirty way that works fine as long as there isn't more than 26 records. If there is, then you have to change the formula to handle it.

1. Create a formula field on the report.
2. In the formula field put this formula:
chr(64 + RecordNumber) & "."
3. Place the formula field on the left of the record in the detail line.
4. run the report.

Remember that will only work from A to Z. After that then you get a to z and 0 to 9 and then whatever ascii character corresponds with the formula.

HTH

[Palmtree]

Thanks so much. I will give it a try.

[Palmtree]

Oh, forgot tell you that I use crystal report that comes with VB.net. So how to create a formula field?

[King_George]

Oh, forgot tell you that I use crystal report that comes with VB.net. So how to create a formula field?

Off the top of my head, it's the same way as always. Go to Insert, field objects and formula field or look it up in the help. I'm not at work now so I can't look

Once the formula field is in the list of database objects, simply place it on the report where I told you and yer golden.

[Palmtree]

got it!! thanks.