So i'm sure this is not a new question to some of you, but i'm having a b**ch of a time trying to get objects to align correctly in SSRS. I basically have two questions regarding this -
1) I have two tablix objects which I need to push together as if they were one tablix object. Yeah yeah, I know..."why you doing that", you're probably asking yourself. Well, the PM on the project mocked-up the dashboard to display data which is aggregated up to a company level (things such as total items sold, total items consigned, etc) for one week. The end user selects the week and views that week's data. Well, the PM also attached a sparkline to the same table which shows a quick trend for sales performance for the previous five weeks. I couldn't find a good way to have five weeks of data return in a dataset which aggregates up for one week, so I split the datasets in two. Now I have to glue these suckers together. The problem i'm having is that two tablix objects don't go together so well. I've got both of them laid out and sorted so they match, however I had to hide a column in the sparkline tablix so that I could sort it correctly. This does weird things when you try to smash two objects together. Even when I get them to line up corrrectly in Data Tools studio, it renders very weirdly in Report Manager.
Specific question: How does one go about aligning/putting two separate tablix objects together like that? I've tried putting them in a rectangle, but that doesn't work, either. Please see the attached image (my image host isn't supported here for screenshot?), it looks okay in the shot (they are taken from Data Tools studio), however they do not align in Report Manager at all and they look sloppy. Any advice on how to get them to align correctly?
2) I'm having a hell of a time using directional indicators. Now, for the most part, they work, however for three of four of them I get the "minimum cannot be greater than maximum" error which is very strange. I'm using the same ranges on all of my indicators and most of them work. I do have negative numbers, so I'm doing something like this in my ranges:
Start = -.99 END = 0
Start = 0 END = 100
See the attached image regarding this issue (also another example of the sparkline tablix)
Any advice on either or hopefully both issues?