Arindam

Members
  • Content count

    730
  • Joined

  • Last visited

Posts posted by Arindam


  1. I am afarid we have not yet implemented FusionCharts in Cognos

    environment. But to give you some pointers on implementaion, i would say

    that FusionCharts needs HTML <oject>/<embed> tags . If Cognoz supprts

    using these tags it can be implemented very easily. FusionCharts takes it

    data as XML stream.


  2. please try this XML

    <graph caption='Monthly Unit Sales' xAxisName='Month' yAxisName='Units' showValues='0' decimals='0' formatNumberScale='0' labelDisplay='Rotate'>

      <set label='<a href="http://FusionCharts.com" >Jan </a>' value='462' />

      <set label='<a href="http://FusionCharts.com" >Feb </a>' value='857' />

      <set label='<a href="http://FusionCharts.com" >Mar </a>' value='671' />

      <set label='<a href="http://FusionCharts.com" >Apr </a>' value='494' />

      <set label='<a href="http://FusionCharts.com" >May </a>' value='761' />

     <styles>

    <definition>

    <style name='mystyle' type='font' underline='1' color="FF0000" isHTML='1' />

    </definition>

    <application>

    <apply toObject='datalabels' styles='mystyle' />

    </application>"

     </styles>

    </graph>


  3. hi,

    please use Combination Chart like FCF_MSColumn3DLineDY or FCF_MSColumn2DLineDY type chart for that given data. also follow this xml.

    <graph PYAxisName='Score' SYAxisName='Rating'

      xAxisName='Month' showValues='0' decimalPrecision='0' bgcolor='F3f3f3' bgAlpha='70'

      showColumnShadow='1' divlinecolor='c5c5c5' divLineAlpha='60' showAlternateHGridColor='1'

      alternateHGridColor='f8f8f8' alternateHGridAlpha='60'>

    <categories>

      <category name='ABC' />

    <category name='XYZ' />

      <category name='PQR' />

     

    </categories>

    <dataset seriesName='Jan-07' parentYAxis='P' color='c4e3f7'>

      <set value='35' />

    <set value='45' />

      <set value='50' />

    </dataset>

    <dataset seriesName='Feb-07' parentYAxis='P' color='Fad35e'>

      <set value='45' />

      <set value='43' />

    <set value='45' />

    </dataset>

     

    <dataset seriesName='Rating-Jan-07' parentYAxis='S' color='DD00BA' anchorSides='10'

      anchorRadius='3' anchorBorderColor='009900' >

      <set value='5' />

    <set value='4' />

    <set value='3' />

     

    </dataset>

     

    <dataset seriesName='Rating-Feb-07' parentYAxis='S' color='00BADD' anchorSides='10'

      anchorRadius='3' anchorBorderColor='009900' >

      <set value='5' />

    <set value='2' />

    <set value='3' />

    </dataset>

    </graph>


  4. hi,

    yes its Sql Server Connection problem.. if you want to connect Sql Server with SqlConnection provider then please change <connectionStrings> with in web.config, Please Add

    <add name="sqlServerConnection" providerName="System.Data.SqlClient" connectionString="uid=< user id >;pwd= < Pass word>;server=<remort sql server name>;database=<database name>"/>

    also use SqlConnection, SqlDataReader,SqlCommand instead of OdbcConnection, OdbcDataReader, OdbcCommand in DBConn.cs

    Arindam

    Infosoft Global


  5. hi,

    please do this way,

    $strQuery = "SELECT SUM(RAW_AMOUNT) as TotalRawAmount, SUM(FG_AMOUNT) as TotalFGAmount, SUM(WIP) as TotalWIPAmount, UPLOAD_DATE FROM raw_fg_sum GROUP by UPLOAD_DATE";

    1) 1st create UPLOAD_DATE categories : convert this sql to recordset after fetch etch record and convert it to category

    2) 2nd create date wise dataset of TotalRawAmount from recordset

    3) 3rd create date wise dataset of TotalWIPAmount from recordset

    see this ->

    $strQuery = "SELECT SUM(RAW_AMOUNT) as TotalRawAmount, SUM(FG_AMOUNT) as TotalFGAmount, SUM(WIP) as TotalWIPAmount, UPLOAD_DATE FROM raw_fg_sum GROUP by UPLOAD_DATE";

    $result=mysql_query($strSQL) or die(mysql_error());

    $strXML="<graph>";

    $Category="<categories>";

    $DataRawAmount="<dataset seriesname='RawAmount' color='FF0000'>";

    $DataFGAmount="<dataset seriesname='FGAmount' color='009900' showValues='1' >";

    while($oRs=mysql_fetch_array($result)){

    $Category .= "<category name='" . $oRs['UPLOAD_DATE'] . "' />";

    $DataRawAmount .= "<set value='" . $oRs['TotalRawAmount'] . "' />";

    $DataFGAmount .= "<set value='" . $oRs['TotalFGAmount'] . "' />";

    }

    $Category .= "</categories>";

    $DataRawAmount .= "</dataset>";

    $DataFGAmount .= "</dataset>";

    $strXML .= $Category . $DataRawAmount . $DataFGAmount . "</graph>";

    i think it will work

    Arindam Baral

    Infosoft Global