Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Hey... This isn't an answer but this post doesn't have a place that I can just comment on the question. Sorry, I don't know where else to put this. </p> <p>What are you actually trying to accomplish by naming these columns? You can name the text boxes.... and add expressions to those.... If you click on the "static" labels, it highlights the column heading for you... and all of my are always in order by default (might always be this way?). But, what are you actually trying to do that those need names for? I can't see a way to do it. </p> <hr> <p>After I wrote that first comment down there in response to yours I decided to play with the code in one of my reports... It's still really hard without being able to actually name those columns but they are all in order at least, in the code. For future editing to this report, I suggest adding comments in the code saying what each TablixMember actually is... But I don't think there is a way............... SSRS as a whole is sometimes very, very difficult and frustrating to use. It drives me absolutely crazy but there aren't any other options that have enough benefits to use instead... and SSRS actually has a lot more functionality than some of its alternatives. </p> <pre><code> &lt;TablixColumnHierarchy&gt; &lt;TablixMembers&gt; &lt;TablixMember&gt; &lt;Visibility&gt; &lt;Hidden&gt;=iif(Parameters!hideCol1.Value is nothing, true, false)&lt;/Hidden&gt; &lt;/Visibility&gt; &lt;/TablixMember&gt; &lt;TablixMember /&gt; &lt;TablixMember /&gt; &lt;TablixMember /&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POHow do you name a static column group in a Reporting Services matrix report
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USgloomy.penguin
    1. USgloomy.penguin
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COClicking on a static member doesn't visually highlight the columns. I have over 30 columns, all of which can be conditionally hidden/displayed, so for me naming them would eliminate the guess work of having to know which order they're in when trying to apply visibility expressions.
      singulars
      1. PO
      1. USDon
    2. COI don't think you can... but... you can name the actual text box? Or you can just view the code and do it that way and do it all based on the content in the column and just type it in. I would think that would be easiest...
      singulars
      1. PO
      1. USgloomy.penguin
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload