Get the filtered records in a record variable in reports

shibily

Hi All,

How do i pass the filtered records to a record variable in reports.

I am using Sales Invoice line table in a report and it is used for filtering purpose before taking the report. I am using a record variable of Sales Invoice Line ie recSalesInvLine.

Whatever filterations i have made , i have to transfer it in the record variable. for ex if i have given the filterations for date and "sell to customer No" before taking the report , recSalesInvLine also should also be filtered with date and "sell to customer No" .

I tried by using the code recSalesInvLine : = "Sales Invoice line" . in the Sales Invoice Line, Header section, But i am getting all the records . Filteration is not taking place.

Can anybody help me to solve this issue.

Thanks in advance

Belias

COPYFILTERS function, search it in online help (F1)
and...don't use this in onaftergetrecord...use it after you have put all necessary filters to your variable

matttrax

Look at how printing an invoice works - PrintRecords function in Table 112.

Basically you have to copy your record variable into another variable and pass that variable to the report.

mohana_cse06

shibily wrote:

Hi All,

How do i pass the filtered records to a record variable in reports.

I am using Sales Invoice line table in a report and it is used for filtering purpose before taking the report. I am using a record variable of Sales Invoice Line ie recSalesInvLine.

Whatever filterations i have made , i have to transfer it in the record variable. for ex if i have given the filterations for date and "sell to customer No" before taking the report , recSalesInvLine also should also be filtered with date and "sell to customer No" .

I tried by using the code recSalesInvLine : = "Sales Invoice line" . in the Sales Invoice Line, Header section, But i am getting all the records . Filteration is not taking place.

Can anybody help me to solve this issue.

Thanks in advance

its working fine?
which version u r using?
in which section trigger did you write code?

shibily

Yes it is working now. I have written in OnPreSection

Regards

mohana_cse06

shibily wrote:

Yes it is working now. I have written in OnPreSection

Regards

y did u get problem before?

Belias

He was assigning the variable instead of using COPYFILTERS, assignment does not copy the filters, but only the values...

mohana_cse06

Belias wrote:

He was assigning the variable instead of using COPYFILTERS, assignment does not copy the filters, but only the values...

the values will assigning after applying filter.

Belias

mohana_cse06 wrote:

Belias wrote:

He was assigning the variable instead of using COPYFILTERS, assignment does not copy the filters, but only the values...

the values will assigning after applying filter.

sorry, don't understand you :-k

mohana_cse06

Belias wrote:

mohana_cse06 wrote:

Belias wrote:

He was assigning the variable instead of using COPYFILTERS, assignment does not copy the filters, but only the values...

the values will assigning after applying filter.

sorry, don't understand you :-k

he was assigning the variable means values

the values are assigning after applying filter

navuser1

Hi Shib,

Try this..


And use these two variables to filter the record recSalesInvLine .


Regards!

shibily

Hi all.
My problem is solved by using the Copyfilter option.