Dynamics Community Forum Thread Details

Report Transfooter RDL

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:

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.

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

RESULT OF EXECUTION

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

Quick Links

Leaderboard