SBX - Search With Button

SBX - Forum Post Title

Query in Report in AL

Dynamics 365 Business Central Forum

Nick Webb asked a question on 14 Jun 2019 4:28 AM

Question Status

Suggested Answer

How can I assign a query object in the dataset / dataitem section of a report object in AL?

Reply
Krzysztof Bialowas responded on 17 Jun 2019 8:36 AM
My Badges
Suggested Answer

As far as I know you cannot do it directly. But if you need you can use Integer table and then assign values to the variables or you can put values to temporary table and show it.

Reply
Nick Webb responded on 17 Jun 2019 9:17 AM

So what is the point of a Query object if you can't assign it to a Report object?

Reply
Krzysztof Bialowas responded on 17 Jun 2019 9:22 AM
My Badges

It is used for calculation and for combining data if needed. But not for the presentation of the data. For that you need to do some "workarounds". We use a lot of queries but there where we need to have some dataset which are later used in code.

Reply
Krzysztof Bialowas responded on 17 Jun 2019 8:36 AM
My Badges
Suggested Answer

As far as I know you cannot do it directly. But if you need you can use Integer table and then assign values to the variables or you can put values to temporary table and show it.

Reply

SBX - Two Col Forum

SBX - Migrated JS