Charts

buntysingh
edited February 11, 2022 in Analytics #1
Can I draw control chart in Actuate BIRT? If yes, then how?
Can I draw a BAR as well as LINE chart in single graph? If yes, then how?
I need to draw a graph based on the values of another graph. Can I do it, if yes then how?

Comments

  • Virgil Dodson
    Virgil Dodson E admin
    edited December 31, 1969 #2
    Hi buntysingh,<br />
    <br />
    To answer your questions: <br />
    <br />
    Yes, you can create a control chart with BIRT. I created a quick example and uploaded it to <a class='bbc_url' href='http://www.birt-exchange.com/modules/wfdownloads/singlefile.php?cid=2&lid=184'>http://www.birt-exchange.com/modules/wfdownloads/singlefile.php?cid=2&lid=184</a>.<br />
    <br />
    To mix a BAR and LINE chart in a single graph, create a new chart as one of those types.<br />
    In the Select Data tab, select the Y-axis drop down and then <New Series...><br />
    In the Format Chart tab, select the node named "Series" and then select the Type for your second axis. You can choose from Bar, Line, Area, Stock, Tube, Cone, and Pyramid.<br />
    <br />
    As far as using the values from one graph on another, I'm not I completely understand. For the most part, the chart uses data from the container it's in, or from a data set. Two (or even more) charts can all pull from the same data.<br />
    <br />
    Virgil
    Warning No formatter is installed for the format ipb
  • buntysingh
    edited December 31, 1969 #3
    Hi Virgil,<br />
    <br />
    Thanks for the help.<br />
    <br />
    I want to create a control chart using Oracle database. <br />
    <br />
    Please help me in developing the same.<br />
    <br />
    Waiting to hear from you.<br />
    <br />
    Regards,<br />
    Sudeep<br />
    <br />
    <br />
    <br />
    <blockquote class='ipsBlockquote' data-author="vdodson"><p>Hi buntysingh,<br />
    <br />
    To answer your questions: <br />
    <br />
    Yes, you can create a control chart with BIRT. I created a quick example and uploaded it to <a class='bbc_url' href='http://www.birt-exchange.com/modules/wfdownloads/singlefile.php?cid=2&lid=184'>http://www.birt-exchange.com/modules/wfdownloads/singlefile.php?cid=2&lid=184</a>.<br />
    <br />
    To mix a BAR and LINE chart in a single graph, create a new chart as one of those types.<br />
    In the Select Data tab, select the Y-axis drop down and then <New Series...><br />
    In the Format Chart tab, select the node named "Series" and then select the Type for your second axis. You can choose from Bar, Line, Area, Stock, Tube, Cone, and Pyramid.<br />
    <br />
    As far as using the values from one graph on another, I'm not I completely understand. For the most part, the chart uses data from the container it's in, or from a data set. Two (or even more) charts can all pull from the same data.<br />
    <br />
    Virgil</p></blockquote>
  • Virgil Dodson
    Virgil Dodson E admin
    edited December 31, 1969 #4
    Hi Sudeep,

    Creating the control chart in Oracle is exactly the same as the example I put into the DevShare. After downloading the example, double-click the chart and look through the Data tab to make sure you understand each of the 4 series that was created. After that, you should be able to add an Oracle JDBC datasource, create a SQL query (Data Set), and then plug the data into the chart similar to what was already created.

    Virgil
    Warning No formatter is installed for the format ipb
  • SAmbekar
    edited December 31, 1969 #5
    Hi Virgil,

    I was trying to open the DevShare item that you had uploaded for control charts...but whenever I open any 2.2 version downloaded file and try to open it in the editor, I get an error and cannot open the file:
    Error opening the editor.
    java.lang.NullPointerException
    What is causing this error? I have the correct 2.2 version on my PC.

    Also, when I try to view the 2.2 version created report through the iPortal, I get the following error:
    “Failed to get Java report parameters”
    I don't have any parameters in my report...still the error.

    Please can you guide me?

    Thanks,
    SAmbekar
  • Virgil Dodson
    Virgil Dodson E admin
    edited December 31, 1969 #6
    Hi SAmbekar,<br />
    <br />
    I created that example with version 2.2.0.v20070626-1003. This should open just fine with BIRT 2.2. What version shows up for new reports if you look at the XML Source? <br />
    <br />
    I modified the DevShare items located at <a class='bbc_url' href='http://www.birt-exchange.com/modules/wfdownloads/singlefile.php?cid=2&lid=184'>http://www.birt-exchange.com/modules/wfdownloads/singlefile.php?cid=2&lid=184</a&gt; to include a 2.1.3 and 2.2 versions of the report design.
    Warning No formatter is installed for the format ipb
  • SAmbekar
    edited December 31, 1969 #7
    The XML source shows Eclipse BIRT Designer Version 2.2.0.v20070620 only but it does not open in the 2.2 designer. I am having similar issues in opening the designs created in 2.2 designer which I download. do you have any clue why I get that error for the 2.2 designs in the designer and also in iPortal?
  • Virgil Dodson
    Virgil Dodson E admin
    edited December 31, 1969 #8
    For the designers, did you download them from this site:<a class='bbc_url' href='http://www.birt-exchange.com/modules/wfdownloads/staticdls_index.php'>http://www.birt-exchange.com/modules/wfdownloads/staticdls_index.php</a><br />
    If so, which version did you download, there are several version of Eclipse and Actuate designers.<br />
    <br />
    For the iPortal, there are two versions. One that runs 2.1.3 BIRT reports...but has Interactive Viewer and BusinessReport Studio... and one that runs 2.2 BIRT reports but not the other features yet. Which are you using?
    Warning No formatter is installed for the format ipb
  • SAmbekar
    edited December 31, 1969 #9
    Yes I am downloading from the site that you mentioned. For the designer: I have downloaded BIRt report designer proffessional 2.2 version. Still when I try to open somebody else's design created on the same above version in my designer, I get that NullPointerException error.


    The iPortal issue is resolved...I was trying to open 2.2 report file on 2.1.3 version of iPortal hence was getting the error. Now I downloaded the 2.2 version of iPortal and its working fine.

    But the designer is still an issue.
  • Virgil Dodson
    Virgil Dodson E admin
    edited December 31, 1969 #10
    Hi SAmbekar,<br />
    <br />
    Try creating a new blank report in BIRT, and then look at the XML Source. Does it say 3.2.14 for the version stamp?<br />
    <br />
    <report xmlns="http://www.eclipse.org/birt/2005/design&quot; version="3.2.14" id="1"><br />
    <br />
    You might want to try the download again from the URL below if you see any different numbers. I just downloaded it myself from there to make sure there wasn't a problem with that build and it would load the BIRT 2.2 examples.<br />
    <br />
    <a class='bbc_url' href='http://www.birt-exchange.com/modules/wfdownloads/singlefile.php?cid=2&lid=133'>http://www.birt-exchange.com/modules/wfdownloads/singlefile.php?cid=2&lid=133</a&gt;
    Warning No formatter is installed for the format ipb
  • buntysingh
    edited December 31, 1969 #11
    Hi Virgil,

    Do we have "study (in Chart Builder)" feature in BIRT as we have in Actuate eBrdPro?

    Thanks.
  • SAmbekar
    edited December 31, 1969 #12
    Hi Virgil,

    I tried what you said and it does show 3.2.14 for the version stamp. So the version I downloaded is right. However as I said, I cannot open any 2.2 design which is NOT created by me in this designer. I get the same error:
    Error opening the editor.
    java.lang.NullPointerException
  • Virgil Dodson
    Virgil Dodson E admin
    edited December 31, 1969 #13
    Hi SAmbekar,

    I can't tell what is going on, but it seems worth a shot to download the designer again.

    Virgil
    Warning No formatter is installed for the format ipb
  • SAmbekar
    edited December 31, 1969 #14
    Hi Virgil,

    I have tried downloading the designer several times but in vain...I get the same error!
  • rmurphy
    edited December 31, 1969 #15
    I have tested the design and it is working for me. Here are the steps I took to test it:<br />
    <br />
    1. Downloaded zip file and extracted the 2.2 report design into my Report Project.<br />
    <br />
    2. Extracted the csv file into c:temp<br />
    <br />
    3. Opened the design in BIRT 2.2<br />
    <br />
    4. Modified the Data Set to point to c:temp<br />
    <br />
    5. Viewed report in Preview tab, Web Viewer, and PDF<br />
    <br />
    Did you take these same or similar steps to view the report?<br />
    <br />
    I wonder if somehow the zip file is getting corrupted over the network. I downloaded an md5sum utility from <a class='bbc_url' href='http://www.pc-tools.net/win32/md5sums/'>http://www.pc-tools.net/win32/md5sums/</a&gt; to get the md5sum. I obtained the following md5sum when I ran the utility against simplecontrolchart.zip<br />
    c87d49c40dd1e0e6f704e4fe193f601f<br />
    <br />
    When I extract the controlChartTest_2_2.rptdesign file from the zip, I get the following md5sum:<br />
    22f50b88468518d8d79fc0082667cc4e<br />
    <br />
    If you check the md5sums of the files and they match, that will eliminate the files as a possible source of the problem.<br />
    <br />
    Rob