Crystal Enterprise user interface 1

SPGMR39 · Jul 12, 2004

Hello! I have been creating Crystal Reports and migrating them up to Crystal Enterprise for several months now.
My supervisor has asked me to try to find a "better way" of presenting the report selection to the user.
Particularly, when is desired to be run, could it just be run without going through this interface?
If necessary, could it automatically prompt the user for any parameters required without having to use the 'canned' interface provided by Crystal Enterprise?

rhinok · Jul 12, 2004

The easiest way to do this is to create hyperlinks to your reports from an intranet site. In order to make this as seamless as possible, it would help if you set up SSO (Single Sign On) so that the user isn't prompted for a logon ID. Also, it would help if you know some javascript.

The goal is to create a hyperlink that points to a js file. The JS file, in turn, launches the report while hiding the actual file path and url.

Using this method, all the end user has to do is click a link and enter parameters. The viewer you use can be embedded into the link. I personally prefer the ActiveX viewer because I like the prompt method better than the Enhanced DHTML.

I'll see if I can dig up an example I've done and paste it...

~Kurt

rhinok · Jul 13, 2004

Here's a tiny web page sample. This webpage will display links to CE-maged Crystal Reports that you can view on demand simply by clicking the link. The code does assume Windows SSO, btw. Save the following code as an .htm document, substituting your APS/CMS name and report id. The report id can be found by looking at the properties page for a report in the CMC (frs://Input/a_030/001/000/286/9e0375298b1820.rpt). Also, depending on your version of CE, you may need to modify the path (mine shows 'enterprise9', for example).

Code:

<html>
  <head>
    <title>Sample Crystal Enterprise Links page...</title>
  </head>
  <body>
      <p>Please select a report from the following list:</p>
        <ul>
          <li>
	    <a href="#" onClick="hidden=open('[URL unfurl="true"]http://servername/crystal/enterprise9/viewrpt.cwr?id=286&apsauthtype=secWindowsNT&init=actx','NewWindow','status=no,resizable=yes,scrollbars=no,location=no');">Sample[/URL] Crystal Enterprise Linked Report</a>
	  </li>
        </ul>
  </body>
</html>

Keep in mind, that this means the reports will be run on demand. If you just want to allow users to view the latest instance of a scheduled report, there are .csp samples available from Business Objects. You could have the link point to the .csp, which would cause the latest instance to be returned.

Also, there are .csp code samples for 'schedule now', which would bring back the results immediately (like View On Demand), but would use the Job Server Vs. the Page Server.

~Kurt

rana5 · Jun 6, 2005

I am trying to add an SF command to the code sample listed above but I don't know how to imbed the single quotes for:

SF={studio.studio}='UNIVERSAL'

Please help me with the syntax!

Thanks!

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Crystal Enterprise user interface 1

SPGMR39

Programmer

rhinok

Technical User

rhinok

Technical User

rana5

IS-IT--Management

Similar threads

Part and Inventory Search

Sponsor