Last week in the Forums: Integrating BIRT 3.7 with NetWeaver, Chart Data Point Label Spacing Issue, and more...
Posted by
mwilliams
, 03 January 2012 - 07:29 AM
This blog series takes a look back at the past week in the forums, recalling how active they were and highlights some of the questions asked that seem to frequent the forums or other interesting topics. Happy New Year! The forums were slow to finish off the last week of 2011, but are back in full force to start the first week of 2012! Many great questions and answers are being posted every day. As always, thanks to those users who help answer questions! It is a great help to the community!
There are a couple unanswered questions from last week that I'll cover. One is passing user login info to the BIRT viewer. The poster is working with a penataho application and wants to pass their user info into BIRT through a parameter, but are running into issues. The second unanswered question from last week is regarding integrating BIRT 3.7 and NetWeaver. If anyone has any experience with passing Pentaho user info or integrating BIRT with NetWeaver, please post your solution or suggestions in the forum thread!
The next question from last week is a spacing issue for data point labels in a chart. The poster had a chart that when there was a negative bar, the data point label would overlap the x-axis. The solution given here was to go to the chart editor wizard, then to the format tab, then to the plot section, and click on the area format button at the bottom. Here you can set the bottom inset to a value that allows you to avoid the overlap.
The last topic for this week is setting a dynamic y-axis scale. The poster was wanting to have a parameter that defined a max value for the y-axis parameter, but only wanted to use this value if the value was greater than the max value in the chart. The solution to this is to use the AfterDataSetFilled function to get the maximum value, then in the beforeGeneration, compare this to the parameter value. The poster shows their final chart script in the thread.
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.
There are a couple unanswered questions from last week that I'll cover. One is passing user login info to the BIRT viewer. The poster is working with a penataho application and wants to pass their user info into BIRT through a parameter, but are running into issues. The second unanswered question from last week is regarding integrating BIRT 3.7 and NetWeaver. If anyone has any experience with passing Pentaho user info or integrating BIRT with NetWeaver, please post your solution or suggestions in the forum thread!
The next question from last week is a spacing issue for data point labels in a chart. The poster had a chart that when there was a negative bar, the data point label would overlap the x-axis. The solution given here was to go to the chart editor wizard, then to the format tab, then to the plot section, and click on the area format button at the bottom. Here you can set the bottom inset to a value that allows you to avoid the overlap.
The last topic for this week is setting a dynamic y-axis scale. The poster was wanting to have a parameter that defined a max value for the y-axis parameter, but only wanted to use this value if the value was greater than the max value in the chart. The solution to this is to use the AfterDataSetFilled function to get the maximum value, then in the beforeGeneration, compare this to the parameter value. The poster shows their final chart script in the thread.
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.
0 Comments On This Entry
Page 1 of 1
Page 1 of 1
Recent Entries
Last week in the Forums: Special Characters in BIRT, Changing a Selected Field in a Query Based on a Parameter, and more...
Last week in the Forums: "Processing" Bar for PDF Reports, Stacked Bar Chart "Total" Label, and more...
Last week in the Forums: Passing a Database Connection to BIRT, Label Text Orientation, and more...
Last week in the Forums: Custom Groupings in Crosstab, Changing the Title of the Viewer, and more...
Last week in the Forums: Dynamic Security Expression, RowNum in Crosstab, and more...
Last week in the Forums: Accessing Session Variables in BIRT, Adding Crosstab Page Break in Script, and more...
Last week in the Forums: Dynamic Image Height/Width, Tooltips in a Crosstab, and more...
Last week in the Forums: Launching PERL Script from Hyperlink, Bursting Reports, and more...
Last week in the Forums: Dynamically Build Chart using CEAPI, Determining if a Parameter is Multi-Select or not, and more...
Last week in the Forums: Forcing Column Page Breaks in a Crosstab, Changing Dates to GMT, and more...
Last week in the Forums: "Processing" Bar for PDF Reports, Stacked Bar Chart "Total" Label, and more...
Last week in the Forums: Passing a Database Connection to BIRT, Label Text Orientation, and more...
Last week in the Forums: Custom Groupings in Crosstab, Changing the Title of the Viewer, and more...
Last week in the Forums: Dynamic Security Expression, RowNum in Crosstab, and more...
Last week in the Forums: Accessing Session Variables in BIRT, Adding Crosstab Page Break in Script, and more...
Last week in the Forums: Dynamic Image Height/Width, Tooltips in a Crosstab, and more...
Last week in the Forums: Launching PERL Script from Hyperlink, Bursting Reports, and more...
Last week in the Forums: Dynamically Build Chart using CEAPI, Determining if a Parameter is Multi-Select or not, and more...
Last week in the Forums: Forcing Column Page Breaks in a Crosstab, Changing Dates to GMT, and more...
My Blog Links
Recent Comments
- 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...
- 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 Guests
0 member(s)
0 anonymous member(s)
0 member(s)
0 anonymous member(s)
Categories
- .rptdocument
- Actuate
- aggregation
- alignment issues
- Alternating Highlight
- archived BIRT versions
- area chart
- axis label
- barcodes
- BIRT
- BIRT Exchange
- BIRT-Exchange
- bookmarks
- border
- border color
- bursting
- calendar
- cascading parameter
- CEAPI
- chart
- charting
- charts
- color
- color codes
- computed column
- connection profile
- crosstab
- CSS
- CSV
- custom group
- data point label spacing
- data row security
- data set parameters
- Date Format
- deploy
- drop series
- dynamic chart
- dynamic chart labels
- dynamic chart scale
- dynamic chart title
- Dynamic Column Visibility
- dynamic data set
- dynamic labels
- dynamic scale
- Dynamic Text
- Dynamic Width
- Eclipse
- elapsed time format
- embedded grid
- empty csv error
- Firefox
- Forum
- Forums
- GMT date
- grids
- group numbering
- hide label
- hide measure detail
- hide series
- Hierarchy
- hierarchy report
- highlight
- highlight negative numbers
- HTML
- HTML listbox
- HTML Table
- hyperlink
- image
- invalid dates
- joint data set
- JSF
- JSP
- legend
- localization
- Masterpage
- Maximo
- merge data
- multi-line text
- multi-select parameter
- multi-select parameters
- NetWeaver
- page break
- parameters
- parameters in query
- Perl
- Pie Chart
- progress bar
- property file
- R Statistical Language
- refresh report
- relative path
- reporting
- Reports
- Rolling Sum
- rotated text
- script
- scripted dataset
- Seam
- secure connection
- session variable
- Sort Order
- special characters
- SQL
- SQL injection
- stacked bar
- stored procedure
- Styles
- Sub Report
- summing values from two different elements
- SVG
- Themes
- TOC with page numbers
- Tooltip
- user parameters
- version features
- Viewer
- viewer title
- visibility
- Web Service
- XML data source




Del.icio.us
Digg
Facebook
Google
Mixx
Reddit
StumbleUpon
