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


Tablix Tutorial – Step 4 in the Stairway to Reporting Services


Tablix Tutorial – Step 4 in the Stairway to Reporting Services

Author
Message
Jessica M. Moss
Jessica M. Moss
SSC-Addicted
SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)

Group: General Forum Members
Points: 492 Visits: 360
Comments posted to this topic are about the item Tablix Tutorial – Step 4 in the Stairway to Reporting Services
JennyDBA-Atl
JennyDBA-Atl
SSC Veteran
SSC Veteran (269 reputation)SSC Veteran (269 reputation)SSC Veteran (269 reputation)SSC Veteran (269 reputation)SSC Veteran (269 reputation)SSC Veteran (269 reputation)SSC Veteran (269 reputation)SSC Veteran (269 reputation)

Group: General Forum Members
Points: 269 Visits: 92
Thank you for the post. I am relatively new to RS. I have a tablix object displaying in a table. Table bound to a dataset. I added an image to the details group. Is there a way to bind the visbility of the image to an expression using another field from that detail row? I don't want to store the image in the database, so I set the image as embedded, but when I go to visability, "show or hide based on an expression," and hit Fields, it says "Report item not linked to a dataset." However, if I hit Dataset, I can pick First([whatever field I want]). What if I want to do the actual value of a field in that detail row? Is there a way to do it?
James A Skipwith
James A Skipwith
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1030 Visits: 755
Jessica,

A fine series of articles and certainly a good learning tool for my junior developers!

James

James
MCM [@TheSQLPimp]
Jessica M. Moss
Jessica M. Moss
SSC-Addicted
SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)

Group: General Forum Members
Points: 492 Visits: 360
Hi Jenny,

That should absolutely work for you, but for some reason, SSRS doesn't think the image is in the table. Try deleting and re-adding the image in the table. When you click on the image, the properties pane should show the image ID. If you click escape, the properties pane should immediately show the table ID. That will tell that it is truly embedded.

Also, make sure that the table is linked to the dataset. That will be the DataSetName is populated in the table properties.

HTH,
Jessica
pjcrout
pjcrout
SSC Veteran
SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)

Group: General Forum Members
Points: 292 Visits: 78
I'm curious to know if anyone else has encountered an issue with toggling the visibility of the groups and sub groups within the new tablix object in VS/BIDS 2008.

In our legacy dev environment we were using VS 2005 for SRS Reporting and in using the Matrix object, we could easily create multiple levels of drill down within one Matrix, each Sub-Group toggling it's visibility off of the text box of the group above it (row groups, along the left side of the Matrix).

Now with the Tablix, it seems that if the visibility of the sub groups is defaulted to hidden and set to toggle off of each group prior (save for the top level group which does not toggle, and is defaulted to visible) then the entire row will disappear. It is only when you default just the first sub group to hidden, and allow all others to remain visible after the first drill down (which results in a huge explosion of data instead of a gradual reveal to just what you are interested in), only then does it allow the row to remain visible/accessible.

I'm sure I'm just missing something in the change from Matrix to Tablix, but several other developers I collaborate with have reported experiencing the same issue, so I wanted to see if anyone else had seen this, or found a solution, or if it was indeed an known bug that we need to patch for?

I should note, that it seems to work fine in the Preview Pane within VS/BIDS 2008, only when deployed to the Reporting Server does this hidden row issue crop up, which is what lead us to believe it may be a patching issue on that server.

Thanks in Advance,
Paul
JennyDBA-Atl
JennyDBA-Atl
SSC Veteran
SSC Veteran (269 reputation)SSC Veteran (269 reputation)SSC Veteran (269 reputation)SSC Veteran (269 reputation)SSC Veteran (269 reputation)SSC Veteran (269 reputation)SSC Veteran (269 reputation)SSC Veteran (269 reputation)

Group: General Forum Members
Points: 269 Visits: 92
I probably should add that I'm using SSRS 2008 (not R2). I did as you suggested and the image is embedded in the table and the table is linked to the dataset. It still says under Image Properties\Visibility\Show or Hide based on an expression\fx\Fields\ "Report item not linked to a dataset." However, I went back and removed the first() and just typed in whatever field.value I wanted and it did not return an error when I previewed. I suppose it's just the expression builder (fx) that thinks the image isn't linked to a dataset.

Thanks for your help!
Anipaul
Anipaul
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13429 Visits: 1407
This series is a must for our juniors.



Misha_SQL
Misha_SQL
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2660 Visits: 1037
Thank you for the article. I've been using tablix control in RS 2008 for sometime, mostly relying on my intuition, so it's great to have the information presented in a structured and scientific way. Gives me a new perspective on things.



ufo343425185
ufo343425185
SSC Journeyman
SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)

Group: General Forum Members
Points: 77 Visits: 10
HI

SSRS DEV

How to align the table line?


PLS HELP ME!!
mike.renwick-894639
mike.renwick-894639
SSC Veteran
SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)

Group: General Forum Members
Points: 252 Visits: 190
I'm a fan of the flexibility of tablixes (tablices?) but one thing I find really awkward/annoying about them is when saving as XLS, you inevitably end up with merged cells or worse, weird anomalous rows and columns if you have any media / images in the headers (usually down to alignment of edges of things). The resultant output is pretty user-unfriendly...

Worth noting, to anyone starting out with them. If you have users that like to autofilter xls outputted reports, you may wish to look elsewhere.
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