• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 257
  • Last Modified:

Moving a Group Column to a different location

Hi

I'm using the reporting services to produce some reports. One of those reports contains a table that has 4 columns, let's call them Col.A, Col.B, Col.C and Col.D

This tables groups data by Col.A.

When I run the report, it dislpays the table columns in the following order from left to right: Col.A, Col.B, Col.C, Col.D

My question now is: How do I change this column display order to be like this: Col.B, Col.C, Col.D, Col.A?

Note that the grouping column is the one I'm trying to shift its location to the end.

Any idea?
0
alfardan
Asked:
alfardan
  • 5
  • 2
  • 2
  • +1
1 Solution
 
mlmccCommented:
Which reporting tool are you using?

When you save the file what is the extension?

mlmcc
0
 
alfardanAuthor Commented:
The reporting tool that comes with Visual Studio 2008, the file extention is *.rdl
0
 
edlunadCommented:
I think you just can drag and drop the columns order by grabbing them from the title

What is your Reporting Services version?
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
edlunadCommented:
If you are creating your columns on the fly, try changing the order of them in the SELECT clause of your SQL code
0
 
rajeevnandanmishraCommented:
The SSRS creates the detail zone and group by zone separately. So now you need add three columns on the left of the group by column. That you can create by right clicking on the group by column and then selecting "Outside group and in the left". Then you need to move or recreate your data columns as per the current details and then remove the older B,C,D columns.
0
 
alfardanAuthor Commented:
edlunad:
How to create them on the fly?

rajeevnandanmishra:
Ok, just before I followed your suggestion, (P1.png) shows how I have my data sorted by column name then (P2.png) shows how they are listed when I run the report. Now, after following your suggestion, I got the following  in (P3.png) which is not what I wanted :( Check it please.
P1.png
P2.png
P3.png
0
 
rajeevnandanmishraCommented:
Hi,
As it is shown in P3.png, I think you have added the columns within the group on the left. That is why the data is now grouped by Name, Work & Task Starts. I think that you want to group it by the "Task Start Date". For this you need to add columns outside group and in the left. Doing that will continue with the grouping only on "Task Starts" and in the left of this, you will have the "Name" and "Work" columns (non-grouped).
 
0
 
alfardanAuthor Commented:
rajeevnandanmishra:

No bro, I did add it to the left and OUTSIDE the group (WORK) as you instructed before in your previous comment, and P3.png is what I got.

Also, I wasn't trying or intending to group by (TASK_STARTS)

Try it from your side with some data and you'll see it yourself. That's why I posted my last comments to let you know that I tried your suggested solution but didn't work, and may be you have some other way of doing it. Do you?
0
 
alfardanAuthor Commented:
I expected a fast resolution, however I didn't get any until now, so I'm closing this question because I found a work-aruond, which is by creating a view that contcatenates grouped tasks into one cell, by then I won't need any grouping feature to use in this reporting service.
0
 
alfardanAuthor Commented:
See my last comment
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

  • 5
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now