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

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

SSRS Table Header working differently in and out of print layout

Posted By:      Posted Date: September 02, 2010    Points: 0   Category :ASP.Net
Please help. This is bizarre and seems like a bug to me. Using a table in SSRS, I have a details row, with a parent group and finally a header row.  For my header row, I am referencing a particular cell in the parent group. I am doing this so that i can have the header row repeat on each page of the group. This works fine when I'm not in Print Layout mode. However, when i switch to print layout mode, or print the report itself, the data that is presented on the screen is different then what is presented when not in print layout mode. WHAT THE F*!@!?? I've been battling this for a while now and i'm at my wits end. Has anyone else experienced different results from when you are in print layout mode as opposed to being in print layout mode?

View Complete Post

More Related Resource Links

Table Header (Title) Row need to repeat on each page. How to do this in SSRS 2008 & above?



I have a requirement, where 1st row (Hearder) should repeat on each page.

For Example:



Experience in Years




So I want to repeat


KeepTogether=false on table not working within rectangle


I have an rdlc report that has a table contained within a rectangle. Since I have multiple data sections within the BODY of the report, I am using rectangles to keep them separated.

Anyway, the problem is that <KeepTogether> set to false on the table is not working when the table is contained within the rectangle, causing unwanted page breaks and acting as though KeepToghther is always true. The rectangle does not have <KeepTogether>.  When the table is outside the rectangle everything works fine.

Any ideas?



Change grid view from table to other HTML layout



You'll have to excuse my ignorance, I'm coming at this from a front-end perspective, and don't really know how to deal with data views in ASP.NET.

Basically, I'm trying to change the layout of some repeated data from a straight table, to something more design-heavy.  It's the same data, just re-organised slightly.  The current ASP.NET code looks like this:

                    <asp:GridView ID="GVMoments" runat="server" AllowPaging="True" AllowSorting="True"
                        AutoGenerateColumns="False" PageSize="20" RowHeaderColumn="FirstName"
                        SkinID="GroupSkin" DataKeyNames="moment_id" 
                        <PagerSettings Mode="NumericFirstLast" PageButtonCount="20" Position="TopAndBottom" />
                        <RowStyle />
                                <asp:BoundField DataField="moment_id" HeaderText="moment_id" ReadOnly="True" SortExpression="moment_id"
                                    Visible="False" In

Table-Layout attribute and MSDN claims re capabilities

I am developing a CompositeDataBoundControl that is basically a 'table' inside a 'div', in order to limit the size of the Control and use the scrolling capabilities of the 'div' tag ('RenderBeginTag("div"). So essentially the control is; <div style="overflow:auto;width:400px;height:300px;"> <table style="table-layout:fixed;">   My problem/question has to do with the capabilities claimed by MSDN of the CSS Attribute 'Table-Layout'. See; http://msdn.microsoft.com/en-us/library/ms531161(v=VS.85).aspx   One of the essential goals of my Control is to limit the width and height of 'Cells' (<td>'s) in the table and let the content be clipped.  MSDN says one can do this by setting the 'width' property of each Cell in the first row of the table. I have no problem with this and it works just fine.   My problem is that MSDN also claims that one can set the height property of each row and that any wrapping of text is 'clipped' and the row height is maintained. See Remarks section; "If the row height is specified, wrapped text is clipped when it exceeds the set height".  I can't make this happen. Any time whitespace occurs in the cell content, and the content exceeds the cell width, the content is wrapped to a new line and the row/cell height is adjusted automatically to fit all the content. In other words it appears that MSD

SSRS Table hide duplicate by date

Hi, I am parikshit deshpande i am working in SSRS 2005 from last three months. I am trying to solve this problem please help me for that, I have one table as per  Date                     Shift                               Tons                       Passes 1/1/2009            Day                                    Formula                  Formula 1/1/2009           Swings                            1/2/2009           Day 1/2/2009     &nb

PIvot Table in SSRS 2008

Hi All, Is there any data Region (Pivot) in SSRS 2008 or higher version? Our requirement is to show the report like excel pivot gererated from a OLAP Cube where we can select or unselect any dimesion attribute or measures. Thanks, IndiaSQl  

Key press in SSRS to Enable print/Email/Export

Hi All   How do we enable key press to the Print/ Export button in SSRS  Also how to enable Email in SSRS   Regards  Sooraj

SSRS 2008 - repeating a non column header column on every page

Hi - I am working on my first SSRS report and I have mostly all of it down except one issue. Per requirements, I need to display a column that is a non header column to repeat on every page while printing and or when I save the generated report in SSRS as a PDF file. I have seen some previous blog from 2007 where RepeatWith property is recommended to be set to the same name of the Tablix in which the column(s) are embeded, tried that but it is not working. Can any one help me on this or guide me how to resolve this? Thanks, Manny

Repeat header rows on all pages when you export to excel sheet and print it

Hello , I need to export report into excel sheet. And when people try to print it . The header rows only appear on First page of the print . Other subsequent pages d onot have header rows. I saw another thread saying SQL server 2008 R2 will solve the issue. Can you tell me that is fixed and how to i go about configuring it on SQL server 2008 R2.   Thanks Madhavi

ReportViewer Print Button not working correctly with windows 7 clients

I need some help being pointed in the right direction to fix the following issue: - After building several reports using reportviewer and testing with windows XP clients everything seemed to be fine.  I noticed that the first time the client loaded the asp.net website and clicked the print button it asked permission to install a small file (I assume this is to allow the reportviewer to access the clients printers).   - The problem I have is on Windows 7 Clients.  They can view/export the reports with no problem, but when they click the print button it ask permission to install the small file, but a error is given during the install process and the file is not installed.   If anyone has a solution or can point me in the right direction it would be helpfull.  I am using Visual Studios 2008 on Windows XP PRO and the site is hosted on Windows Server 2003 R3   Thanks 

Integrated SSRS and kerberos working great.But one user gets An unexpected error occurred while conn

I have this one user who can access SharePoint with no problems otherwise but is getting errorAn unexpected error occurred while connecting to the report server When they try to access an SSRS reports I confirmed he has access. Client issue? AD Account issue?Thanks.

customize list view table header css file

i need to make table header for my list to be red and on hover to get specific  image so all my site have the same appearence also i need this to reflect to the list view webpart thanks

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?

SSRS custom security extension behind a router fire wall not working

I have a instance of SSRS 2008 installed (we are not using IIS) with custom security extension which accepts a application user ID and password and sends back a sql authorization cookie back to client for logging into SSRS.  The (SSRS) server is behind a router,  SSRS is configured on port 81,  Port 81 in router if forwarded to the SSRS server. Here is the problem If I am inside the router firewall (RDP'ed to the machine) I am able to access report server (http://xx.xxx.xxx.xx:81/ReportServer) and reports manager (http://xx.xxx.xxx.xx:81/Reports) without any issues. If  am outside the firewall and try to go to report server page (http://xx.xxx.xxx.xx:81/ReportServer) from browser and try to login it works (I am getting the cookie back and authentication goes through fine).   But if I try to access reports manager (http://xx.xxx.xxx.xx:81/Reports) the login page shows up when I enter user ID and password and hit enter to authenticate it comes back to the login screen (I am not gettint the cookie back from SSRS). Any help is highly appreciated on how to debug /fix this issue. Note : if I first login to Reportserver (which sends the cookie back) and in the same session I login to Reports Manager I am able to get into Reports Manager page since I got the cookie when I logged in to reports server page already.  When I

Master Page and table layout

Hi, i am in the process to learn create master page using HTML table layout.I find out many resources online that use table to design their master page layout.I have 1 thing that i do not undestand:all of them using heigh= n pixel to control their footer, header, content  and navigation menu.My concern is that by doing so, the master page is fixed to only particular resolution only.In future there might be higher resolution available, the master page design need to be changed from time to time which is considered not so good programmer.OR in future, the when site need to have something like "Best view in resolution 1024 x 768", somethign like that...Is there any other way not to do so? Are they doing their master page correctly?

CSS float tables only allowing row of tables start at table header

Hi,I have a page of tables which take in information from the user. I am trying to get the tables to float to the right so I have two rows of tables. But for some reason. Each row of tables starts together. So there is a gap on one of the sides before the next table. Any help would be really appreciated  The CSS is .tableColumnFormat{    padding-top: 3px;    padding-bottom:3px;        width: 180px;    }.labelFormat{    float: left;    padding-left: 5px;    text-align: right;    font-size: medium;    width:180px;    }.tableFormat{        background-color:White;    width: 450px;    border:solid 1.5px #38a7db;        float: left;    margin-bottom:10px;    margin-left:10px;    margin-right:10px;}.tableColumnFormat2{    float:left;        padding-left:5px;    }.headerFormat{    text-align: left;    padding-left: 10px;    color:White;    background-image:url('App_Themes/MasterTheme/Images/table_header_background3.gif');    }

SSRS how to expand table horizontally in SSRS

I am trying to make a report in SSRS. My requirement is to expend table dynamically instead of vertically..is this possbile in ssrs.
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