How Can I Rearrange The Columns In Ssrs Reporting Services

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

Hi,
i have a report in which the user can select a list of columns related to a particular table using a parameter. Here i need to rearrange the columns.

I'm able to rearrange a single column by using two parameters one is to select a particular column we want to move and other parameter is to select a column that my desired column need to place after/before this column.for this i have created a Stored Procedure. Its works fine.

Is it possible to rearrange multiple columns?

Posted 17-Jul-14 21:31pm

Member 10955034

Add a Solution

Comments

coded007 18-Jul-14 8:38am

Can you please explain me in more detail.

Member 10955034 18-Jul-14 9:23am

Im using a matrix report that is dynamically displaying the columns when we select a particular table through parameter.
Before displaying the columns i need to move the columns as per the user request, so for that purpose i'm using two more parameters one for selecting the desired column want to move or swap and the other one is selecting a column after/before this column want to place. i can move a single column by this approach before viewing the report ,It cant be possible for moving multiple columns.

Is there any approach to achieve this??

coded007 21-Jul-14 3:25am

you need to handle this in SQL Query becoz Matrix report only shows the data you get from sql query.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

mcdubey · Answer 1 · 2014-07-22T01:10:00

Solution 1

If you are using .RDL OR .RDLC file then you may change position of column through opening in text editor like notpad++ etc . after opening you RDL or RDLC file in text editor you may change column position accordingly ,i did it same but my case was with RDLC :)

Posted 22-Jul-14 1:10am

mcdubey