I am having a problem with a crystal report i have written that needs to have authorization based on company code. The crystal report is based on a bex query. the bex query authorization is working correctly. when choosing a company code that is allowed, the bex gives the correct information. when choosing a company that is not allowed, no data is returned.
The crystal is not working correctly. When choosing a company code that is allowed or not allowed, no detailed information is shown.
if we change the authorization to star (*), then all information is shown in the crystal report.
I have searched this site and also sap service marketplace, but i have not found a fix for this. so i am assuming i have either configured something incorrectly, or have just not done a step that is needed.
we use crystal 2008 fix pack 3.2.
any help would be appreciated.