Virgil admin

You can integrate the BIRT viewer into your existing application. In BIRT 2.2, you can create a BIRT Web Project to see how the viewer is deployed, and then copy over the files and integrate the contents from the web.xml. You could also make your Java Objects available through a web service, XML, or a shared class on the…

Hi Kasper, This is a great example of something that should be posted into the DevShare area of BIRT Exchange. This probably belongs in the "Deploying BIRT Report" category as type "Designs & Code". As a user of BIRT Exchange and these forums, you already have the permissions to upload files and links in the DevShare area…

Jason has answered this question here:<br /> <a class='bbc_url' href='http://www.birt-exchange.com/modules/vbulletin/showthread.php?t=9967&highlight=Asynchronous+invocation+of+reports'>http://www.birt-exchange.com/modules/vbulletin/showthread.php?t=9967&highlight=Asynchronous+invocation+of+reports</a>

Hi Assaf,<br /> <br /> I have not tried this myself, but I understand this is possible now with BIRT 2.2. Have a look at this link at <a class='bbc_url' href='http://www.eclipse.org/birt/phoenix/project/notable2.2.php#jump_23'>http://www.eclipse.org/birt/phoenix/project/notable2.2.php#jump_23</a>. As I understand it, this…

Hi vt100,<br /> <br /> There is a tip on where to add your JDBC drivers in the DevShare area at:<br /> <a class='bbc_url' href='http://www.birt-exchange.com/modules/wfdownloads/singlefile.php?cid=5&lid=169'>http://www.birt-exchange.com/modules/wfdownloads/singlefile.php?cid=5&lid=169</a>

Hi buntysingh, Yes, portions of BIRT reports can be delivered as portlets, but not with just the designer. To get this functionality, your BIRT reports need to be deployed to the Actuate iServer. This acts as the container to first create the intermediate report format (.rptdocument) and then you can point at areas with…

Hi buntysingh, The evaluation version of iPortal has the Actuate logo at the top and embedded in the center of the Viewer. You can change this logo to fit your needs. Also within the iPortal, if you have installed the sample dashboard, you can see portions of BIRT reports (just a chart, or just a table, etc) within a…

Generally, BIRT (and reporting in general) is used to display data to the user so BIRT does not include any help in writing the data back to a database... Having said that, BIRT does fire events, and allows you to access Java classes all throughout the report generation process so you could write your own code that…

For efficiency, the frameset works from the rptdocument. To force it to rerun the report, pass the parameter on the URL along with the &__overwrite=true parameter.

Hi SAmbekar,<br /> <br /> Yes, you can create custom parameter pages for the iPortal. There are 3 different approaches you can take. <br /> <br /> 1) Create your own JSP page that does what ever you need and this page constructs the correct URL needed to generate the BIRT report through the iPortal.<br /> <br /> 2) Modify…

Hi amezzi, What version of BIRT are you using? I tried the same thing with BIRT 2.2 (hiding field with hyperlink for XLS, and hiding plain text field for rest of formats). All the formats worked correctly except for XLS which never showed the field at all. I tried this again with BIRT 2.2.1 and could see the correct field…

Hi Pax, I understand that the percentage (%) feature was removed as a chart width and height option since it was causing a distorted image to be created and the interactivity (drill-down) features were not lining up correctly. The problem would surface when the browser width caused the grid, or table, to expand to fill the…

Hi amezzi,<br /> <br /> What version of BIRT engine/viewer are you using? This sounds similar to a bug that was fixed for 2.2 at <a class='bbc_url' href='https://bugs.eclipse.org/bugs/show_bug.cgi?id=180440'>https://bugs.eclipse.org/bugs/show_bug.cgi?id=180440</a><br /> <br /> Virgil

Hi jeffreymac, There are a couple of event handlers needed to get at the values, and format the axis label. Below is a javascript example that may work for you. This one will color the label corresponding to the largest data value. var maxval=0; var dataSetProcessor; function beforeDataSetFilled(series, idsp, icsc) {…

Hi Pranav, One way to store the database connection is by using Libraries. By storing your data source in a library, you can easily change it and have it effect all reports that use the library. With BIRT 2.2, you can also create and leverage a Connection Profile so that changes made there also go across all the reports…

Yuan, can you add an attachment to this thread (ZIP it up first since that is the file that works best) with a simple example?

Hi ericsmith, This should work as you described. What version of BIRT are you using? I'm using BIRT 2.2 and just created a report design with 2 datasets. dataset1 has custnum, name, and city and dataset2 has custnum, name, and state I dropped dataset1 onto the report and previewed to make sure it worked... then selected…

Hi ychiu, Can you try putting quotes around your URI? The URI is an expression and may work but still produce an error. Virgil

Hi Donatus, The colors of the pie pieces can be set with script. Try something like: function beforeDrawDataPoint(dph, fill, icsc) { if (dph.getBaseDisplayValue().equals("USA")) { fill.set(0,0,255) } else if (dph.getBaseDisplayValue().equals("Spain")) { fill.set(0,255,0) } }

Hi Aaron,<br /> <br /> You should be able to delete the group total in the footer and just add a label that says "100%". I had to create a simple example to try this myself so I uploaded it to the DevShare at <a class='bbc_url'…

Hi Laurent,<br /> <br /> Are you getting any error messages? There are several ways of putting images into a BIRT report using URLs, from the file system, from the BIRT resource folder, and by embedding them. The example you referenced below has the image embedded which would be the least likely to cause problems finding…

Hi Jonathan, The ideal situation is if you can filter the data prior to getting the XML file. That way you are not pulling lots of extra information that won't be used on the report. If that part is out of your control, then you can use filtering at several levels as you have already figured out. You can filter you…

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

Hi Jonathan, Can you add a simple XML structure example to this post? Is it one XML file that has two data sets or two XML files? Virgil

There is an example uploaded in the DevShare called Periodically Reload BIRT Report:<br /> <a class='bbc_url' href='http://www.birt-exchange.com/modules/wfdownloads/singlefile.php?cid=2&lid=69'>http://www.birt-exchange.com/modules/wfdownloads/singlefile.php?cid=2&lid=69</a><br /> <br /> This example reloads a report every…

I understand from reading an earlier post that you can delete the sampledb plugin from your plugins directory.<br /> <br /> <a class='bbc_url' href='http://www.birt-exchange.com/modules/vbulletin/showthread.php?t=8928&referrerid=33'>http://www.birt-exchange.com/modules/vbulletin/showthread.php?t=8928&referrerid=33</a><br…

Hi hardik_982,<br /> <br /> I see the same results when trying this myself.<br /> <br /> It looks like a bug for the empty crosstab cells has already been filed.<br /> <a class='bbc_url' href='https://bugs.eclipse.org/bugs/show_bug.cgi?id=202119'>https://bugs.eclipse.org/bugs/show_bug.cgi?id=202119</a><br /> <br /> As a…

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" version="3.2.14" id="1"><br /> <br /> You might want to try the download again from the URL below if you see any…

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…

Hi SAmbekar,<br /> <br /> You can integrate the iPortal with your J2EE web app by using one of several approaches. You can integrate very easily by just using URLs to your deployed iPortal, or using the iPortal JSP tags, or by using the provided portlets if you need to run BIRT reports on your portal server.<br /> <br />…