Alfasith AX

Alfasith AX
اللَّهُمَّ انْفَعْنِي بِمَا عَلَّمْتَنِي، وَعَلِّمْنِي مَا يَنْفَعُنِي، وَزِدْنِي عِلْمًا

Thursday, December 27, 2018

Make a group by in SSRS

Hi,

Sample, here I have Amount values that is sum(Amount) all the sales Order, but I need the group by Sales Id.

below expresion works for me when I add this filed group by in that particular tablix.

=Sum(CDbl(Fields!Amount.Value))

Regards,

Thursday, November 29, 2018

How to achieve alerts for child tables in D365

Hi,

Microsoft D365 doesn't support alert handling for child tables when there is a parent table in a form.

We can do a work around to handle this by using the sysTableBrowser URL for the particular table which is not listed in any form.


Regards,

Get a table ID in SQL - D365

Hi select ID from SysTableIdView where  SysTableIdView .Name = 'CustTable' Regards,