We have some Web-accessible Crystal Reports that are filtered based on the name of the user currently logged in. The data is stored in an MS SQL server database. The user name is passed from a Domino server to the Crystal Web server (IIS) as a parameter in the calling URL.
We would like to pass the user name to the Crystal Web server in a more secure fashion and are looking at installing Domino on the Crystal server and running Crystal under Domino HTTP.
Will Crystal Reports 8.5+ run under Domino HTTP (DSAPI). I’ve seen documentation stating that it works under Domino 5, but see no mention of Domino 6 or 7. How about other versions of Crystal (9.0+).
Is there any way that Crystal can access the user name from the Domino session (using session-based authentication) as a parameter so that we can filter the data.
We do not want the user name to show up in the URL or to allow people to manipulate a URL to see data they are not supposed to be able to see.
Thanks
Steve