SetData() — GetData() on SSRS Reporting on Dynamics NAV

I was wondering why would someone ever use SetData() and GetData() functions on a report until I was asked upon a very specific requirement.

SetData() GetData ()— Round 2.0

This is a follow-up post to the original post about SSRS setting-getting data, since when I inquired the Dynamics NAV forums, and I received answers where I am no longer required to use SetData() — GerData().
I mean this is impressive stuff!

Concatenation of strings to use as filters in Dynamics NAV Reporting

I have been trying to get all the Item no. in the RFQ Lines (Request For Quotes Lines) as in one string concatenating all with a pipeline(‘|’).

Sales Invoicing — Posting/Archiving/Deleting on Microsoft Dynamics NAV

There was a requirement to archive the Sales Order document when it is completely invoiced and before the deletion.

Concatenation of strings — Round 2

This post is the continuation of the previous post of mine on the same topic.
In the last post, I was discussing a requirement which is very specific. 
When I shared the post with my colleagues, they want to rework it towards a generic requirement. Feel free to check…

User-wise filtering in any Master Tables on Dynamics NAV.

The latest requirement happens to be to show only the Bank Account which is relevant to one user. So this is not quite tough, to be honest, but we want to generalize this concept across all the master tables / list pages. So this…

Divide by Zero — NAV Reports.

I was trying to find the error, Divide by Zero when writing expressions on Microsoft Dynamics NAV Report Data Source, so I break the test into three scenarios.

Scenario 1

Bubble sort in C/AL

Sorting.. Yes, I could have used Record.SETCURRENTKEY() if I am retrieving values from a table. But I had to sort some decimal/integer variables which I used while running a report.
I was thinking what if I use one of the old school sorting algorithms, and then I decided to implement Bubble…

COMPRESSARRAY() on Customized Dynamics NAV Reports

When it comes to customized reports, header information always contains the Company Information. Adding fields to report layout is a pretty repetitive task, time-consuming too.