Print a Report

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (11)

Answers (1)

Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Print a Report

thank you i've done some moving about and managed to get a working report. I'm now trying to add the Item Ledger dataset so I can populate the LotNo and other things onto my report. If it's relating to the item page what would my DataTableView be and my Dataitemlink?
Andrea Antoniazzi 285 on at

Like (0)

Report

RE: Print a 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
Community Member Microsoft Employee on at

Like (0)

Report

RE: Print a 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! :)
Suggested answer

TharangaC 23,116 on at

Like (0)

Report

RE: Print a 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.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Print a 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?
Suggested answer

Amol Salvi 18,694 on at

Like (0)

Report

RE: Print a Report

Hi,

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

TharangaC 23,116 on at

Like (0)

Report
RE: Print a 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.
Suggested answer

Binesh 7,885 on at

Like (0)

Report

RE: Print a 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.
Andrea Antoniazzi 285 on at

Like (0)

Report

RE: Print a Report

Hi Lewishhh,

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

Best regards.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Print a Report

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