How to send parameter from pages to reports?

julkifli33

hi all...i'm using nav 2009
i have created another sales invoice report (Report 50001)
the report is completely done
but from sales invoice list pages i want to send parameter document no
so it will preview the report with the document no I sent from sales invoice pages
how to do it?
i can preview report only using runobject
but it can't sent the parameter

mohana_cse06

If you want it to be replaced by base report, go to report selection table and change the report id for which you want..

julkifli33

mohana_cse06 wrote:

If you want it to be replaced by base report, go to report selection table and change the report id for which you want..

unfortunately not
i create another report for unposted sales invoices
so i must create parameter

mohana_cse06

from where do you call that report?

julkifli33

Pages 9301 Sales Invoice List
i create another new action to pull this report

mohana_cse06

write in OnAction

REPORT.RUN(50001,TRUE, FALSE,Rec);

julkifli33

mohana_cse06 wrote:

write in OnAction

REPORT.RUN(50001,TRUE, FALSE,Rec);

if delete the RunObject
so the button in my page is also gone...

is it using RUN or RUNMODAL?

julkifli33

sorry... the button is already there
but still not sending the parameter

mohana_cse06

what did u do exactly? can you explain?

what is the first dataitem in report 50001?

julkifli33

mohana_cse06 wrote:

what did u do exactly? can you explain?

what is the first dataitem in report 50001?

i modified from report 205
and then i update the filter
from order become invoice

still not send the parameter using your code

mohana_cse06

julkifli33 wrote:

i modified from report 205
and then i update the filter
from order become invoice

sorry..i didnt get what you have done..

in order to run the report50001 from Sales Invoice list..
1. add an action print in Page 9301-Sales Invoice List
2. In OnAction trigger of above added Action write

REPORT.RUN(50001,TRUE, FALSE,Rec);

julkifli33

Mohana
your code below

REPORT.RUN(50001,TRUE, FALSE,Rec);

yes ... it can execute report no 50001
but it didn't give parameter at all
so the report we pull from your code still

No. = < blank >
Sell-to Customer No. = < blank >
No. Printed = < blank >

what i want is... if we select invoice no 001,then become

No. = 001
Sell-to Customer No. = < blank >
No. Printed = < blank >

mohana_cse06

Use

CurrPage.SETSELECTIONFILTER(Rec);
REPORT.RUN(50001,TRUE, FALSE,Rec);

julkifli33

mohana_cse06 wrote:

Use

CurrPage.SETSELECTIONFILTER(Rec);
REPORT.RUN(50001,TRUE, FALSE,Rec);

Yes Mohana...
this is what i want
many thanks
:thumbsup:

julkifli33

the code is already correct to reports
but....
for example i have 10 invoices
1001....1010

if i choose from the list 1005
and the preview the report
after that i go back to sales invoice list
it only appear only 1005
the others are disappear... until i go to another page...and then come back again to sales invoice list
how to refresh it automatically?

mohana_cse06

It is setting filter on No = 1005,
you have clear the filters from Action-->Clear Filters

julkifli33

thanks mohana
but how to set the parameter for each report

CurrPage.SETSELECTIONFILTER(Rec);
REPORT.RUN(50001,TRUE, FALSE,Rec);

like this...
is it can be used for every report?
i have the same question
but now for payment journal page to pull from my another customized report

mohana_cse06

Yes, you can use
just change the report no

julkifli33

mohana_cse06 wrote:

Yes, you can use
just change the report no

ok thanks a lot Mohana
:thumbsup:

julkifli33

mohana_cse06 wrote:

It is setting filter on No = 1005,
you have clear the filters from Action-->Clear Filters

hi ....
i still cannot find how to clear the filters

mohana_cse06

You have to manually clear the filters from Actions

julkifli33

mohana_cse06 wrote:

You have to manually clear the filters from Actions

you mean by C/AL or setting from properties?

Tommy_Schou

Create an internal variable pointing to salesheader.

SalesInvHeader - Record - 112

Now change code to:

CurrPage.SETSELECTIONFILTER(SalesInvHeader);
REPORT.RUN(50001,TRUE, FALSE,SalesInvHeader);

That should do the trick as you will no longer be manipulating the filter on the record of the page.

julkifli33

thanks Tommy
it really works