BIRT Exchange Forum: BIRT Exchange Forum -> Michael's BIRT Blog

Last Week in the Forums - 9/24/12

The first post, for this week, is about placing a marker in the middle of a gantt series bar. The poster wanted to be able to have a marker in the middle of a gantt chart bar, that was not at the beginning or the end. A gantt chart only has the option to have a marker at the beginning or end of a series. An example is provided that shows how two series can be used to make it appear as if there is a marker in the middle of the bar.

The next post, for this week, is about getting multi-level numbering in html lists. The poster wanted to be able to take an HTML list like:

<ul class="numericbullets"> 
<li>Cats</li> 
<li>Dogs 
    <ul> 
        <li>Birds</li> 
        <li>Rats
                                <ul> 
                                                <li>Birds</li> 
                                                <li>Rats</li> 
                                                <li>Rats</li> 
                                                <li>Rats</li> 
                                </ul> 
                
                </li> 
    </ul> 
</li> 
<li>Rabbits</li> 
<li>Ants 
    <ul> 
        <li>Lions</li> 
        <li>Rats</li> 
        <li>Rats</li> 
        <li>Rats</li> 
    </ul> 
</li> 
<li>Ducks</li> 
</ul>

and make it look like:

    1. Cats
    2. Dogs
        2.1 Birds
        2.2 Rats
            2.2.1 Birds
            2.2.2 Rats
            2.2.3 Rats
            2.3.4 Rats
    3. Rabbits
    4. Ants
        4.1 Lions
        4.2 Rats
        4.3 Rats
        4.4 Rats
    5. Ducks

The needed CSS styles to make this happen were failing to upload into the design. The solution that was found to work was to take the css styles:

ul.numericbullets { counter-reset:section; list-style-type:none; } 
ul.numericbullets li { list-style-type:none; } 
ul.numericbullets li ul { counter-reset:subsection; } 
ul.numericbullets li ul li ul{ counter-reset:subsubsection; } 
ul.numericbullets li:before{ 
    counter-increment:section; 
    content:counter(section) ". ";
} 
ul.numericbullets li ul li:before { 
    counter-increment:subsection; 
    content:counter(section) "." counter(subsection) " "; 
} 
ul.numericbullets li ul li ul li:before { 
    counter-increment:subsubsection; 
    content:counter(section) "." counter(subsection) "." counter(subsubsection) " "; 
}

and place them in style.css in webcontet -> birt -> styles. This style sheet is used in run and frameset. It won't work with preview, so don't be worried if you don't see this in any output that uses the preview option.

Here are a few more :

• Invalid Design file
  
• dataset parameters disappear
  
• Create Global Function
  
• Calculate between rows
  
• Named parameters in DataSet Query

Here are a few unanswered posts, from last week:

• How to connecting to database during param validation
  
• Cross Tab -data not to sort alphabetically
  
• Can I flip the origin of bar chart?
  
• Flat file on iServer
  
• Exporting report with 'https' images

If you have a suggestion or solution for any of these, please post in the thread!

Thanks for reading this weeks blog! Again, this is just a small sample of what went through the forums this past week. For more questions and answers that have been posted, check out the forums. As always, if you have a question, feel free to ask it, and if you see a question you know the answer to or have a similar experience to, feel free to post an answer or comment.

Last Week in the Forums - 9/17/12

The first post, for this week, is about showing a default result set if the main one is empty. The poster wanted to be able to show a default table if the parameter entered by the user returned no results. An example is posted in the thread that shows how to set the visibility of the two tables based on a variable that is set in the onFetch of the parameterized dataSet.

The next post, for this week, is about how to parameterize the from portion of an SQL query. The poster wanted to be able to use a parameter value to choose which table to use in the from portion of an SQL query. The solution provided was to use the report parameter in the beforeOpen of the dataSet, like:

this.queryText = "select * from " + params["myparameter"];

Here are a few more :

• Why so many date-time datapoints on chart?
  
• how to get a chart svg output as an object
  
• Dynamic Report Based on User Selection
  
• Cant Startup the OSGI Framework in BIRT
  
• Serial number for newspaper columns

Here are a few unanswered posts, from last week:

• ClassCastException on WebLogic BEA Servers
  
• Birt Reports not working other then maxadmin user

If you have a suggestion or solution for any of these, please post in the thread!

Thanks for reading this weeks blog! Again, this is just a small sample of what went through the forums this past week. For more questions and answers that have been posted, check out the forums. As always, if you have a question, feel free to ask it, and if you see a question you know the answer to or have a similar experience to, feel free to post an answer or comment.

Last Week in the Forums - 9/10/12

The first post, for this week, is about adding text to an image. The poster wanted to be able to add text to an image, within BIRT. One option could be to use the image as a background image on a grid or text element. The poster wasn't able to use this method, because background images don't export to Excel. Another solution that adds the text to the image, in script, using the image data, is attached in the forum thread.

The next post, for this week, is about using a table's output as input to a crosstab. The poster wanted to be able to feed the final results of their table to a crosstab. An example is posted in the thread that shows how to grab the table data and use it in a scripted dataSet that is used to build the cube.

Here are a few more :

• Optional grouping breaking pie chart
  
• onclick on a image
  
• Need "get started" for birt charting api
  
• Exception java.lang.NoSuchMethodError
  
• [chart]Mixing stacked and unstacked bars

Here are a few unanswered posts, from last week:

• How to use jquery or other javascript frame work in BIRT for client side scripting
  
• Stored procedure not returning expected data
  
• Birt chart overriding Birt report style
  
• Using ReportEngine in a Java Applet

If you have a suggestion or solution for any of these, please post in the thread!

Thanks for reading this weeks blog! Again, this is just a small sample of what went through the forums this past week. For more questions and answers that have been posted, check out the forums. As always, if you have a question, feel free to ask it, and if you see a question you know the answer to or have a similar experience to, feel free to post an answer or comment.

Last Week in the Forums - 9/3/12

The first post, for this week, is about highlighting bars in a single series of a chart, only. The poster was using script in the beforeDrawDataPoint to color their data point. The problem is that they were highlighting all series, not just the one they wanted. The solution to this is to check the series with dph.getSeriesDisplayValue() before setting the color.

The next post, for this week, is about reordering columns in a table. The poster has a table already in their design, but they'd like to reorder the columns based on a condition. An example is provided in the forum thread with beforeFactory code that switches the order of columns in a table based on a parameter.

Here are a few more :

• Alternating row background color in Crosstab
  
• Using numeric values from a data set in a global Variable
  
• How to Sort a chart on Dates
  
• Integrating Maximo reports into Birt Viewer

Here are a few unanswered posts, from last week:

• How to create Report using Rest web Service
  
• Changes in Data Objects not showing on reports

If you have a suggestion or solution for any of these, please post in the thread!

Thanks for reading this weeks blog! Again, this is just a small sample of what went through the forums this past week. For more questions and answers that have been posted, check out the forums. As always, if you have a question, feel free to ask it, and if you see a question you know the answer to or have a similar experience to, feel free to post an answer or comment.