Doubt about table report in SSRS 2005

Question

Doubt about table report in SSRS 2005

only4mithunc

SSCrazy Eights

Points: 8434
More actions
February 23, 2010 at 10:05 am

#386376

Hi friends,
I have to create a table report in SSRS 2005,can some one tell me what is the maximum length of the table could be? the reason is my report has so many columns and there is a chance to add more columns in the future.
So is there any limit for the length of the table?
Thanks & Regards,
MC
Thanks & Regards,
MC

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Gift Peddie SSC Guru Points: 73570 More actions · Answer 1

Start with the Max Cap page in the link below click on 2005 for the 2005 version, you should also know the table control in 2005 does not work well in adding columns. However you could just create a new report with all the columns including the new columns as needed.

http://technet.microsoft.com/en-us/library/ms143432.aspx

Kind regards,
Gift Peddie

only4mithunc SSCrazy Eights Points: 8434 More actions · Answer 2

Hi thanks for reply.

But in this link I could see the Max Capacity of the table object, but what I was tryin to know is the max length of the table item in the report (while creating the table report in SSRS 2005)

Regards,

Mithun

Thanks & Regards,
MC

only4mithunc SSCrazy Eights Points: 8434 More actions · Answer 3

Hi Sorry I mentioned length, I wanted to know the max width of the table item in SSRS 2005.

Regards,

MC

Thanks & Regards,
MC

Gift Peddie SSC Guru Points: 73570 More actions · Answer 4

only4mithunc (2/23/2010)
Hi Sorry I mentioned length, I wanted to know the max width of the table item in SSRS 2005.
Regards,
MC

I have created a report that generated more than 270 pages in a test box by default and I would think you may be able to create what is defined in the Max Cap page. The reason SSRS is code taken from other existing Microsoft products.

Kind regards,
Gift Peddie

veeren4urs SSCrazy Points: 2763 More actions · Answer 5

Hi ,

I created One rdl which have Dynamic columns (Max is 278) based on user selection and some times i got the index length (not remembered exactly)error when the data is more.

And i have an issue when i export the report into pdf i am getting blank pages (since controlls are hidden) Can u please let me know if there is any way to reove the blank pages.i know its a bug in ssrs 2005 i am using ssrs 2008.

Thanks

Veeren.

Thanks & Regards,
Veeren.
Ignore this if you feel i am Wrong. 😉

Gift Peddie SSC Guru Points: 73570 More actions · Answer 6

veeren4urs (2/24/2010)
Hi ,
I created One rdl which have Dynamic columns (Max is 278) based on user selection and some times i got the index length (not remembered exactly)error when the data is more.
And i have an issue when i export the report into pdf i am getting blank pages (since controlls are hidden) Can u please let me know if there is any way to reove the blank pages.i know its a bug in ssrs 2005 i am using ssrs 2008.
Thanks
Veeren.

The blank pages in PDF is just a known issue because SSRS is just providing space for your hidden controls, however if you manually set the page layout to landscape you may not get blank pages but the look of the report may change.

Kind regards,
Gift Peddie

veeren4urs SSCrazy Points: 2763 More actions · Answer 7

Hi ,

Thank you very much for quick response.

Actuvally i changed the layout size to landscope since the report body width was lessthan the report width may be it will give the error. Even i placed my tablix into one rectangle if i choose all columns i dnt get the blank pages if i choose 3 or 4 columns i am getting the blank pages....

looking for any ideas...

Veeren

Thanks & Regards,
Veeren.
Ignore this if you feel i am Wrong. 😉

veeren4urs SSCrazy Points: 2763 More actions · Answer 8

Never mind...

Actuvally i changed the layout size to landscope since the report body width was lessthan the report width may be it will give the blank pages

Thanks & Regards,
Veeren.
Ignore this if you feel i am Wrong. 😉

Gift Peddie SSC Guru Points: 73570 More actions · Answer 9

veeren4urs (2/24/2010)
Hi ,
Thank you very much for quick response.
Actuvally i changed the layout size to landscope since the report body width was lessthan the report width may be it will give the error. Even i placed my tablix into one rectangle if i choose all columns i dnt get the blank pages if i choose 3 or 4 columns i am getting the blank pages....
looking for any ideas...
Veeren

I don't understand you because I think you have posted to the wrong section because there is no Tablix in SSRS 2005 because Tablix is one of the SSRS 2008 new features.

Kind regards,
Gift Peddie

veeren4urs SSCrazy Points: 2763 More actions · Answer 10

ok i will add this in the SSRS 2008 section...

Thanks

veeren

Thanks & Regards,
Veeren.
Ignore this if you feel i am Wrong. 😉

only4mithunc SSCrazy Eights Points: 8434 More actions · Answer 11

and....also it looks like the topic got deviated from my doubt... 🙁

Is the max width of table report in SSRS 2005 is 406cm ? , my report has lots and lots of columns...

Regards

MC

Thanks & Regards,
MC

Gift Peddie SSC Guru Points: 73570 More actions · Answer 12

Per Google and Bing that is 156 inches so you should think of using SSRS 2008 where you can create a View with all your columns and use the Table as your command object new to SSRS 2008. When a table is your command object you can consume it in the SSRS 2008 Table control.

Kind regards,
Gift Peddie