SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Issue with Formatting/Aligning Objects in SSRS Dashboard


Issue with Formatting/Aligning Objects in SSRS Dashboard

Author
Message
Polymorphist
Polymorphist
Old Hand
Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)

Group: General Forum Members
Points: 353 Visits: 269
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?
Attachments
ReportShot.png (105 views, 10.00 KB)
ReportShot2.png (72 views, 11.00 KB)
Polymorphist
Polymorphist
Old Hand
Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)

Group: General Forum Members
Points: 353 Visits: 269
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?
calvo
calvo
Hall of Fame
Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)

Group: General Forum Members
Points: 3370 Visits: 4018
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.

______________________________________________________________________________________________
Forum posting etiquette. Get your answers faster.
Polymorphist
Polymorphist
Old Hand
Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)

Group: General Forum Members
Points: 353 Visits: 269
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.
pgt892
pgt892
SSC-Addicted
SSC-Addicted (455 reputation)SSC-Addicted (455 reputation)SSC-Addicted (455 reputation)SSC-Addicted (455 reputation)SSC-Addicted (455 reputation)SSC-Addicted (455 reputation)SSC-Addicted (455 reputation)SSC-Addicted (455 reputation)

Group: General Forum Members
Points: 455 Visits: 303
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?
pshields
pshields
Valued Member
Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)

Group: General Forum Members
Points: 51 Visits: 403
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.
Polymorphist
Polymorphist
Old Hand
Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)

Group: General Forum Members
Points: 353 Visits: 269
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!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search