How To Add Bullet And Numbering To Report?

Question

Post reply

How To Add Bullet And Numbering To Report?

Hendra Eka Putra

SSCrazy

Points: 2015
More actions
September 12, 2005 at 10:12 pm

#363674

Dear All,
I need to create a report based on sales data using the format below
1.   Electronic                       30
      A. Television                   10
      B. Refrigerator                 20
2.   Food                              10
      A. Soft Drink                   10
          a. Coca Cola                5
          b. Pepsi                      5

Any idea how to add a bullet and numbering?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

ofir shoval Ten Centuries Points: 1278 More actions · Answer 1

Well to number your list u can use RowNumber & RunningValue Functions as shown in this forum:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=212522

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=213425

Hendra Eka Putra SSCrazy Points: 2015 More actions · Answer 2

Great, I just don't get it. Why this function placed under Aggregate function . I guess I can also use this function in case I want to format the number using A, B, C etc --> A = Chr (RowNumber () + 56)

Thanks a lot