How do I set a password on a report?

[ston]

I'd like to set a password on a report so that only I can make modifications to the report. Is this possible in CR8.5?

Thanks.

 

[AndrewBaines]

No.
In Crystal Enterprise your report would be secure as only authorised people could open it.
Seagate Info had a method of securing reports but it wasn't very secure. Andrew Baines
Chase International

http://www.chase-international.com

 

[dgillz]

If you want to be the only one to modify a report, do not give the users access to the crystal report designer, just give them the executable so they can run whatever you have coded.

Let me know if you have any questions.
Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[ibearian]

is your report on a web sever?

if it is you just need a bit of VB script which i can give if you are interested ????

the web server side is dead easy, i used to mess around with distributed reports, nasty things. but then i set aside 1 day to play with the crystal web viewer and it took me 1/2 a hour with a copy of front page200. (i had had no experiance with that either!)

go on have a go

 

[AndrewBaines]

Something I'm looking at, but haven't tried yet, is to stream a report object to a database. This stores it as an object, not as a file so it can't be modified.
Then at view time, stream it back in as an Object.
I've no idea if it will work but it should be interesting to try. Andrew Baines
Chase International

http://www.chase-international.com

 

[ibearian]

andrew

you would store it as an Obect in a database, almost like a respoitory ?

What sort of object would you save it as ?

you would'nt be able to modify it either would you ?

 

[ston]

Ibearian,

My report isn't on a web server. I haven't played around with it but I'll be happy to look at your vbscript.

I'm pretty new to Crystal also.

Thanks.

 

[AndrewBaines]

You use streams - it's stored in a BLOB of some sort - like I said, I'm only thinking it through at the moment.
You could stream it to a text file if you wanted to.
I've done this in Java - very easy, I just need to work out how much you can do with streams with COM. Andrew Baines
Chase International

http://www.chase-international.com

 

[ibearian]

please find enclosed a page of HTML and a bit of VBSCRIPT. it is not fool proof and any hacker could get to tyour files but for the rank and file user its fine

Setting up the web services is dead easy. On your web server (mine a compaq piii 500mhz 256mgram proliant, running NT4 and IIS with the latest service packs). Install the (at least) the crystal web servers and if you can the report program to as this will ease any trouble shooting problem. set up in IIS a folder called say 'FOLDER' then in it paste a static (at first keep it simple) report called say 'REPORT'.

look at the permissions on IIS and Internet explorer (which i use, but it works with netscape and opera with the java stuff)You may need a grown up to help and avoid compromising security. If their is one availble then have a go anyway it is easy but ..... be warned you can make the server very volnerable ( so i use an internal server with only access to our intranet)

On IE you need to enable/prompt the activex download facilities and IIS the ip access and challenge repsonce etc etc....you'll see.

then from your browers type //myserver/FOLDER/REPORT.rtp then it should start to downlaod the viewer, takes 3-5 minutes or if the viewer is installed it'll just fire up. Trouble shooting with static reports should be down to IIS or IE (those are the only problems i have found) dynamic reports are just as easy to get working but when you refresh (ie a dynamic report) you open a whole new can of trouble. Once they are working however they are dead reilable and if you want to change or update a report you simple alter the web report once.

What i do is the database part of a program in VB then via a hyperlink link to the webserver for the reports. When someone wants a new report or i update one i just add/save it to the web page. i don't have to re compile and distribute and re install with ODBC's dsn's etc it just so easy on the web !!!

<HTML>
<HEAD><TITLE>Simple Validation</TITLE>
<SCRIPT LANGUAGE=&quot;VBScript&quot;>
<!--
Sub Button1_OnClick
Dim Input
Input = InputBox(&quot;please enter password&quot
if Input =&quot;PASSWORD&quot; then
navigate &quot;

http://your

servers name/Folder/report.rpt&quot;
else MsgBox (&quot;incorrect password&quot
end if
End Sub
-->

</SCRIPT>
<BODY>
<H3 align=&quot;center&quot;><font size=&quot;7&quot; face=&quot;Arial Black&quot; color=&quot;#FF0000&quot;>SECURITY
CHECK&nbsp;<br>
</font><font face=&quot;Arial Black&quot; color=&quot;#FF0000&quot; size=&quot;6&quot;>ACCOUNTS</font></H3>
<p align=&quot;center&quot;>&nbsp;</p>
<p align=&quot;center&quot;>This area will require a password. If you clicked here in
error please press HOME on the right. Otherwise press the enter password button.</p><HR>
<FORM NAME=&quot;ValidForm&quot;>
&nbsp;
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;
<INPUT NAME=&quot;Button1&quot; TYPE=&quot;BUTTON&quot; VALUE=&quot;Press Here To Enter Password&quot;>
</p>
</FORM>

</BODY>
</HTML>



have a go you'll not regfret it and it will save so much time !!!!!!!