.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

Hide static Column in matrix report

Posted By:      Posted Date: September 22, 2010    Points: 0   Category :Sql Server

I created one matrix report. i have 2 static columns and some dynamic (PIVOT) coulmns.

I have one boolean variable. If it is true need to hide first column else hide second column.

For matrix report Column visibilty property is disabled.

How to do this?

kindly help me.

View Complete Post

More Related Resource Links

how to hide a column in Matrix : SSRS 2005

I would like to hide a column in matrix using SSRS 2005 but when i use visibility : hiden then it shows white space and if i reduce a width to 0in; but it accepts by default 0.035in something.i really would like to hide a complete column without any whitespace and all.

Static column after aggreate column in matrix reporting service 2008


Dear sir/madam,

I would like to creating cross tab with static column after aggregate column. My report showed as below:


Name of employee

Performance Rating

Total Rating (Average of Performance rating)

Previous Salary






A. Managerial Employee








B. Non-Managerial Employee








Performance Rating is cross tab column

Total Rating is Aggregate column

Previous Average,Previous,Increment is static column

I look forward to hearing from you.

Thanks in advance,

Report Builder 3.0 renders empty page for Reports with Matrix (column group) in Landscape orientatio


I need some help.


If I create a Report with a Matrix Tablix (with row Groups and column groups) in landscape layout and preview it in print layout, the report generates me some extra empty page every 2nd page.

I don't understand the rule, why it's doing that.


My Report settings are:

  • PageSize: width: 29.7 cm, height: 21 cm
  • InteractiveSize: width: 29.7cm, height: 21 cm
  • Margins : 0cm,0cm,0cm,0cm
  • Report Body : widht: 25cm, height: 10cm

According my Report settings this shouldn't happen, should it. The width of my Tablix is max 22cm.

What I noticed is, that when I shrink the width of my Report Body to 21 cm (to the width of the portrait layout) or less, the emtpy pages disappear.

Or when I delete the column group, it also renders the report without some empty pages.

I think this problem has something to do with column groups.


Is this a bug or am I missing a setting?

SSRS 2005 - Hide column in Matrix



Hi guys.

I'm looking for some help. Maybe someone have run into this, and has a solution for this problem.

I'm having an issue when trying to hide a column from a matrix component, in SSRS 2005.

The reason I'm using a matrix is because I have a query that returns this kind of data:

Candidate name        Candidate Address        Skill Name      Skill importance     Skill Rating


Candidate 1               Address1                     Skill1             3                                 5

Candidate 1               Address1                     Skill2     &nb

Alternating row background for first column of a report


is there a way to make the first column of a report use the an alternating background color? 

I have the background color set for the entire row however it does not work for the first column if the color is set to an expression.  If I just set it to a color i.e. red it works just fine. If I insert a dummy column to the left it works just fine (but the dummy column does not work, presumably because it is first??).

In the file below only the textbox for part number does not show an alternating background.  All others work correctly.

                    <Textbox Name="PartNumber">

RDLC Report Hide Export Option

The article RDLC Report Hide Export Option was added by mandandeo on Sunday, August 15, 2010.

protected void ReportViewer1_PreRender(object sender, EventArgs e) {DisableFormat(ReportViewer1, "Pdf"); }protected void DisableFormat(ReportViewer viewer, string formatName) {const System.Reflection.BindingFlags Flags =System.Reflection.BindingFlags

wss2.0 update/delete/hide lookup column that does not display any values


Hi All,

I have a document library that contains a Category column that is a lookup field. This is a default column that is a required field when uploading documents to the document library. The Category column is empty and I am unable to amend, hide, make it not required or delete it.

I have gone to Modify settings and columns -> clicked on the Category field to edit, but there is no option to amend the content or delete it. I am only able to amend the Column name and Description.

Since then, I have amended the column name to eg. Category1 and created a new Category field as a lookup and linked it to the correct list.

The problem I am facing now, is that I cannot hide, delete or make the Category1 (old Category) field NOT required. Either I would like to update the original field to display the correct values or alternately hide, delete or make the column not required.

Please help.

Hide data for specific column from a user

Greetings, I have a problem. I would like to restrict showing specific users (or roles or schemas) data in a column. First I thought DENY option will do it but figured out that it won't. DENY denies the column being in the SELECT query. I would still like to call the column but if access to the data in that column is restricted it would show only null values and not the real ones. So... I would like call the next query from user TestUser: SELECT ID,Name,Address FROM Employee But if access to Address is restricted for TestUser I would get results like: ID Name Address 1 John Smith NULL 2 Rick Ross NULL ... Is it possible to do something like that in SQL Server 2005/2008? I was thinking of storing that kind of information in a table (for which tables, which columns for which users access is restricted) and then manipulate it on the application site but my programmers tell me that they use components which always call the full table (like SELECT *).  Thank you for your answer.

Expression in Report Column

Hi Guys, One of the column got expression and pointing out to other subreport using iff . However, it throwing me following error message.      An error occurred during client rendering. Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index I am using below expression  =iif(fields!Banner_Type_ID.Value  ="FWR","","Click To Show Business Owners") and underneath the field name red squally line appearing, when you move the cursor on that line it stats unknown collection member. But  that field name does exist in the dataset. Not sure why it appearing in red.  Can anyone shed some light please, thanks, D  

Report with Static Layout (Restrict Rectangle Growth/Static Tablix size)

How do you stop a Tablix or the rectangle that is a Tablix is contained in from growing.  I have been designing a report that must have a very specific layout due to government and commericial policies.  In this report is a header on top, a footer, some other reporting data above and below a rectangle that contains a tablix region.  I need this tablix and/or rectange to stay a constant size, if there are more rows, it should start another page in the report.  Instead, it grows and pushes all the datafields below it, down and off the page.    I have also tried this with a frame.  The table must show within the frame on form only.  The frame can contain maximum of 10 rows, but the table will grow outside the frame and the items below are pushed down and off the page.  I cannot see how I can setup a page break on every 10th row on a table. Does anyone know how setup a constant size Tablix/Table in a rectangle or frame so that it will not grow beyond the specified size (so the data fields below it will not be moved) and will instead create a new page?  This is crucial to our application and we may have to switch reporting solutions if we can get this figured out. Thanks for you help!  

sum of only selected column in matrix

i have a simple matrix where is display yearly sales: i want to show avg_1_year, avg_2_year, which uses the formula : yearly amount / number of month... for avg_1_year: 2010 amount / 8 (since we are in august).. customer       2010      2009    2008 2007  avg_1_year  avg_2_year  A                    500     200      200  200      500/8         (500+200)/20 i dont know how to get values of 2010 for avg_1_year and of 2010+2009 for avg_2_year

hide column in insert template

Hello.  I would like to hide a foreign key column in an insert template.  It is auto populated with jQuery, and it would be great if this column was also hidden from view.  How is this done?  Thank you. 

Hide grid view column if empty

 Hello All, I want to hide a grid view column if that column is empty. How do I do this? I dont have much exp. with grids. Please help me. Thanks in advance.

Trouble importing strange column format report from Excel 2007 to SQL 08

Hi, I'm not sure whether this belongs in this section or the SSIS one so hopefully I've got it right!  Hoping someone will be able to help with a problem I'm having importing a report with header and detail rows from our antiquated POS system into SQL 2008 tables.  The reports export in Excel 2007 format and for each header row there can be one or more detail rows starting from column B.  As such I've tried several things such as openrowset, an Access 12.0 OLE DB source in SSIS and even COM automation of Excel to try and write a conditional split which will hold the header details in variables then write them to rows alongside the detail rows.  I've pasted a small sample of the data here as I wasn't able to attach it: 01/07/2010 @ 11:18 Page: 1 RECEIVING: Voucher Journal Sort: VC|Str|Vou Date|Vou #|Document SID Filter: Voucher Date: 01/06/2010@12:00a..30/06/2010@11:59p Include Item detail: DCS|Item#|Desc1|Attr|Material|Size|Qty VC Str Vou Date Vou # Qty ABC 001 15/06/2010 12345 38 E NN 66 200148 XXXXXXXX RED SHAD E NN 66 200149 YYYYYYYYY BLACK GO E PP 60 200154 ZZZZZZZZZ BLACK CDE 002 16/06/2010 13839 8 F SA 35 217500 XXXXXXXX Natural F SA FL 218674 YYYYYYYYY Chalk F SA WE 221462 ZZZZZZZZZ White FGH 001 21/06/2010 13905 3 F SH 85 126260 XXXXXXXX Navy IJK 001 23/06/2010 13914 3 E AA 61 250005 YYYYYY

Report Builder 2.0 and Matrix Sub totals

Hi All, Hope someone can assist... I am busy building a complex Financial report and have to deal with lots of Sub Totals etc. I basically have 2 questions: 1. I have 2 Matrixes and wan't to "SUM" the sub total from one matrix with the sub total from another (both will have seperate groupings, is this even possible. 2. How do i add the Value of "TextBox1" to the value of "TextBox2", the expression will be appriciated ? Regards  

Snapshot report with matrix sometimes does not display data ... rerun report and it does

Hi All, I am having a strange problem with a snapshot report that is scheduled through Report Manager and runs once a day at approximately 18:30 each evening. The report contains a column chart with a textual category, numeric data, and a date series. Above the chart, is a matrix containing the value of the last bar in each series, and the average value of all bars in the series.  Here's a screen capture of what the report looks like: http://img832.imageshack.us/img832/185/wipu.png The problem is that sometimes the matrix is missing.  The chart still displays properly and all the data is correct.  If I rerun the report manually, and save a new snapshot, the matrix re-appears. For the past 6 months this report has been running flawlessly.  In the past 3 weeks, the problem has occurred twice.  I don't know why. Why would the matrix disappear?  What is causing this, and how can I fix it?  Any ideas? I'm using SSRS 2008. Thanks in advance for any insights. Regards, --DanDJAnsc

Hiding Columns (not column groups) in a Matrix, can it be done

Hi.  I want to be able to hide some of the columns of this report.  For example , I don't want to see the % of State Total for Total column, and I don't want to see the % of Location Total for the other column groups.  Can this be done?  Any help would be appreciated.  Thanks J I am using Visual Studio 2005   Total   Anaheim CA Arlington VA Atlanta GA Count % of State Total % Of Location Total Count % of State Total % Of Location Total Count % of State Total % Of Location Total Count % of State Total % Of Location Total Count % of State Total % Of Location Total USA   3 100.00% 0.02%   0.00% 0.00%   0.00% 0.00%   0.00% 0.00%   0.00% 0.00%   AB 2 100.00% 0.01%   0.00% 0.00%   0.00% 0.00%   0.00% 0.00%   0.00% 0.00%   AE 8 100.00% 0.04%   0.00% 0.00%   0.00% 0.00% 3 37.50% 0.10% 1 12.50% 0.07%   AK 32 100.00% 0.17%   0.00% 0.00%   0.00% 0.00% 3 9.38% 0.10% 1 3.13% 0.07%   AL 161 100.00% 0.85%   0.00% 0.00%   0.00% 0.00% 17 10.56% 0.54% 84 52.17% 6.11%   AP 3 100.00% 0.02%   0.00% 0.00%   0.00% 0.00%   0.00% 0.00% 1 33.33% 0.07%
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