Crystal Reports 2008 connecting to R/3

[Former Member]

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?

John

[former_member11696]

Check our site for more info but in general CR fully respects all DB security, if the user does not have permissions on the table used in the report the report will fail to run.