GETFILTERS on Request form.

upasanisandip · 2006-11-01

How can I use GETFILTERS on second tab of Request form.

I can use for first tab. But for Second tab not showing correct result.?

Anyone have idea about this?

Thanks & regards,
Sandip.

Albertvh · 2006-11-01

Hi Sandip,

If the second tab filter fields are global variables that should apply to your
dataitems then in the OnPreReport you could set them to your dataitem

OnPreReport()
Item.SETRANGE(Field6,Global1);

Here Global1 is a variable that needs to be set on the second tab

Hope this helps
Reagrds
Albert

upasanisandip · 2006-11-01

To Show Filter string on report DataItem.GETFILTERS is working for Fist Tab but not For Second Tab.

How to print the Filter string on report for all tabs (data item).
My Data items are like following.
Vendor
->G/L Entry
--> G/L Account

On G/L Entry data items ReqFilterField is Posting Date, I want to show this filtered date on Report.

Filter string to be printed on the report header as below
Filter by :- Vendor Name, Posting date

Albertvh · 2006-11-01

Hi Sandip,

You will have to do the following

OnPreReport

FilterText := 'Filter: ' + "G/L Account".GETFILTERS + ', ' + "G/L Entry".GETFILTERS;

Where FilterText is a Global variable of type Text

Regards
Albert

David_Cox · 2006-11-01

upasanisandip wrote:

To Show Filter string on report DataItem.GETFILTERS is working for Fist Tab but not For Second Tab.

How to print the Filter string on report for all tabs (data item).
My Data items are like following.
Vendor
->G/L Entry
--> G/L Account

On G/L Entry data items ReqFilterField is Posting Date, I want to show this filtered date on Report.

Filter string to be printed on the report header as below
Filter by :- Vendor Name, Posting date

Hi your post is not very clear :-s

Is it is just the one filter you want, as the other reply use the Section:
OnPreReport()
IF "G/L Entry".GETFILTER("Posting Date") <> '' THEN
DateFilterText := 'For the Period ' + "G/L Entry".GETFILTER("Posting Date");

upasanisandip · 2006-11-01

Thanks David & Albertvh.
The solution sent by you has worked.

kine · 2006-11-02

Yes, as you can see, the filters of second dataitem are not accessible in OnPreDataitem Trigger of first dataitem. You can access the dataitem filters just in own triggers or in OnPreReport where you can see all filters of all dataitems... :-)

GETFILTERS on Request form.

Answers

Categories