SSRS Fixed Table Size
Hello, I am trying to find a way to fix the size of a table in SSRS so that it would not push any items underneath it when it grows, due to multi-row data set. I have set the canGrow = false property of all the text boxes in the table, but this did not help. Does anyone know if it is possible to force a fixed size of the table and how it is done? Thanks. TF
October 16th, 2006 7:51pm

I had no idea that my question was that difficult. No replies!!! I guess this means that the capability is not there in this release of SSRS. Does Microsoft agree?TF
Free Windows Admin Tool Kit Click here and download it now
October 17th, 2006 10:30pm

CanGrow only affects the vertical growth of textboxes themselves to accomodate large amounts of text. If you have multiple rows of data in your table, whatever is underneath the table will always be pushed down when the table rows repeat. Just curious, what is your desired behavior? Do you want to the table to overlap the item underneath it when it grows? -Chris
October 17th, 2006 11:33pm

Chris,Thank you for the reply. To explain the problem better, I am trying to create a form in an SSRS report. A good example would be an invoice that is generated by SSRS. With 2 datasets one would have the the shipping address and the other would have the repeating items in the body of the invoice like the description, unit price and quantity. Now, I would like to have a total at the bottom of the invoice in a fixed position. The behavior of the table which I would like to change is "keep the items in the table and grow it if you like, but do not allow the table size to push the components below (like the total box)". Maybe this is accomplished by another type of component other than the table, or maybe the table can behave this way?The big question is, Can Microsoft SSRS create such a report type (invoice)?I appreciate any insight on this.TF
Free Windows Admin Tool Kit Click here and download it now
October 18th, 2006 5:58pm

I am begining to think that an invoice is not an application that SSRS 2005 can handle from the lack of responses. Maybe a future release will have this popular type of report. For now, I guess I need to find another solution to my problem - somewhere else. Does anyone know of a system that can handle that type of application?Thanks.TF
October 19th, 2006 4:05pm

I have a similar requirement. The reportwe are developinghas multiple tables on it, each table needs toappear on the reportin the same location every time.The invoice example is a good analogy to what we are trying to accomplish.No table in the report should not affect the absolute vertical position of the table below it. If it happens that the table cannot show all the data within the allocated space it should truncate the data and just display enough to fill it's allocated space. I think any sort of a form being developed in a reporting tool will have thisrequirement. Is SSRS not meant toautomate forms like invoices?
Free Windows Admin Tool Kit Click here and download it now
April 11th, 2008 3:25pm

Hi, Might be silly but i wanted to know what you are saying about the invoice ,is it some calculation to be put into the table footer automatically? Could you please let me know how exactly you want the layout should look,so that i can think of? Thanks Mahasweta
April 11th, 2008 4:48pm

Iusedthe invoice analogy to continue the example used in the previous post. Here's a description of the layout I need to achieve. The reporthasfour tables laid out as (t1 = table 1)- <header> t1 t2 t3 t4 I need each table to appear in the same fixed position on the printed report always. Therefore Table t1 or t2should not vertically grow or shrink which will cause t3 to move up or get pushed down. Basically I want to assign a fixed height to each data region (table). In cases whentable has too much data to fit in the assigned area it should truncate the returned datasetrather than grow vertically. Thanks for your help.
Free Windows Admin Tool Kit Click here and download it now
April 11th, 2008 8:46pm

Try limiting the number of rows visible to the size thats suitable for you.
May 6th, 2008 3:06am

Hi,I've done some SSRS development for invoice/sales order/work order printing in the past. It works fine but tricky, especially when dealing with company logo position, page-break or footer information or printing on company template.From my personal experience: in order to print invoice-like report with SSRS, you need to know exactly how to invoice layout, its behavior (conditional printing), rules, etc etc. Then from you will determine what data region to use (I use combination in my invoice printing to collect all info from different data sources). And finally, fixing the print position.Just my two cents,XL
Free Windows Admin Tool Kit Click here and download it now
May 6th, 2008 4:52am

If you want for example 5 rows I think you can have one detail databound row and 4 empty detail rows having the following visibility setting: detail row 1 (databound) detail row 2 visibility hidden = IIF(CountRows() > 4, true, false) detail row 3 visibility hidden = IIF(CountRows() > 3, true, false) ... detail row 5 visibility hidden = IIF(CountRows() > 1, true, false) to be tested... Miken
October 9th, 2009 8:13pm

I have the requirement to print invoices as well, only I am printing onto a pre printed template, so my boxes have to be in the right area.The sql approach is a good idea, but if I overflow on my report I need to be able to print onto another page, in the same place :-9Scott
Free Windows Admin Tool Kit Click here and download it now
November 6th, 2009 4:53pm

You have a fixed layout reports (or pixel-perfect) problem which is kind of hard to handle in SSRS, I guess you have inserted a scanned version of your form template to your SSRS report. The best solution that I came up with is to split your template image in three different areas (header, footer and details) and then insert these three images in your report header, footer details correspondingly, Adjust these images that they connect to each other pixel-perfectly and move your header and detail controls in to the regions that they logically belong (header and footers). However you cannot have field values in footer and header so the solution is a bit tricky. You have to refer to a textbox (a hidden one) that resides in details area from the text box that resides in footer/header area and use one of workarounds http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/2f6adaab-cd9e-4239-9ac1-62bb3a1053db for example: =ReportItems("TextBox1").Value
June 25th, 2010 5:56pm

Use matrix insted of table and apply proper setting you will able to get the required result. Thanks & Regards, Kamal Agarwala +919916516212
Free Windows Admin Tool Kit Click here and download it now
August 27th, 2010 3:05pm

Hi Kamal, which proper setting do you suggest exactly? Thanks!Regards, Arcus (working on SSRS 2008 R2)
June 9th, 2011 12:06pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics