Problem to copy a column (tablix, subgroup?)...
-
Hi.
My name is Lucas. I'm from Brazil (sorry for my possibles english mistakes) and this is my first post in this forum.
I'm starting now to study Reporting Services...
I'm having a problem to copy the column named "Nr. OP." to the end of the report. Please check the image:
The problem is: the "+" button to expand the subgroup doesn't appear in the copy of the column. As the image shows:
What could it be? 🙁
Thank you very much...
-
I can't help because I don't even know how to spell "SSRS" but thought I'd take the time to "bump" this for you. Someone should be able to help here especially with the graphics that show the problem.
And glad to "meet" you, Lucas. Welcome aboard!
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
I don’t know why it doesn’t work, however here is how to get it to work:
Add columns between your “Operador” and “NumOrder”, copy and paste the values from existing columns ("Prod". "Tota"l etc.) into the new columns, delete the original columns
This makes me think, that SSRS expects the columns in a certain order so it knows when to render the + sign to expand the group.
-
To expand a row in a table, you can only link it to one item. Be it a cell, a text box, image, etc. Having a duplicate of the column on the other side of the table will create fields with different names, so the "copy" of a column won't expand.
Note, the setting to expand a row/group/etc is set on the item itself, not the item you click, which can only have one value. You can see my right clicking the row in your tablix, or the group in the Row Groups Pane, and then select Visibility. You can see that you can tick a box to toggle the display by a report item (not items, so only one).
You may be able to do this with Custom Codes, but I'm afraid I've created any (I've generally found SSRS to provide what i need, and if it doesn't, it's normally a "only if it's easy to implement" situation).
Hope that at least explains why what you are trying to do, doesn't work, sorry i can't give much more.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply