Hi--any report writers out there?
I'm new to SSRS and don't make report edits very often even in Infomaker.
I am trying to make what I think is a simple change, just changing the justification of two data outputs to be right justified to match the rest of the report column.
I assumed changing this "TextAlign" property would do the trick, but it's not. Oddly all of the items from the screenshot above had "default" as their "textalign" property, so maybe that is not what will fix it?
I wonder if there is a lag or trick to get it to update to Tessitura? I recall there is something like that with Infomaker.
Any tips for webinars or other training for improving my knowledge in this area would be helpful. I searched the site but only found stuff that was 10+ years old.
Thanks for your help!
Kanani
Weird... I'm not seeing anything wrong with that. Seems like that box should now be right-justified. Any chance you have the wrong rdl? Are other changes reflected in test after deploying?
Yep, glad I'm not the only one who thinks this is really weird. I just added "TEST" to the report name as a test, and the change updated after saving and deploying. Here it is run in Test Tessitura.
Wondering if the answer is in the data... If you run the proc in SSMS and copy the value out of that field and paste it somewhere... any chance there are a bunch of trailing spaces on the right side of value?
Ding ding ding! You win.
Well, I couldn't easily figure out where the extra spaces were coming from, so I decided to left justify everything and that solves the problem. Thanks everyone! I learned a lot and solved my issue. Thanks!
If you are comfortable with editing the code, using the RTRIM or LTRIM functions in SQL will remove the spaces, if they exist.
Good catch on the spaces Brian Graham!