.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Select complete row in a tablix in ssrs

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :Windows Application

I want the user to be able to select the whole row in a tablix just by clicking on it similar to asp.net gridview. How can I do that? I have lots of drilldown reports. First I have to display a list of patients and then I have multiple drilldowns on different aspects of patient details. So what I want to do is show a list of patients. Then the user selects a row and clicks buttons that would dsplay detail reports 1, 2, 3....

Is that possible?

I don't want to repeat the initial patient list for each detail report.

View Complete Post

More Related Resource Links

How do you freeze the tablix header row in an Excel export file in SSRS 2008?

So this is totally killing me. I've found out how to make a tablix header row repeat on each page of a PDF export file in SSRS 2008 (which I won't even get started on because all I can say is that 2005 is way better), but I cannot figure out how to make a simple header row of a tablix freeze in an Excel export file.  The tablix is right at the top of the body and spans the entire width of the design area.  How in the world do you get it to freeze in the Excel export file?

API SSRS 2008 for php multi-select

Hi, I use API SSRS 2008 for php .  We have create with a report builder  a report to use multi-select. In the manager web SSRS we can use  multi-select filter option. But with API i don't see the possibility to use multi-select. Is-it possible ? Regards Marc       

Hiding rows/columns completely in SSRS tablix even when they have data

I have several columns and rows in my tablix.  I don't want to see all of them at once.  I am using a parameter that controls the visibility of the columns or rows of the tablix.  The issue is that it hides but the white space is left.  How do i take out that white space?

In SSRS 2005 in y-axis i want to display only those dates which are coming from select statement one

For example in select statement:   select date  from Employee   Now i want to show only this date field in y-axis in ssrs 2005, how can i resolve this issue?

Tablix header not repeating in SSRS 2008



I have a tablix header which is not repeating on each page. I have tried all the suggestions given for this issue in the forum but no luck.

for e.g: The repeat header rows in Tablix properties

Steps in Advanced Mode "RepeatonPage" etc.

I have a tablix with headers and two groups. The tablix structure is as below

Zone  Product Client Amount.

Here Zone is Parent group of product group. For both these groups i have tried the advanced mode suggestions. "Zone" Visibility is hidden in the report.


Thank you for your assistance.



SSRS cascading parameters always select all


I have 4 paramters that are cascading(the last parameter depends on the one before that and that one depends on the one beofore that etc.) The are all multivalue with a select all option.

When I click 2 options in my first parameter all values in the list below that get checked. This is good. Now when I click an extra value in my first parameter in the parameter under this the new values show up but they do not get selected. Is there a way to always select all in all parameter lists?



Page Breaks within tablix (SSRS 2008)



page breaks seem to be a real issue in SSRS, according to the number of posts, but I haven't found a solution for my problem yet.

My report contains a tablix which is used to group the data by keys. The tablix has one column and one row, and this cell contains several subreports which get their data from another table depending on the keys of the groups. This works quite well. However, I would like to insert a page break in between the subreports. I tried inserting a rectangle with the PageBreak property set to Start and/or End, but this is ignored. Page breaks in the subreports themselves are also ignored. Having the subreports in rectangles with PageBreak property set to Start or End is ignored as well.

The only way I have found to force page breaks is cross-joining my query of the main report with a table containing page numbers, add the page number field as the last grouping in SSRS and check the "Page breaks between each instance of the group", then showing or hiding the subreports conditionally depending on the page number retrieved from the database. However, this obviously multiplies the amount of retrieved data by the number of pages and is therefore a rather slow approach.

How can I insert a page break between rows of a tablix or even within one row?

We are using the Report Viewer control in local processing mode

Header Displayed For Hidden Tablix in SSRS 2008


I have inheritted a report which was written in SSRS 2005 and I am trying to migrate to SSRS 2008. It contains 2 overlapping tables - with different contents. Depending on a parameter selection either 1 or other of the tables is displayed. This is controlled via an expression in the visibility property of each table.

The display/no display of the tables works fine - but in 2008 an extra page with a header and footer is displayed for the 'invisible' table resulting in an unwanted page. Is there a way to avoid this and why doesn't it work in the same way 2005?


Sorting on a Tablix in a Matrix Report SSRS 2008



           This is the format of my report and I am trying to get the rows sorted.I do know about interactive sorting but I do not want to use it because this report will be called by an external web application and I want this report sorted before it is rendered to the user.

                                                                    A         B        C

Agree                                          4.0           23        45     10

Disagree                     &

How to set WritingMode on tablix column on the fly in SSRS 2008?


I've tried setting the writingmode on a RDL I've created through the XML. I just can't display some table headers vertically. Can anyone help with what I'm doing wrong.

- <TablixCell>
- <CellContents>
- <Textbox Name="HeaderProduct645432219">

Tablix headers not repeating in SSRS 2008


I have created a new report & add a table to it. When I select "Tablix Properties" and check on Columns Headers -> "Repeat Cheader columns on each page" the header columns do not repeat on each page. I also tried "Repeat header rows on each page". "Add page break before" seems to work ok. I am using VS 2008 9.0.30729.1 SP

I also tried deploying but it still does not work on the deployed version.


Interestingly, reports migrated from 2005 & unchanged seem to be ok.


Any ideas? Am I not setting soemthign up properly?


How do I select groupings in a Tablix



How do I make the yellow bracket which defines a tablix group enclose more than one row. I want to include two rows with each group: one at the top and one at the bottom.

I have this now in the tablix:




I want this:


|  Top


|  Bottom


I think this might be what is needed to have the Top and Bottom rows print with each grouping.




AJAX GridView Checkbox Select All in ASP.Net

In the previous article GridView Select Multiple Rows you learnt the multiple row selection in GridView control. Here you will get the C# code sample to select all the gridview rows using single checkbox server control. You can highlight the selected rows with different color and Font state Bold. If you want to use the selection values on different ASP.Net

Complete SQL Solution

SQL Server Solutions: SQL Server 2000/2005 Related Free Snippets.

Parallel port complete: programming, interfacing & using the PC's parallel

Parallel port complete: programming, interfacing & using the PC's parallel


Select value in gridview


Hi, I am new to gridview. I want to make a gridview. Its row when selected should direct me to a specific .aspx page.Each row should direct to a different page. Should I use querystrings for this? Please suggest. Regards, ap.

where can i download from SSRS?


Hi all,

My  machine is alread installed with Sql Server 2005.  I need to install sql server 2005 reporting services as a add-on.

Where can i download this from. Can anyone post the link here..?


Thanks in advance


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend