Small and medium business | Business Central, N...

Using a Query for Report with Temp Table

(0) Share

Report

Posted on by Samantha73

3,247

Hi All

I'm trying to generate a report that reads from a temporary table. However, the temporary table should be populated from a Query when a user runs the report. So far no data pulls through (empty error).

I have used pattern from Dynamics 365 Business Central: Using the query as a data source for a page (Query.Open Method) | Dynamics 365 Lab (yzhums.com)

So far this is my code and I have tried triggers predataItem and onaftergetrecord:

            column(Lot; Lot) { }
            column(Serial; Serial) { }

            trigger OnPreDataItem()
            var
                LotByBinTemp: Record LotByBinTemp;
                LotByBinQuery: Query LotNumbersbyBin;
            begin
                LotByBinTemp.DeleteAll();
                if LotByBinQuery.Open() then begin
                    while LotByBinQuery.Read() do begin
                        LotByBinTemp.Init();
                        LotByBinTemp.RowNo := LotByBinTemp.RowNo   1;
                        LotByBinTemp.Location := LotByBinQuery.Location_Code;
                        LotByBinTemp.ItemNo := LotByBinQuery.Item_No;
                        LotByBinTemp.Lot := LotByBinQuery.Lot_No;
                        LotByBinTemp.Serial := LotByBinQuery.Serial_No;
                        LotByBinTemp.Insert();
                    end;
                    LotByBinQuery.Close();
                end;
            End;

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

I wonder if you are filling your temp table too early in the process?

What is the dataitem for your report?

Maybe you can share more of the code?

Was this reply helpful? Yes No
M Saravanan 244 on at

Like (0)

Report

Dear Samantha,

Have you succeded in meeting out the above requirement..? If so, please share the ways to achieve it..

Thanks in advance,

Saravanan M

Was this reply helpful? Yes No
Suggested answer

Steven Renders 5,672 Moderator on at

Like (0)

Report

Here's an example:

How Do I: Create a Report based upon a Query? – think about IT

blog/ReportBasedOnQuery at master · srenders/blog · GitHub

Was this reply helpful? Yes No
Greg Kujawa 583 on at

Like (0)

Report

I too was running into the same exact issue after following the instructions listed in that very helpful article you cited. I used the Page Inspector and could see the temp table rows were there. But the page itself was just blank. The issue for me was I forgot to include ApplicationArea = All for each field on the page. Easy fix. :)

And one other thing. Per that helpful article, the temp table needs to be populated in the OnOpenPage() trigger.

Was this reply helpful? Yes No