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.
Printable View
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 ...?Quote:
Originally Posted by Palmtree
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.Quote:
Originally Posted by Palmtree
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
Thanks so much. I will give it a try. :)
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 :(Quote:
Originally Posted by Palmtree
Once the formula field is in the list of database objects, simply place it on the report where I told you and yer golden.
got it!! thanks. :wave: