Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SSRS Column Header Number

Posted on 2013-01-17
3
Medium Priority
?
1,393 Views
Last Modified: 2013-01-28
I have a report from ssrs and now I want to place the number on top of the column name.Is it possible w/o doing hardcoding as I have 200 columns.

Lets say--I have a report that displays name,lastname,class and age.So on top of the field name I want to autogenerate this number without typing in like 1 ,2, 3, 4.Thanks in advaance

 1                2                       3                         4    
name     lastname            class                 age
0
Comment
Question by:Josh2442
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 12

Expert Comment

by:Saurabh Bhadauria
ID: 38792380
0
 

Author Comment

by:Josh2442
ID: 38793611
@Saurv I already checked that link,before posting this forum.But That only implies to the rows not the columns.

Thanks
0
 
LVL 6

Accepted Solution

by:
liija earned 800 total points
ID: 38800213
Hi,

Add a small custom code on the report:

Public columnNumber As Integer = 0
Public Function ColNumber(ByVal colNo) AS Integer
Dim retColNo As Integer
columnNumber =columnNumber + colNo
retColNo = columnNumber
return retColNo
End Function

Then call the code from every column header like
=Code.ColNumber(1)

It simply just adds 1 to the variable in the code on each column.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to shrink a transaction log file down to a reasonable size.

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question