Jump to content

How to adjust large number of columns in the spotfire to make it like a Tabular Report

Afsarr rr

Recommended Posts

Hello Everybody ,


I am trying to prepare reports which consists of more than 40 columns in the data table.

If i decrease their font size then the report is not readable.

Please suggest if you have any ideas to adjust the columns in the spotfire and generate the pdf as tabular report.

Thanks in Advance.

Link to comment
Share on other sites

If you have numeric values in your table I suggest to change the number format (# of decimals, scientific...). You can do this under 'column properties' -> 'formatting'.

You can also change the table header and cell height to something >1. This will spread text inputs to multiple lines. Go to the data table properties -> 'appearance'

Link to comment
Share on other sites

It really depends on the data that you want to display...  Is a data table with 100 columns on one page really the right format to tell your story


You can change the column header to vertical style. Just left click on a header and chose this option. This will allow you to make quite narrow columns. But of course narrow columns will limit the text that can be displayed. 


What kind of values do you want to display How many rows does your table have Have you tried to summarize your data with a cross table Maybe you can share a screenshot of your table here to get a better understanding.

Link to comment
Share on other sites

  • 1 month later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...