GroupBy in DataItem

Business Central/NAV User Forum
1

Hi Everyone,

If I have GroupBy 2 fields in a DataItem (Eg: DataItem-Cust. Ledger Entry , GroupBy- Salesperson Code AND Customer

Code), in my section designer how can I inform system to show grouping of Salesperson on First Cust. Ledger Entry

GroupFooter and grouping of Customer on Second Cust. Ledger Entry GroupFooter

J.D.I

2

Use

CurrReport.SHOWOUTPUT :=

CurrReport.TOTALSCAUSEDBY = CustomerLedgerEntry.FIELDNO(“Sales Person Code”);

CurrReport.SHOWOUTPUT :=

CurrReport.TOTALSCAUSEDBY = CustomerLedgerEntry.FIELDNO(“Customer No.”);

3

Hi,

Download the GroupByTwoFields60015.fob file [report id-60015] and import in your application .See It could help you.

https://skydrive.live.com/?cid=83510f08fa66221b&sc=documents&id=83510F08FA66221B!111#

4

Hi Pandu,

Thanks but I am unable to view the design on the range given.

Can I request to export as txt please?

5

Hi Nikeman,

Did you import this GroupByTwoFields60015.fob object or not? ok this is the link now i have added the text object just download and import in NAVISION application.Report id is 60015.

https://skydrive.live.com/?cid=83510f08fa66221b&sc=documents&id=83510F08FA66221B!111#!/?cid=83510F08FA66221B&id=83510F08FA66221B!111&sc=documents

6

Hi Pandu,

Yup got the text file, thanks, we’ll take a look.

JDI