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-Enthusiastic
SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)

Group: General Forum Members
Points: 102 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-Enthusiastic
SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)

Group: General Forum Members
Points: 145 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
SSC Veteran
SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)

Group: General Forum Members
Points: 270 Visits: 685
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-Enthusiastic
SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)

Group: General Forum Members
Points: 102 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
Valued Member
Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)

Group: General Forum Members
Points: 62 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-Enthusiastic
SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)

Group: General Forum Members
Points: 145 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
SSCertifiable
SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)

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



Misha_SQL
Misha_SQL
SSC Eights!
SSC Eights! (962 reputation)SSC Eights! (962 reputation)SSC Eights! (962 reputation)SSC Eights! (962 reputation)SSC Eights! (962 reputation)SSC Eights! (962 reputation)SSC Eights! (962 reputation)SSC Eights! (962 reputation)

Group: General Forum Members
Points: 962 Visits: 1004
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
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

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

SSRS DEV

How to align the table line?


PLS HELP ME!!
mike.renwick-894639
mike.renwick-894639
SSC-Enthusiastic
SSC-Enthusiastic (134 reputation)SSC-Enthusiastic (134 reputation)SSC-Enthusiastic (134 reputation)SSC-Enthusiastic (134 reputation)SSC-Enthusiastic (134 reputation)SSC-Enthusiastic (134 reputation)SSC-Enthusiastic (134 reputation)SSC-Enthusiastic (134 reputation)

Group: General Forum Members
Points: 134 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