I have a general question for Crystal Reports 2008 for use with R/3.
Crystal Reports 2008 with SAP/R3 Enterprise 4.7
I installed a trial version of Crystal Reports 2008 and connected it to the R/3 instance using a oracle id which has admin rights so the session can see all of R/3 db including 000 client. It can see all tables within the database.
To deploy Crystal Reporting for an R/3 installation - is it advisable to connect directly to db? how do you maintain proper data element access? Do you create views for a oracle user id, or is there a delivered product or method for allowing user access using some other type of security that limits table access to say finance tables?