nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Dynamic Title and dynamique pagination

aigle83

Hello,
can you see my report in attached file?
it display the numbers of employes by city

i want ;by i don't know how

;to have many pages, in each page a title for example : Country : [COUNTRY] and a table of total employes by city for the country showed in title.

i hope that you understant me.

Thanks for help.

Find more posts tagged with

Comments

mwilliams

I think this is what you're wanting. All you have to do is group the table by the COUNTRY field and choose to page break always excluding last for the page break after in the group editor. Let me know if this is what you're wanting and/or if you have any questions!

aigle83

Thanks you mwilliams for your help,
just one more question and all will be ok

,
it s possible to separate the title that display the country name from the table ?
Thanks.

mwilliams

Can you explain more about this? Why does it need to be separate?

aigle83

I want customise the title of each page.
for example in each page :
---Title : Country : [Country]
space
---Table : number of employes by cities

mwilliams

Something kinda like this?

aigle83

Oh yes, thank you very much mwilliams.
i will test if this solution works with a cross tab.

mwilliams

If you're embedding a crosstab into a table that is grouped by "country", you'll need to use a filter to limit the crosstab data to that of the outer group value. Let me know if you run into any snags!

aigle83

Hello mwilliams, thank you for your reply 
i don't understand why i should use a filter, can you explain me with an example ? 
Thanks. 
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="73715" data-time="1298413906" data-date="22 February 2011 - 03:31 PM">
If you're embedding a crosstab into a table that is grouped by "country", you'll need to use a filter to limit the crosstab data to that of the outer group value. Let me know if you run into any snags! </blockquote>

mwilliams

What is your BIRT version?

A filter is needed to limit an embedded crosstab because you don't have a dataSet binding parameter option to use. If you just put a crosstab inside the grouped outer element, you'll get every value in the crosstab, not just the ones asoociated with the group. By using a filter, you limit the crosstab to the outer group's values. Hope this explains better what I meant. Let me know if you have questions.