RDLC Report Multiple data items + List & Table Data regions

LenishaniLenishani Member Posts: 7
edited 2012-11-07 in NAV Three Tier
Hello,
I am having an issue with an existing custom sales discount Navision 6.1 report which I need to re-design in 2013.

The report is made up of the following data items as attached (DataItem.jpg)

Data item Value Entry is linked to Item with : Item No.=FIELD(No.)

I added a List data region in RDLC , then a table data region Table A showing the value entry details of sales/discount Amts for each salesperson (using the first 3 data items) with proper groupings and all.
And then, I added a 2nd table data region Table B (Using data from the last data item Salesperson/Purchaser 2) showing a summary of Total Sales Amt/Discount Amt for each Salesperson

Issue:
In the List data region :
Table A is showing correct data.
Table B is showing blank rows first (which i guess is the value entry rows of the dataset) and then it is showing the proper rows for salesperson summary after the blank rows.

Any idea of what I may have wrongly done?

I hope my explanation is not confusing.
Sign In or Register to comment.