Last week in the Forums: Passing Parameters to BIRT from JSF pages, Summing Values from Two Different Elements, and more...
Posted by
mwilliams
, 09 January 2012 - 07:26 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. The forums have been CRAZY busy, it seems, this new year, so far! 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!
The unanswered topic from last week is about passing parameters from JSF pages with Seam. The poster is having issues passing parameters to BIRT from their JSF pages. They're able to send static values, but not dynamic values. If anyone has encountered this issue or have a suggestion or solution, please post it in the thread!
The next topic for this week is summing two values from separate grids and displaying the sum in the report. One way to sum values from two different elements in a report is to use persistent global variables to store the values and then recall them and add them together where you want to display the sum. There are probably several ways that this can be done, but this is one of them. In this question, the poster also wanted to display the value before the elements the actual data is in. To do this, you can store the values in PGVs in your onCreate script and recall them in your onRender script to display the sum. You'll have to run the run and render tasks separately for this to work.
The last topic for this week is how to hide the details of a report based on a parameter. The poster had a grouped table with details. They wanted to be able to hide the detail section based on a user parameter. To do this, all you need to do is add visibility script to the detail row. A simple script is included in the thread that shows how to do so. The visibility settings can be found in the property editor of the element you're wanting to hide.
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.
The unanswered topic from last week is about passing parameters from JSF pages with Seam. The poster is having issues passing parameters to BIRT from their JSF pages. They're able to send static values, but not dynamic values. If anyone has encountered this issue or have a suggestion or solution, please post it in the thread!
The next topic for this week is summing two values from separate grids and displaying the sum in the report. One way to sum values from two different elements in a report is to use persistent global variables to store the values and then recall them and add them together where you want to display the sum. There are probably several ways that this can be done, but this is one of them. In this question, the poster also wanted to display the value before the elements the actual data is in. To do this, you can store the values in PGVs in your onCreate script and recall them in your onRender script to display the sum. You'll have to run the run and render tasks separately for this to work.
The last topic for this week is how to hide the details of a report based on a parameter. The poster had a grouped table with details. They wanted to be able to hide the detail section based on a user parameter. To do this, all you need to do is add visibility script to the detail row. A simple script is included in the thread that shows how to do so. The visibility settings can be found in the property editor of the element you're wanting to hide.
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
