reporting services - SSRS Multiple page for each DataSet's row -

ciao, scenario.

i'm building report sql server reporting services.

i have 2 dataset:

• continent
• countries

and build report that:

+----+-----------+ | id | continent | +----+-----------+ | 01 | europa    | +----+-----------+  +----+-------------+ | id | countries   | +----+-------------+ | 01 | italia      | +----+-------------+ | 02 | switzerland | +----+-------------+ | 03 | germany     | +----+-------------+ | 04 | etc.        | +----+-------------+ 

my report work 1 page. generate multiple pages that:

page 1 +----+-----------+ | id | continent | +----+-----------+ | 01 | europa    | +----+-----------+  +----+-------------+ | id | countries   | +----+-------------+ | 01 | italia      | +----+-------------+ | 02 | switzerland | +----+-------------+ | 03 | germany     | +----+-------------+  page 2 +----+-----------+ | id | continent | +----+-----------+ | 01 | america   | +----+-----------+  +----+-------------+ | id | countries   | +----+-------------+ | 01 | usa         | +----+-------------+ | 02 | equador     | +----+-------------+ | 03 | perù        | +----+-------------+ | 04 | etc.        | +----+-------------+ 

how can generate multiple pages example above?

thanks

it looks combining 2 datasets 1 , grouping on continent work. can set page break after each continent produce output you're looking for.

in group properties select option break "between each instance of group."