Dynamics Community Forum Thread Details

SSRS report ax 2012 export to PDF- break page doesn't work properly in some cases

Dear AX Users,

Could you please help me in the following issue with report design.
Issue is related to export to pdf or to printer , in some cases break-page doesnt work. When we launch the report to the screen , everything is ok.
The thing is, that on every page we use grouping by for exemple PRODUCT TYPE, on each page records with only given Type should be displayed.
for exemple:
page 1
TYPE A
record 1 , type A field pagebreak in temp table= NO
record 2 , type A field pagebreak in temp table= NO
record 3 , type A field pagebreak in temp table= NO
record 4 , type A field pagebreak in temp table= NO
PAGE BREAK NOW ->
page 2
record 5, TYPE B field pagebreak in temp table= YES
record 6, TYPE B field pagebreak in temp table= NO
record 7, TYPE B field pagebreak in temp table= NO
record 8, TYPE B field pagebreak in temp table= NO
record 9, TYPE B field pagebreak in temp table= NO
...
page 3
record X, TYPE C , field pagebreak in temp table= YES
…… etc

When we launch the report on the screen, everything is perfect, but when we export it to PDF , or printer , sometimes we have sth like this:

page 1
record 1, type A -> OK

page 2
record 1, type B -> OK
…...
record 11, type which exceeds 1 page in pdf and record 12, 13 go to third page -> OK ( but normally when we have only few records per each page - its working fine, but i was also to find the case when i had 14 record of TYPE B on second and third page -> and it was also okay …. i had break page before first record of TYPE C, im so confused)

page 3
record 12 , type B -> OK
record 13, type B -> OK
AND NOW record 14, type C -> No page-break ! !Problem!
record 15 , type C
etc …..

Do You have any ideas how to fix this ?

PageBreak in table1_details_group is defined as BETWEEN and DISABLED AS:

=iif(Fields!BreakPage.Value = "Yes" ,false, true)

Field PAgeBreak is located in temp table, it's as YES when we encounter next value of enum TYPE in our grouped data

I reallly appreciate your help !

Thanks

Categories:

Reporting and BI

Quick Links

Leaderboard