June 6, 2012 at 5:28 pm
Hi everyone,
I have two textbox items inside the header section of a table tablix. Basically, I created a table, and then inside of the table, I created a column group with header, and merged the column group header. Then I dropped a rectangle in the merged column group header, and then dropped some textboxes on top of that. The two textbox items are sitting one on top of the other. The data is supposed to be shown one on top of the other too. But when I go to Preview and click on the Print Layout button, I see a 1 inch distance between the data. I have gone to the properties of both textbox items and set the padding to 0 for both, but there is still a 1 inch distance between the data. I have no idea what to do now, any ideas how to fix this? Thanks.
BTW, I am on SSRS 2008 R2.
June 7, 2012 at 6:52 am
I'm pretty sure you need to play around with the KeepTogether property. I added a titbit to my old blog a longtime ago on it that should help:
http://steffsullivan.wordpress.com/2009/09/01/method-for-overlaying-items-in-reporting-services/
June 7, 2012 at 12:25 pm
Thank you Stephanie, I played around with it, but it didn't help unfortunately.
I changed the bottom textbox to include the value from the top box. So whereas the top box before had "Shipping Status:" and the bottom textbox had an expression, now the top textbox is gone and the bottom textbox has "Shipping Status:" on line 1 and the expression on line 2......and yet, it's still the same! I even moved the textbox inside of a rectangle, and also moved it out of the table header and onto the list itself....same thing! What am I missing?
June 7, 2012 at 2:42 pm
Well, I feel like a dummy. The reason why there is a space is because the column that is there is null. Any way to make sure that if there is a null, then it is removed and the space is gone?
June 8, 2012 at 2:10 am
Back to basics for me - what are you trying to achieve? From what you last said it sounds like you have two fields and what you're looking to do is show both of these in one column and ff they are something like CurrentStatus and Location, you want them to look like CurrentStatus: Location where if one is NULL you just want the other component less the colon and space?
In terms of getting rid of NULLs you can either filter to exclude if you don't need those items, or you can use an iif statement with the IsNothing operator to check if something is null. You can then insert a blank i.e. "", if it's null and " "&Location if it isn't.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply