Post reply

How Many number of columns we can specify in tabluar report

  • May 1, 2012 at 7:15 am

    #255105

    Hi,

    In SSRS, how many number of columns are we can add In tabluar report ?

    Regards,

    Sudhakar

  • May 1, 2012 at 7:17 am

    #1481778

    How many do you need?

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

  • May 1, 2012 at 7:25 am

    #1481785

    SQL has a maximum of 4096 columns in a select statement.

    a Single, normal(non-wide ) table can have up to 1024 columns in it...but wide tables can have 30K columns.

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

    an html page can technically support any number of columns, it's just up to the browser to render them.

    does that help?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 3 posts - 1 through 2 (of 2 total)

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