August 19, 2013 at 11:57 pm
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?
August 20, 2013 at 11:14 am
Just wondering if anyone might have any ideas. I didn't get a response to this question in the MSDN forum, either, do I need to give additional information?
August 20, 2013 at 11:36 am
Got to admit that I don't have an answer for you right away and I'm not completely sure what you're trying to accomplish. I don't believe "smashing two things together" is something SSRS excels at. It has no "glue"-ability or grouping features (outside of a rectangle). It has no way of relating two unrelated result sets together.
Perhaps your answer lies in your dataset? "smash" your rollup queries together in your dataset then simply display the results in SSRS. The dynamic nature of tablix objects makes them difficult to align with other objects, even within a rectangle.
As far as the report looking different in report manager vs preview in your data tools, they render differently. Hidden fields can sometimes create havoc in IE, but it's mostly just because they render differently. At least in BIDS 2008R2 they did.
August 20, 2013 at 10:41 pm
Yeah, I tried a few different things including the rectangle. Ultimately the best way is to have all the data in the same dataset when using a tablix, using multiple objects just isn't going to work.
August 21, 2013 at 11:01 am
As far as your second question, do you have a decimal in front of -99? If so, -12 would be greater than -.99, hence the error message. What happens if you change your first range from -.99 to -99? Unless I don't understand the numbers being referenced?
August 22, 2013 at 6:10 am
I am doing something similar to what you are trying to do using one tablix. The dataset contains 5 weeks of data. The tablix has two columns. The first column shows data for the current week. To do this I embedded a table inside of the textbox and used a filter on the embedded table to limit the data to the current week. The second column contains the graph for the 5 weeks.
August 22, 2013 at 9:34 pm
pshields (8/22/2013)
I am doing something similar to what you are trying to do using one tablix. The dataset contains 5 weeks of data. The tablix has two columns. The first column shows data for the current week. To do this I embedded a table inside of the textbox and used a filter on the embedded table to limit the data to the current week. The second column contains the graph for the 5 weeks.
Interesting, I didn't know that you could embed a table inside a cell within a tablix. I'll try this, thanks!
pgt892 (8/22/2013)
As far as your second question, do you have a decimal in front of -99? If so, -12 would be greater than -.99, hence the error message. What happens if you change your first range from -.99 to -99? Unless I don't understand the numbers being referenced?
Hmmm...I didn't think about this. This might be what's happening, thanks!
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply