Upgrading a Report to 2013 with Groupfooter + TotalCausedBy

Lilithyan

Hi all,

I have a problem with Upgrading a Report from a Customer from a 4.01 Version to 2013 with absolutely no clue to solve it. Anything I found in other topics in the forum with a similar problem didn't have a posting with a solution in it.

Okay, the problem:

At first glance the Report in the old Version looks very easy. There is only the DataItem Item. There is a normal Header and a normal Footer. And between that there are three GroupFooter, nothing else!

And each of these three has in the OnPreSection one codeline, where the Currreport.Showoutput is defined by a Currrreport.TotalCausedBy.

So I have three codelines, one per Section Trigger in which it states:

CurrReport.SHOWOUTPUT(CurrReport.TOTALSCAUSEDBY = Item.FIELDNO(X));
or
CurrReport.SHOWOUTPUT(CurrReport.TOTALSCAUSEDBY = Item.FIELDNO(Y));
or
CurrReport.SHOWOUTPUT(CurrReport.TOTALSCAUSEDBY = Item.FIELDNO(Z));

with X, Y, Z each being a different field from Item.

How do I upgrade that into 2013?!?!? I haven't even a clue from where to start! Any help would be greatly appreciated.

Ciao,

Lily

StLi

the RDLC interpreter works very differently to the classic rendering algorythm. The only data the interpreter can use is the one sent to it in the recordset. And this recordset isn't affected by any code executed from the sections (first reason: you don't have them anymore in 2013 second: it didn't get executed in 2009 eighter)

I'd recomend to read some basic tutorials on building RDLC-Reports for navision because this needs a multi-page explainations with lots of examples.

After that, you will need to analyse the recordset that gets send to the interpreter (found in the "about this page"-Infobox once you opened the report in preview... you'll have to open the infobox once on the request page and then in the preview again.) and you will definatly need some Grouping. Depending on the source report, you'll eighter have to do the summerizing manually in the Dev-Env-Side of the report and or you can rely on some implemented functions like SUM or LAST or a combination of both methods.

Jatin_Patel

Use grouping on each three field in RDLC design.