Jump to content
Changes to the Jaspersoft community edition download ×

Table- dynamic rows-static colums


nsamagond

Recommended Posts

 how can I  create a table where the number of rows  are unknown at design time but the number of columns are fixed?

I dont think crosstabs work for this.

 

Thanks in advance

 

 

 



Post Edited by nsamagond at 05/21/2009 00:19
Link to comment
Share on other sites

  • Replies 4
  • Created
  • Last Reply

Top Posters In This Topic

nsamagond,

 

What you're describing is a typical tabular layout. It's handled by the built-in report wizard. You return a fixed number of fields from the data source. Then you display each in the detail band. The band is repeated for each row, so you don't need to know how many rows there will be.

 

Regards,
Matt

Link to comment
Share on other sites

Thanks Matt.

I have a follow-up question.

I have several tables to display and in the detail band, but the way it works, as I understand,  it only displays one table.

 

So, for example if my query returns a 100  rows which have 75 colums, I have to display 5 tables, each table have will have about 8 -13 random columns of the 75 columns and each of the 100 rows.

 

Thanks!



Post Edited by nsamagond at 05/21/2009 19:10
Link to comment
Share on other sites

nsamagond,

 

Could you start a new thread with this new question?

 

Please add a few details. I'm not at all sure what you mean by "each table have will have about 8 -13 random columns of the 75 columns". Maybe it's best to describe what you want to see in each of the 5 tables, then we can offer guidance about how to achieve it.

 

Regards,
Matt

Link to comment
Share on other sites

  • 3 years later...

Hi nsamagond,

 

I understood your query.just create three different detail band and put the header into first band,put data into second band and if u want to calculate any total means just put into third detail band.each of the band size id based on ur data section(header size,data size and total size)using textField for all the details.and set the when blank null and remove line when blank is true.and set the expression for three band because of which case u want put header and data and total.

 

 

Regards,

thiru.k

Link to comment
Share on other sites

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...