Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2005
    Posts
    29

    Unanswered: Help required in Oracle Web server.

    Currently we use Oracle web servers (HTP and HTF packages) to display reports.

    Is there any way graphs (Line graphs etc) can be developed/displayed in the web tool kit?

    Any suggestions are welcome.

    Thanks.

  2. #2
    Join Date
    Dec 2003
    Location
    Oklahoma, USA
    Posts
    354
    We use a java package called NetCharts and call it out during the page creation using the HTF/HTP packages. The parameters are supplied to the Java package using regular PL/SQL. An example:

    Code:
    htp.print('<applet name=Daily Stats '||
                'code=netcharts4.apps.NFBarchartApp '||
          	    'codebase=/Netcharts/classes '||
          	    'archive=netcharts4.jar '||
          	    'width=400 height=300>');
    
    htp.print('<param name=NFParamScript value=''');
    htp.print('Background    = (white, NONE);');
    htp.print('Header = ("Daily Usage for the Week");' );
    htp.print('BottomTics  = ("ON", black, "Arial", 11);');
    htp.print('DataSets	= ("Daily",NULL,BAR,NULL,FILLED);');
    
    valuestring_v :=  <some values>
    barlabels_v :=     <some labels>
    activelabels1_v :=  <some other labels>
    
    htp.print('DataSet1	= '||valuestring_v||';');
    htp.print('BarLabels	= '||barlabels_v||';');
    htp.print('ActiveLabels1 = '||activelabels1_v||';');
    htp.print('ActiveClicks = 2;');
    htp.print('Bar3DDepth = 30;');
    htp.print('BarBorder = (NONE,1,black);');
    htp.print('''>');
    htp.print('</applet>');
    JoeB
    save disk space, use smaller fonts

  3. #3
    Join Date
    Feb 2005
    Posts
    29
    Many Thanks. This looks useful.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •