Crosstab
Hedley
Peru
good morning
i prepare a crosstab report but i need to make a breakpage on a row group
ejm
room 1 07.00
room 1 08.00
room 1 09.00
room 2 07.00
room 2 08.00
room 2 09.00
i nee to insert a breakpage between room1 and room 2
room 1 07.00
room 1 08.00
room 1 09.00
(new page)
room 2 07.00
room 2 08.00
room 2 09.00
tks a lot
Hedley
PD. i attach a report example that i need to change
i prepare a crosstab report but i need to make a breakpage on a row group
ejm
room 1 07.00
room 1 08.00
room 1 09.00
room 2 07.00
room 2 08.00
room 2 09.00
i nee to insert a breakpage between room1 and room 2
room 1 07.00
room 1 08.00
room 1 09.00
(new page)
room 2 07.00
room 2 08.00
room 2 09.00
tks a lot
Hedley
PD. i attach a report example that i need to change
Comments
1. Make a simple query and a masterband for it. The query should give single row with room ID.
2. Force new page for this masterband.
3. Put a smaller Crosstab on each masterband for each room.
Mick
Hi Mick...
i dont know how many rooms will be on report...
Hedley
Hedley,
The number of rooms is not important. Query (DataSet) should give you one row (MasterData band) for each room. So MasterData band will work for you changing the page when needed. And your CrossTab that you put on MasterData band should be attachedd for the single room. When query changes row from database then you'll receive new MasterData band and you will have new page automatically.
And your wish was to have new page for each room from database.
But - can you use a DataSet (query) to get all of your rooms ?
Mick
Hi Mick... thanks a lot
with your guide ... i do a master detail report and it works fine, and in detail band put the crosstab
thanks again
Hedley