Share
Reporti want to show the total item no in the item ledger entry table in a report.grouping is based on the item no
*This post is locked for comments
You’re offline. This is a read only version of the page.
1,745
i want to show the total item no in the item ledger entry table in a report.grouping is based on the item no
*This post is locked for comments
Hi,
if you want to use it in the report, you may use the "Item Ledger Entry" as the DataItem and on the report and add "Item No." and Description fields. Open the RDLC, add a table and add a group on the "Item No." and display the "Item No." and Description on the table and in the count column use the expression as =Count(Fields!No_itemLdger.Value)
Is the value coming in NAV, check by using message('%1', item.count) also check in the dataset of the report
no coming
In the report, do you have Item Ledger Entry DataItem, if then Add Item DataItem and indent the ILE under Item. in Navision there is a System function COUNT which will count the No of records, use Item.COUNT which will give you the result
ITEM NO | DESCRIPTION | TOTAL QUANTITY
1 | XXXXXXX | 4
i want to show in my report in this way
didnt get it ,rajasekhar sir
Hi
You can create a footer section and on the footer you can use the function to show the no of Items in RDLC
You can also return the count from Navision, Take Item as your parent Data item, under item indentation Take ILE, use the COUNT function in NAV on the Item DataItem
Regards
Rajasekhar.Y
i am using group by on item no but the problem is
if item no : 1 has four entry in the ILE then it is printing four line each showing no of item =4
Hi
Use the CountDistinct function in the RDLC, refer the below link on how to use countDistinct in RDLC
social.msdn.microsoft.com/.../group-count-in-rdlc
Best Regards
Rajasekhar.Y
Do you want to show how much quantity in the item ledger entry for each unique item no? If so you can create a report and group it for item No. or else you can create a query and then group it for item No.
Please be more specific on the question.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (