Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Issue with Formatting/Aligning Objects in SSRS Dashboard Expand / Collapse
Author
Message
Posted Monday, August 19, 2013 11:57 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, June 2, 2014 1:21 AM
Points: 25, Visits: 163
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?


  Post Attachments 
ReportShot.png (35 views, 10.02 KB)
ReportShot2.png (35 views, 11.46 KB)
Post #1486113
Posted Tuesday, August 20, 2013 11:14 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, June 2, 2014 1:21 AM
Points: 25, Visits: 163
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?
Post #1486376
Posted Tuesday, August 20, 2013 11:36 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, July 21, 2014 10:07 AM
Points: 1,260, Visits: 3,545
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.
Post #1486382
Posted Tuesday, August 20, 2013 10:41 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, June 2, 2014 1:21 AM
Points: 25, Visits: 163
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.
Post #1486506
Posted Wednesday, August 21, 2013 11:01 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 12:54 PM
Points: 271, Visits: 292
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?
Post #1486811
Posted Thursday, August 22, 2013 6:10 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 3:56 PM
Points: 11, Visits: 379
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.
Post #1487193
Posted Thursday, August 22, 2013 9:34 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, June 2, 2014 1:21 AM
Points: 25, Visits: 163
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!
Post #1487625
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse