Reportnet: using calculations from FM within a filter in report studio

[roberda]

Hi all,

There are lots of limitations of reportnet 1.1 MR2 with SAP BW datasources, for example you CANNOT use filtering statements on a BW datasource on business date/time functions: current_date, _first_of_month, _last_of_month etc...

still I need to filter my BW queries as following: 0CALDAY between 2005-05-01 and 2005-05-31.

I had the idea to create a calculation under framework manager that generate dynamically first_of_month and last_of_month from an oracle table.

When I test the results of these calcultions under report studio , the result is ok, but now if I want to include these calculation items in the filters of my datasource query...it does not work.

So first, can we use calculation results in a query filter? if so how?
if not, has anyone any clue how to pass this 'date/time' filter to a BW datasource from reportstudio.

thanks

David