web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

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

(0) ShareShare
ReportReport
Posted on by
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
 

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at

    Przechwytywanie1.PNGDESIGN & AND PDF

    Przechwytywanie1.PNG

    If you need any additional info or screenshots please let me know ….

    Any ideas ?

  • Community Member Profile Picture
    on at

    any ideas guys ?:)

  • udaY-ch Profile Picture
    5,139 on at

    Ignore if tried already. if not, can you try setting the Page break property in the group properties. You will have a property called Page break between each instance of a group.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans