Charts

buntysinghbuntysingh Junior Member
edited December 31, 1969 in Designing Analytics Reports
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

  • VirgilVirgil Administrator EM admin
    edited December 31, 1969
    Hi buntysingh,



    To answer your questions:



    Yes, you can create a control chart with BIRT. I created a quick example and uploaded it to http://www.birt-exchange.com/modules/wfdownloads/singlefile.php?cid=2&lid=184.



    To mix a BAR and LINE chart in a single graph, create a new chart as one of those types.

    In the Select Data tab, select the Y-axis drop down and then

    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.



    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.



    Virgil

    Virgil Dodson
    OpenText Analytics Developer Community
    https://forums.opentext.com/forums/categories/analytics

  • buntysinghbuntysingh Junior Member
    edited December 31, 1969
    Hi Virgil,



    Thanks for the help.



    I want to create a control chart using Oracle database.



    Please help me in developing the same.



    Waiting to hear from you.



    Regards,

    Sudeep







    Hi buntysingh,



    To answer your questions:



    Yes, you can create a control chart with BIRT. I created a quick example and uploaded it to http://www.birt-exchange.com/modules/wfdownloads/singlefile.php?cid=2&lid=184.



    To mix a BAR and LINE chart in a single graph, create a new chart as one of those types.

    In the Select Data tab, select the Y-axis drop down and then

    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.



    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.



    Virgil

  • VirgilVirgil Administrator EM admin
    edited December 31, 1969
    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

    Virgil Dodson
    OpenText Analytics Developer Community
    https://forums.opentext.com/forums/categories/analytics

  • SAmbekarSAmbekar Junior Member
    edited December 31, 1969
    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
  • VirgilVirgil Administrator EM admin
    edited December 31, 1969
    Hi SAmbekar,



    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?



    I modified the DevShare items located at http://www.birt-exchange.com/modules/wfdownloads/singlefile.php?cid=2&lid=184 to include a 2.1.3 and 2.2 versions of the report design.

    Virgil Dodson
    OpenText Analytics Developer Community
    https://forums.opentext.com/forums/categories/analytics

  • SAmbekarSAmbekar Junior Member
    edited December 31, 1969
    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?
  • VirgilVirgil Administrator EM admin
    edited December 31, 1969
    For the designers, did you download them from this site:http://www.birt-exchange.com/modules/wfdownloads/staticdls_index.php

    If so, which version did you download, there are several version of Eclipse and Actuate designers.



    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?

    Virgil Dodson
    OpenText Analytics Developer Community
    https://forums.opentext.com/forums/categories/analytics

  • SAmbekarSAmbekar Junior Member
    edited December 31, 1969
    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.
  • VirgilVirgil Administrator EM admin
    edited December 31, 1969
    Hi SAmbekar,



    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?







    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.



    http://www.birt-exchange.com/modules/wfdownloads/singlefile.php?cid=2&lid=133

    Virgil Dodson
    OpenText Analytics Developer Community
    https://forums.opentext.com/forums/categories/analytics

  • buntysinghbuntysingh Junior Member
    edited December 31, 1969
    Hi Virgil,

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

    Thanks.
  • SAmbekarSAmbekar Junior Member
    edited December 31, 1969
    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
  • VirgilVirgil Administrator EM admin
    edited December 31, 1969
    Hi SAmbekar,

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

    Virgil

    Virgil Dodson
    OpenText Analytics Developer Community
    https://forums.opentext.com/forums/categories/analytics

  • SAmbekarSAmbekar Junior Member
    edited December 31, 1969
    Hi Virgil,

    I have tried downloading the designer several times but in vain...I get the same error!
  • edited December 31, 1969
    I have tested the design and it is working for me. Here are the steps I took to test it:



    1. Downloaded zip file and extracted the 2.2 report design into my Report Project.



    2. Extracted the csv file into c:temp



    3. Opened the design in BIRT 2.2



    4. Modified the Data Set to point to c:temp



    5. Viewed report in Preview tab, Web Viewer, and PDF



    Did you take these same or similar steps to view the report?



    I wonder if somehow the zip file is getting corrupted over the network. I downloaded an md5sum utility from http://www.pc-tools.net/win32/md5sums/ to get the md5sum. I obtained the following md5sum when I ran the utility against simplecontrolchart.zip

    c87d49c40dd1e0e6f704e4fe193f601f



    When I extract the controlChartTest_2_2.rptdesign file from the zip, I get the following md5sum:

    22f50b88468518d8d79fc0082667cc4e



    If you check the md5sums of the files and they match, that will eliminate the files as a possible source of the problem.



    Rob
Sign In or Register to comment.