Print a Report

(0) Share

Report

Posted on by Community Member

I'm trying to setup an action button to print a label. I've created the button on the page actions, declared a variable with my report name and used this code under the action button

recBinContents.RESET;
recBinContents.SETRANGE("Item No.", "Item No.");
rptLewistest.SETTABLEVIEW(recBinContents);
rptLewistest.RUN;

However when I attempt to open the page which should allow me to preview the report nothing is loading?

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Suggested answer

Binesh 7,885 on at

Like (0)

Report

recBinContents.RESET;

recBinContents.SETCURRENTKEY("Item No.");

recBinContents.SETRANGE("Item No.", "Item No."); //Testing purpose filter one ITEMNo

IF recBinContents.FINDFIRST THEN BEGIN

rptLewistest.SETTABLEVIEW(recBinContents);

//rptLewistest.RUN;

rptLewistest.RUNMODAL; it carried the filters

END;

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Thankyou however when I click the button nothing appears to be happening.. As if the RUN function isn't working properly.

Was this reply helpful? Yes No
Andrea Antoniazzi 285 on at

Like (0)

Report

Hi Lewishhh,

try with recBinContents.SETFILTER("Item No.", "Item No.");

Best regards.

Was this reply helpful? Yes No
Suggested answer

Binesh 7,885 on at

Like (0)

Report

Debug that code and check it find records or not, if find then definitely report will run.

But also check report which you want to execute, report request page, and layout, first run from development environment/custom Report Layout

Note, Report must have recBinContents dataitem

See this image its tested.

Was this reply helpful? Yes No
Suggested answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report
Try running below code,

recBinContents.RESET; recBinContents.SETCURRENTKEY("Item No."); recBinContents.SETRANGE("Item No.", "Item No."); IF recBinContents.FINDFIRST THEN BEGIN
REPORT.RUNMODAL(RepNo,recBinContents); // add your report no
END;

If the code is not working then debug the code and you will be able to find the issue in it.

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

Hi,

Kindly debug and check whether you are getting the record to display for the report

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you, The reports button's working now, however when you select preview and enter the No of labels etc it get stuck, attempting to load thousands of rows.

Do you know what the potential cause for this is?

Was this reply helpful? Yes No
Suggested answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

Check on the dataset and filter it for only the necessary record. Plus try changing to RUN without RUNMODEL. When you have the RUNMODEL application wait till the report process over.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

H Thank you, I'm still very unsure what's casuing the report to not load.

Here is my Code on the Button to show the report..

recBinContents.RESET;

recBinContents.SETCURRENTKEY("Item No.");

recBinContents.SETRANGE("Item No.","Item No.");

IF recBinContents.FINDFIRST THEN BEGIN

rptLewistest.SETTABLEVIEW(recBinContents);

rptLewistest.RUN;

END;

here is the Datasets, Both Bin Contents and Item ledger are required.

Here's the properties for The Bin Contents Data Item, I think maybe the DataItemTableView is wrong?

Feedback is greatly appreciated! :)

Was this reply helpful? Yes No
Andrea Antoniazzi 285 on at

Like (0)

Report

Hi Lewishhh,

I think the report is processing all the Item Ledger Entries; this is the reason why you receive so much lines.

If you don't need the Item Ledger Entry DataItem, you have to remove it.

In the DataItemTableView remove WHERE(Item No.=CONST())

Best regards

Was this reply helpful? Yes No