Last Week in the Forums: Large .rptdocument Sizes, Removing the Extra Spacing Around Grids, and more...
Posted by
mwilliams
, 24 October 2011 - 06:33 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 stayed pretty busy this last week. Maybe down a little from previous weeks, but busy nonetheless. 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!
As I've been doing the last couple weeks, the first post will be one from last week that doesn't have a response yet. This one is about the .rptdocument size. They have a client who is wanting to save the .rptdocuments on their server, but the .rptdocuments take up lots of memory, so they're wanting to know if there is a way to reduce the size of the .rptdocument files. So, if you have a solution for this, or if you have a method you've used to deal with the large size of these files, please feel free to comment on the post!
The next post for this week is about white spacing around embedded grids that mess up alignment. The poster was having an issue with extra white space causing alignment issues when they embed grids inside other elements. If they embed several grids within others, the spacing becomes very bad. The solution to this is that each element has a 1pt default padding. If you go to the padding settings in the property editor and make these 0, this alignment issue will go away. You won't see this change in your design, but if you run the report, you'll notice the difference.
The last topic for this week is about creating a TOC with page numbers and bookmark hyperlinks in your report. This has been a very frequent topic for the forums, so I thought I'd cover it in here. I may have done so before, but it never hurts to do it again! :) To get a TOC with page numbers to work, you'll need to use separate run and render tasks. From the designer, this means you'll need to use the web viewer and then export to your desired output from there. When deployed, you'll either use java to call the tasks separately, or you'll use the frameset url. In your design, you'll need to put a table or list at the top of your report with distinct listings of whatever your groups are, for your TOC. In your table with your data, you'll need to store the current "pageNumber" into a persistent global variable that is named for your group. This will be done in the onCreate for your group header. Now, in the onRender of a dynamic text box in your TOC table, you can recall these PGV's you set in the onCreate to display the page numbers. For the bookmarks, you just create a bookmark in the data table on the group header and then use the internal bookmark hyperlink on the TOC table to jump to the bookmark. I was unable to attach the example in the forums for some reason, but it attached in here. So, if you need an example, look at the attachments.
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.
As I've been doing the last couple weeks, the first post will be one from last week that doesn't have a response yet. This one is about the .rptdocument size. They have a client who is wanting to save the .rptdocuments on their server, but the .rptdocuments take up lots of memory, so they're wanting to know if there is a way to reduce the size of the .rptdocument files. So, if you have a solution for this, or if you have a method you've used to deal with the large size of these files, please feel free to comment on the post!
The next post for this week is about white spacing around embedded grids that mess up alignment. The poster was having an issue with extra white space causing alignment issues when they embed grids inside other elements. If they embed several grids within others, the spacing becomes very bad. The solution to this is that each element has a 1pt default padding. If you go to the padding settings in the property editor and make these 0, this alignment issue will go away. You won't see this change in your design, but if you run the report, you'll notice the difference.
The last topic for this week is about creating a TOC with page numbers and bookmark hyperlinks in your report. This has been a very frequent topic for the forums, so I thought I'd cover it in here. I may have done so before, but it never hurts to do it again! :) To get a TOC with page numbers to work, you'll need to use separate run and render tasks. From the designer, this means you'll need to use the web viewer and then export to your desired output from there. When deployed, you'll either use java to call the tasks separately, or you'll use the frameset url. In your design, you'll need to put a table or list at the top of your report with distinct listings of whatever your groups are, for your TOC. In your table with your data, you'll need to store the current "pageNumber" into a persistent global variable that is named for your group. This will be done in the onCreate for your group header. Now, in the onRender of a dynamic text box in your TOC table, you can recall these PGV's you set in the onCreate to display the page numbers. For the bookmarks, you just create a bookmark in the data table on the group header and then use the internal bookmark hyperlink on the TOC table to jump to the bookmark. I was unable to attach the example in the forums for some reason, but it attached in here. So, if you need an example, look at the attachments.
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.
Attached File(s)
-
TOCWithPageNumbers.rptdesign (28.34K)
Number of downloads: 427
0 Comments On This Entry
Page 1 of 1
Page 1 of 1
Recent Entries
Plug In 2 BIRT Contest - Spring 2013 Ends Soon
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...
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 Guests
0 member(s)
0 anonymous member(s)
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




Del.icio.us
Digg
Facebook
Google
Mixx
Reddit
StumbleUpon
