Passing Values from Form to the Report

udaya726

I have created a report using Sales Header table and Item Ledger Entry Table. When I run the report I need to pass the values to the both records. though I am passing values for the both It takes only the first value that I pass

Pls give me a solution.

DaveT

Hi,

Declare the report as a variable and use the SETTABLEVIEW command for each dataitem

Belias

DaveT wrote:

Hi,

Declare the report as a variable and use the SETTABLEVIEW command for each dataitem

are you sure?how do you call the report?the syntax of rpt.runmodal allows only one record to be passed.
P.S.: if never tried to put multiple SETTABLEVIEW, so, maybe you're right

DaveT

Hi Belias,

Yes, it's no problem - here a quick example for Cronus with a report using Item & Item ledger Entry


item.SETFILTER( "No.", '1100' );
rep.SETTABLEVIEW( item );
ile.SETFILTER( "Posting Date", '06/09/08' );
rep.SETTABLEVIEW( ile );
rep.RUNMODAL;

Belias

DaveT wrote:

Hi Belias,

Yes, it's no problem - here a quick example for Cronus with a report using Item & Item ledger Entry


item.SETFILTER( "No.", '1100' );
rep.SETTABLEVIEW( item );
ile.SETFILTER( "Posting Date", '06/09/08' );
rep.SETTABLEVIEW( ile );
rep.RUNMODAL;

#-o yes, you're right! i completely forgot the syntax of rep.RUNMODAL! :oops:
OT: yesterday i was at a party and i got back home at 2.30 AM (half drunken), then i got up at 7.30 AM this morning, it will be an hard day...i think you can forgive me

DaveT

No problem - mind the head

udaya726

Thanks Dave
Got my work done

DaveT

Glad to Help