I need to develop reports based on SAP trasperant tables and to filter the records I require to use one of the function module in SAP.
I have created parameters in Crystal reports that are required for the function to execute and are included in the where clause of the query. This helped the fuction to get those parameters and execute it.
The thing is that the fuction works fine with one set of parameters and gives accurate results both in SAP and Crystal Reports.
But fails for other set of parameters.
It works fine when we directly execute function in SAP produces a record set. But, when we pass those parameters from Crystal Reports it fetches no data.
Can anybody tell me the exact procedure to use function module and transperent tables together in Crystal Reports ?
Thanks in Advance.