Last Week in the Forums: JAX-WS Data Source Issue, Issue with Scatter Plot and LOTS of Data, and more...
Posted by
mwilliams
, 16 July 2012 - 06:43 AM
The unanswered post, from last week, that I'll cover, is about using a JAX-WS (axis 2) data source, with BIRT. The poster is currently running into issues with getting the schema from the response, while using Geronimo. If anyone has set something like this up or has any web services wisdom to pass along, please post in the thread.
The next topic I'll discuss is about using lots of data in a scatter plot. The poster was having troubles plotting the data they had. Using a line chart, they ended up with weird straight lines running across the chart where they shouldn't be. With this happening, they turned to a scatter plot, but the smallest size of marker was too big to show the intricate details of the plot, as there was lots and lots of data and multiple series close together. A solution is provided that shows the output of using a 1 pixel image as the marker with the size set at 0. With this setting, the marker truly is a 1 pixel dot, which allows the plot to render clearly, even with lots of data. The poster ended up using a different route, that required more work, to get around the issue. Their solution is detailed step by step, in the thread.
The last topic, for this week, is about using row data to auto-fill values in a standard text. The poster had several rows of data and wanted to use the values from their dataSet rows to personalize a text. One solution to this is detailed in the thread. It is to use a text box in a table bound to the dataSet and use the <value-of> tag inside the HTML text box to be able to call the current row's data to complete the text. Within the table, this will dynamically fill in the appropriate information into the text, for each row.
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: Fragmented WSDL Schema Issue, Modyfying a Grid's Contents Dynamically, and more...
Posted by
mwilliams
, 09 July 2012 - 07:46 AM
The unanswered post, for this week, is about a problem with fragmented wsdl schemas, in BIRT. The poster is having an issue using a fragmented schema in their web service dataSet. They show their original wsdl and original schema in the thread, along with a changed schema that they found they could do to make it work, but they don't want to have to do. If anyone has run into an issue with this before or has an idea of something they could do to get around it without changing the schema, please post in the thread.
The next topic I'll cover is about modifying the contents of a grid dynamically. The poster wanted to be able to create an array from the rows in a dataSet and, then, step through their grid and change the values of the labels in each grid cell. The problem they were having was that they didn't have access to their data until the onCreate, but weren't able to step through their grid and modify the contents, at this point. They also didn't want to have to place script on each cell/label. A solution is provided that uses script in the before Factory to step through the grid and modify each label's onCreate script, so that the code only has to be done in one place. The example can be downloaded from the thread.
The last topic, for this week, is about adding grouping to a table dynamically and forcing a space between the groups. The poster wanted to be able to group their data and have a space between the groups, using the DEAPI, not the designer. Some beforeFactory code is shown in the thread that grabs the table, creates a grouping, adds it to the table, and adds group header and footer rows. The footer row's height is set to force a spacing between the groups. As described in the thread, the script to add the header row and group header data element is commented out, as the poster did not want this.
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: Web Services Parameter Issue, Hiding Columns Based on a Parameter, and more...
Posted by
mwilliams
, 07 November 2011 - 07:30 AM
For this week's unanswered post, I'll cover one about problems with parameters in a web service data source. The poster has a web service that they can get to work correctly when testing in soapUI, but when they create a dataSource in BIRT, they are not getting their SOAP parameters for the WebMethod to show up in the dataSource wizard. If anyone has experienced a similar issue and knows how to get around it or knows what might be going wrong, feel free to provide a suggestion or solution to help this community member out! Thanks!
The next topic I'll discuss for this week is about dynamically hiding columns based on a parameter. This is a common question in the forums. How can you let your user choose which columns they want to see with a parameter. In the referenced thread, there is a link to a devShare article that should help with this. Here is a link to the example:
Dynamic Columns Based on Parameter
The last topic for this week is about formatting dates in a dynamic text box. The question was initially just how to format a date within a dynamic text box. A link to another forum thread with an answer to the same question was provided. Then, it was added that the formatting in the text box must be dynamic for US or European date format. A solution is provided that shows some rough code that shows how to use a parameter to decide which format to use. This code can be seen in the example. If anyone follows the rough code in this example and creates working code, please feel free to post the working code to the example.
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.
Recent Entries
Creating Derived Cube Measures and More with BIRT and ActuateOne
Drop Elements Depending on Output Format
Solving a TOC Bookmark Issue by Using Multiple Fields in a Single Group Expression
Visualizing the Impact of Database Changes with BIRT and ActuateOne
Actuate's 11SP4 Release Provides Many Powerful New Capabilities, Including HTML5 Charts and more!
Getting a Marker in the Middle of a Gantt Chart Bar, Multi-Level HTML List Numbering, and more...
Switch to a Default Table if no Values Returned in Query, Parameterize the From Portion of an SQL Query, and more...
Adding Text to an Image, Using Table Data for a Crosstab's Data, and more...
Only Highlight Bars of a Certain Series in a Chart, Reordering a Table's Columns, and more...
My Blog Links
Recent Comments
- mwilliams on Drop Elements Depending on Output Format
- donino on Drop Elements Depending on Output Format
- mwilliams on Creating a BIRT report as a calendar view
- lnallamalli on Creating a BIRT report as a calendar view
- For Birt on Last Week in the Forums: BIRT and R Statistical Language, Specified Sort Order for a Table, and more...
- Bhanwar on Last Week in the Forums: Filtering Blank Spaces from Distinct Count Aggregation, Adding a Line at 0 in a Chart with Negative Values, and more...
- Srividya Sharma on Sorting a Crosstab by a Field Not Displayed in the Crosstab
- mwilliams on Last Week in the Forums: Using the Concatenate Aggregate, Hiding a Column When There is No Data, and more...
- java032 on Last Week in the Forums: Using the Concatenate Aggregate, Hiding a Column When There is No Data, and more...
- java032 on Last Week in the Forums: Using the Concatenate Aggregate, Hiding a Column When There is No Data, and more...
0 user(s) viewing
0 member(s)
0 anonymous member(s)
Categories
- .rptdocument
- 11 SP4
- Actuate
- ActuateJavaComponent
- ActuateOne
- aggregating data
- aggregation
- alignment issues
- Alternating Highlight
- archived BIRT versions
- area chart
- axis label
- barcodes
- batch file
- BDPro
- BIRT
- BIRT Exchange
- BIRT functions
- BIRT Studio
- BIRT-Exchange
- bookmarks
- border
- border color
- bursting
- calendar
- cascading parameter
- CEAPI
- cell border
- chart
- charting
- charts
- color
- color codes
- command line
- computed column
- connection profile
- contest
- crosstab
- CSS
- CSV
- CSV export
- custom group
- custom sort
- Data Analyzer
- data cube
- Data Object
- data point label spacing
- data row security
- data set filter
- data set parameters
- dataset parameters
- Date Format
- deapi
- deploy
- devShare
- display name
- drop
- drop series
- dynamic chart
- dynamic chart labels
- dynamic chart marker
- dynamic chart scale
- dynamic chart title
- dynamic column sort
- Dynamic Column Visibility
- dynamic data set
- dynamic grid content
- dynamic grouping
- dynamic labels
- dynamic min/max
- dynamic scale
- Dynamic Text
- Dynamic Width
- Eclipse
- elapsed time format
- embedded grid
- empty csv error
- Event Handlers
- exception handling
- export data
- expression builder
- filter
- Firefox
- flash map
- Forum
- Forums
- fragmented schema
- gantt
- gantt chart
- global function
- GMT date
- grids
- group numbering
- grouping
- hide label
- hide measure detail
- hide series
- Hierarchy
- hierarchy report
- highlight
- highlight negative numbers
- HTML
- HTML listbox
- html lists
- HTML select form
- HTML Table
- HTML5
- https
- hyperlink
- image
- Impact Analysis
- Import Elements
- Ineractive Viewer
- Information Objects
- Interactive Viewer
- invalid dates
- iServer
- JAX-WS
- joint data set
- jquery
- jsapi
- JSF
- JSP
- legend
- legend color
- Library
- line height
- locale
- localization
- marker range color
- master page
- masterpage
- Maximo
- merge data
- multi-line text
- multi-select parameter
- multi-select parameters
- multi-value parameter
- multiple series
- NetWeaver
- newspaper
- newspaper layout
- optional y-series grouping
- osgi
- overlaying elements
- page break
- parameter
- parameters
- parameters in query
- PDF Complete
- Perl
- Pie Chart
- plug-in
- postgresql encoding issue
- progress bar
- property file
- R Statistical Language
- refresh report
- relative path
- reorder table
- report engine
- report viewer title
- reporting
- Reports
- Rolling Sum
- rotated text
- rptdesign
- rptlibrary
- runtime
- scatter plot
- script
- scripted dataset
- scroll bars
- Seam
- secure connection
- series color
- series name
- session variable
- sort
- Sort Order
- SP4
- special characters
- SQL
- SQL injection
- stacked bar
- stored procedure
- Styles
- Sub Report
- summing values from two different elements
- SVG
- table
- table footer
- Themes
- TOC
- TOC with page numbers
- tomcat
- Tooltip
- transient report cache
- truncated text
- user parameters
- Vaadin
- value-of format
- version features
- Viewer
- viewer title
- visibility
- Web Service
- web viewer
- Webshpere
- Word
- xls
- XML data source


