SSRS report – hidden columns

Ok, now I am researching why do I have hidden columns in a recently created report. Well I think I know why – it is because of the columns in the report and the fact that they are not aligned perfectly. But how do I detect the exact source of the error…?

Google search, hope you didn’t missed me too much because here I am…again!

As you can see, my report starts with C, instead of A and B which are shyly hidden

As per usual, I will get to the bottom of this for I am the Sherlock of SSRS glitches. And there are a lot of these, my dear Watson.

Ok, so google – more precisely http://tiny.cc/5vvoiz, tells me that this is a well known product issue (oh, I like it when it is not my fault :D) and to get around this, some of the steps are – I will try them one by one to see if they work in my case:

  1. undefinedmake sure all the report’s rows start at 0 cm in Location property – ok, let’s see… hmm, still not working just making sure I am taking all the rows into account (now I am hungryyy, and oh, wait, the sun is calling me to take a breath outside, ok I am going a little outside)
This is what a 5 minutes break outside in Romania looks like 😁🤭

I still have to eat something..in the meantime columns A and B are still hiding from me.

Point 1 worked – not all the lines were at Location 0 (for Left). By the way, be careful not to put Top also to 0, or the row will go at the top of the report.

One comment

Leave a comment