topic Re: how to add a filter functionality in classical reports in Application Development and Automation Discussions

how to add a filter functionality in classical reports

Former Member — Thu, 17 May 2012 05:59:52 GMT

Hi, Experts

I had Developed a Classical Report, Now my Client want to Add the FILTER FUNCTIONALITY for the Report.

How to achieve it, is there any FM or class or Standard code for the filter functionality .

Thank you

Regards

Abhinav N

Re: how to add a filter functionality in classical reports

Former Member — Thu, 17 May 2012 06:04:24 GMT

HI, Why dont you use an ALV display?

If that's not possible, I guess you can add a button in the output and handle the code for filtering there.

I dont think there are any FM's you can use to acheive this.

Re: how to add a filter functionality in classical reports

Former Member — Thu, 17 May 2012 06:05:16 GMT

Hi,

Why use classical reports? I think you are working on the FI reports.

see this following link

http://www.insiderlearningnetwork.com/paulovigele/blog/2011/09/18/revamping_the_format_of_your_classical_reports

Karthik.R

Re: how to add a filter functionality in classical reports

Former Member — Thu, 17 May 2012 06:25:16 GMT

Thank you for your Reply

Actually i had made ME41 to ZME41 and in the CREATE RFQ: SELECTION LIST: PURCHASE REQUISITION report they need to have a FILTER FUNCTIONALITY , so i have added a Icon on tool bar, Now when i click on the icon(filter) i need the filter functionality.

Re: how to add a filter functionality in classical reports

Former Member — Thu, 17 May 2012 06:25:39 GMT

Thank you for your Reply

Re: how to add a filter functionality in classical reports

Former Member — Thu, 17 May 2012 06:40:52 GMT

I think u have to hardcode it

Re: how to add a filter functionality in classical reports

Former Member — Thu, 17 May 2012 07:03:33 GMT

Thank you.

Do you have any code that when i Click on Button a Pop Screen with select-options will appear.

Re: how to add a filter functionality in classical reports

Former Member — Thu, 17 May 2012 13:41:25 GMT

Hi Abhinav,

You can use the FM POPUP_GET_VALUES to create dynamic selection options on fields you want.

So after the filter call that FM and when the user enters filter criteria, refresh the report by restricting the output table entries as per user input.

Hope this will be helpful.

Regards,

Karthik D

Re: how to add a filter functionality in classical reports

Former Member — Mon, 21 May 2012 09:59:15 GMT

Thank you for the Reply Mr.Karthik Dharmarajan

Can you explain me in Detail

Regard's

Abhinav. N

Re: how to add a filter functionality in classical reports

Former Member — Mon, 21 May 2012 10:07:59 GMT

Hi Abhinav,

On pressing the Filter button you should call the POPUP_GET_VALUES function module with all the report fields.

After the user enters the value for filter you can then use the same to delete the unwanted records from the list output internal table and re write the classical report using the filtered record.

Try this and let me know if it works.

Regards,

Karthik D

Re: how to add a filter functionality in classical reports

Former Member — Tue, 22 May 2012 08:25:09 GMT

Thank you

I Need a little help, when i click on the button The FM is executing, In this Fm when I press F4 i need to get the Values of the Internal table, and when i select one value and execute , the internal table should be Modified, can you send a Logic for this , tried in many ways but can not.

Regards

Abhinav N

Re: how to add a filter functionality in classical reports

Former Member — Tue, 22 May 2012 08:35:46 GMT

Thank you

Regards

Abhinav N

Re: how to add a filter functionality in classical reports

Former Member — Tue, 22 May 2012 08:46:42 GMT

Hi Abhinav,

Since the F4 help and other events are handled by the Popup function itself we can't do much in restricting the F4 help values.

In that case you need to create your own function module/screen to get the filter values of the report fields.

Regards,

Karthik D

Re: how to add a filter functionality in classical reports

Former Member — Wed, 23 May 2012 08:43:53 GMT

Thank You

Can You send any Sample code for this

Regards

Abhinav N

Re: how to add a filter functionality in classical reports

Former Member — Wed, 23 May 2012 08:53:54 GMT

To modify the data see this thread

http://scn.sap.com/thread/977448