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 NAV (Archived)

Report Transfooter RDL

(0) ShareShare
ReportReport
Posted on by 147

Hi all,

I try to develop a transfooter in report but i have a problem concept and not works.

REPORT FUNCTIONALITY

First of all this Report show a list of bank movements:

  • For each bank show a totalized in the body
  • One bank can take more than one page. Here need Transfooter
  • The report can run with only one bank or N banks,
  • its a personalized report in 5xxxx numeration.

DEVELOP REPORT STRUCTURE

The structure of Report is the next:

I create two fields in the footer of report with a visibility rule:

IMG-1.png 

CODE IN REPORT

In the report Code i have this functions to set/get value of visibility variable

Shared public auxFlag as Integer
Public Function SetFlagTrue(ByVal Value As Decimal) As Boolean
  auxFlag = 1
  Return true
End Function

Public Function SetFlagFalse(ByVal Value As Decimal) As Boolean
  auxFlag = 0
  Return true
End Function

Public Function GetFlag() As Integer
  Return auxFlag
End Function

LAYOUT 

In the Layout, in the row of detail group i call the function SetFlagTrue, when executes the row of totals i call the function SetFlagFalse. This way when the reports is printing detalis rows, the footer show the 2 fields and when is execute the of totals row of the body the fields of footer not show.

IMG-2.png

PROBLEM

The problem is:

The Report works fine whit one bank, but if the report print multiple banks then the visibility condition fail...

Anotation: If execute the Report with pageBreak between banks works perfect... 

I tried to place the call funcionts in diferent rows but not works...

For see the value of the visibility variable i add in the fields a call to getAuxFlag to can see the value and this is te result:

TRY TO DEBUG RESULT LAYOUT

img3.png

RESULT OF EXECUTION 

IMG4.png

img5.png

Maybe i dont stand the workflow of execution and store variable of the reports but i think this develop is similar to the famouse functionality of GetData and SetData.

I tried to be explicit... sorry is so confus...

Thanks for any reply.

Regards

*This post is locked for comments

I have the same question (0)
  • CristianAguerre Profile Picture
    147 on at

    Anywone can help?

  • Rajasekhar@MS Profile Picture
    5,569 on at

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 NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans