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 12»»

Tablix Tutorial – Step 4 in the Stairway to Reporting Services Expand / Collapse
Author
Message
Posted Wednesday, April 13, 2011 12:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 7:38 AM
Points: 8, Visits: 350
Comments posted to this topic are about the item Tablix Tutorial – Step 4 in the Stairway to Reporting Services
Post #1092571
Posted Wednesday, April 13, 2011 6:39 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, February 19, 2014 1:33 PM
Points: 119, 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?
Post #1092773
Posted Wednesday, April 13, 2011 6:56 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, May 14, 2014 7:57 AM
Points: 76, Visits: 342
Jessica,

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

James


James
MCM [@TheSQLPimp]
Post #1092793
Posted Wednesday, April 13, 2011 8:50 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 7:38 AM
Points: 8, Visits: 350
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
Post #1092885
Posted Wednesday, April 13, 2011 8:51 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, December 12, 2013 10:21 AM
Points: 16, 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
Post #1092886
Posted Wednesday, April 13, 2011 8:59 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, February 19, 2014 1:33 PM
Points: 119, 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!
Post #1092891
Posted Thursday, April 14, 2011 2:41 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:36 PM
Points: 5,303, Visits: 1,378
This series is a must for our juniors.


Post #1093368
Posted Friday, April 15, 2011 2:17 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, July 21, 2014 8:42 AM
Points: 535, Visits: 750
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.


Post #1094392
Posted Wednesday, February 29, 2012 2:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 30, 2013 9:06 PM
Points: 1, Visits: 10
HI

SSRS DEV

How to align the table line?


PLS HELP ME!!
Post #1259347
Posted Wednesday, February 20, 2013 5:28 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, March 31, 2014 8:17 AM
Points: 110, Visits: 182
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.
Post #1422030
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse