deltamc2000
ISP
Hi to all forum members 
I am very new to Crystal Enterprise 10 so please bare with me on this, I recently had a client that has asked us to do some reports in CR10 and they wanted a live web server to view the published reports over the net.
Fine I said, and off I went and set up CE10 on 2003 server and there database is MySQL. I am currently going though the admin guide and I am finding my way around ok I have managed to get out test reports working fine.
There is no need to build a new interface for them so thats all ok. As it stands at the moment certain users have access to particlar objects, folders or reports and I have been using CE Auth for this.
I have 2 problems working the theroy out for
What they will be looking for soon is the ability to.... you guessed it.... restrict data on the report depending on who has logged in. Im sure lots of you have done this already, I had just read a tip on here that suggested doing it at database level by creating views based on the user but as they are using MySQL 4.1 there is no way of creating list views so the reports are direct on the data.
The only way I can see to make this work is with the SDK and ASP, It's a case of creating user IDs in the MySQL database that relate to CE logins match them up and extra fields containing data that can be passed to the report through parameters to filter what they can and cant see.
Have I got this right? What is a tipical way of controling what users can view on a report?
If I did it on this way rather than building a custom screen that pulls out user ID from CE & the database, match them up and use field data passed to the report as a parameter to filter information out would Apos dynamic parameter benifit this operation?
I don't know a lot of ASP, I just wanted to check with you guys various methods of doing this.
Anyway, many thanks in advance
Reagrds
Paul Swainson
I am very new to Crystal Enterprise 10 so please bare with me on this, I recently had a client that has asked us to do some reports in CR10 and they wanted a live web server to view the published reports over the net.
Fine I said, and off I went and set up CE10 on 2003 server and there database is MySQL. I am currently going though the admin guide and I am finding my way around ok I have managed to get out test reports working fine.
There is no need to build a new interface for them so thats all ok. As it stands at the moment certain users have access to particlar objects, folders or reports and I have been using CE Auth for this.
I have 2 problems working the theroy out for
What they will be looking for soon is the ability to.... you guessed it.... restrict data on the report depending on who has logged in. Im sure lots of you have done this already, I had just read a tip on here that suggested doing it at database level by creating views based on the user but as they are using MySQL 4.1 there is no way of creating list views so the reports are direct on the data.
The only way I can see to make this work is with the SDK and ASP, It's a case of creating user IDs in the MySQL database that relate to CE logins match them up and extra fields containing data that can be passed to the report through parameters to filter what they can and cant see.
Have I got this right? What is a tipical way of controling what users can view on a report?
If I did it on this way rather than building a custom screen that pulls out user ID from CE & the database, match them up and use field data passed to the report as a parameter to filter information out would Apos dynamic parameter benifit this operation?
I don't know a lot of ASP, I just wanted to check with you guys various methods of doing this.
Anyway, many thanks in advance
Reagrds
Paul Swainson