RowNumber Function in SSRS

By
roopesh.valluru
-
14
73353
RowNumber Function
RowNumber Function

Friends,

Lets see what is RowNumber function in SSRS and a simple example to demonstrate the same. This RowNumber function returns the row number for every row with in the dataset. You have to pass the scope for which you wish to create row numbers.  PFB the syntax for the same –

RowNumber(Scope)

Scope – This tell the server when to RESET the running count. If you pass DATASET name as SCOPE then it will not RESET until the all the items in the DATASET get over. Similarly if you secify a GROUP then the running count will not reset until all the rows items in the group is completed and it will repeat the same for all the groups. You can provide anyone of the below given objects as SCOPE of the function.

1) Dataset

2) Group

3) DataRegion

4) Nothing

If you provide NOTHING then it will take the OUTERMOST data region and will provide Running Count of the rows. Lets see an example on how to to get the Row Number of a SSRS report using ROWNUMBER Function. PFB the expression I am using to get the row number of each row of the data region.

=RowNumber(Nothing)

PFB the SC which displays the output of the expression given above.

 

RowNumber Function
RowNumber Function

You may be wondering “Why I need this ? ” and the answer is – There are many scenarios where you need this and lets discuss about one here. Lets say my requirement is to COLOR alternate rows in one color and in this case I can make use of ROWNUMBER Function to achieve the same. PFB the expression I have to use to achieve the given requirement.

=iif(RowNumber(Nothing) Mod 2,”Green”,”Yellow”).

PFB the steps you have to follow to achieve the same.

1) Select entire row.

2) Press F4(Properties Window).

3) Select BackColor Property and click on Expression.

4) Add the above given expression as shown below.

RowNumber Function
RowNumber Function

5) Preview report and you can see the report like given below.

RowNumber Function
RowNumber Function

You can use the same expression in many places like for changing font color,font weight,border color … So this is very useful function in designing your report.

That’s it, Happy Coding !!

Regards,

Roopesh Babu V

RELATED ARTICLESMORE FROM AUTHOR

14 COMMENTS

  2. River blindness is spread by day-biting flies, and is the leading cause of blindness worldwide.
    Forget about waiting at the store for how long does levitra take to work to successfully diminish symptoms after locating great cost
    When I mentioned it she made out as if she didn’t know, but I don’t see how she a wouldn’t have known and b wouldn’t have thought about it when she brought in a seafood salad!

  3. 1xBet
    1xBet offers a localized experience for users in Singapore, including region-specific promo codes and bonuses. These promotions are tailored to the preferences of Singaporean users, providing them with the best possible betting experience.

  6. Кракен сайт – это онлайн-площадка, работающая в скрытых сетях интернета, где пользователи могут покупать и продавать различные виды наркотиков. Для доступа к Кракен сайт необходимо использовать специальное программное обеспечение, позволяющее обходить блокировки и обеспечивающее анонимность пользователей.

  10. Сайт предоставляет информацию о биодобавках http://биодобавки.рф состав, польза и рекомендации по применению. Здесь вы найдёте обзоры эффективных добавок для улучшения здоровья, иммунитета и энергии на основе научных данных и экспертных мнений.

  11. Check Availability Welcome First Time Guest Information Policies and Procedures Pet Policy Directions Guest Rooms Guest Rooms Token Creek Room Madison Lakes Room Rising Sun Room Heywood Hardy Room Starkweather Creek Room Room Comparison Packages and Specials Dining Breakfast Dining Recommendations The Speckled Hen Inn Wine List Photos Photo Gallery Winter Photo Gallery Spring Photo Gallery Summer Photo Gallery Fall Photo Gallery Our Video Madison Our Blog Hear doxycycline allergy symptoms further also four faint the the could I.
    yourself familiar with requirements for pharmacies that sell how long does tadalafil stay in your system pills at the lowest prices ever
    However, it is estimated that at least half of the people with Wilson’s Disease are never diagnosed, and therefore will suffer, and sometimes die, from the disease.


  12. Временная регистрация в СПб: Быстро и Легально!
    Ищете, где оформить временную регистрацию в Санкт-Петербурге?
    Мы гарантируем быстрое и легальное оформление без очередей и лишних документов.
    Ваше спокойствие – наша забота!
    Минимум усилий • Максимум удобства • Полная легальность
    Свяжитесь с нами прямо сейчас!
    Временная регистрация

LEAVE A REPLY

Please enter your comment!
Please enter your name here

88 − = eighty seven