aimbirt.blogspot.com
Birt and AiM: October 2010
http://aimbirt.blogspot.com/2010_10_01_archive.html
Tuesday, October 26, 2010. Alternative Row Highlighting in Birt. To improve readability of a list report, alternative row highlighting can be applied to the detail row of a table. Select the entire row, and then click on the Highlighting Tab in the Property Editor. Click Add and then paste the following text. Labels: alternate row highlighting. Subscribe to: Posts (Atom). Arlington, VA, United States. View my complete profile. Open Source Reporting Comparison BIRT, Jasper, Pentaho - Third Edition.
aimbirt.blogspot.com
Birt and AiM: Alternative Row Highlighting in Birt
http://aimbirt.blogspot.com/2010/10/alternative-row-highlighting-in-birt.html
Tuesday, October 26, 2010. Alternative Row Highlighting in Birt. To improve readability of a list report, alternative row highlighting can be applied to the detail row of a table. Select the entire row, and then click on the Highlighting Tab in the Property Editor. Click Add and then paste the following text. Labels: alternate row highlighting. Subscribe to: Post Comments (Atom). Arlington, VA, United States. View my complete profile. Open Source Reporting Comparison BIRT, Jasper, Pentaho - Third Edition.
aimbirt.blogspot.com
Birt and AiM: Creating Birt Sub-Reports Using Dataset Parameter Binding
http://aimbirt.blogspot.com/2010/12/creating-birt-sub-reports-using-dataset.html
Monday, December 20, 2010. Creating Birt Sub-Reports Using Dataset Parameter Binding. I'm going to write about a feature that I only recently discovered and wished I knew about a long time ago. The concept is how to do sub-reporting and neatly tie the master value with sub-reports using something called dataset parameter binding. For example, let's say I have a master record like a service contract, and I want to report all the associated invoices associated to the service contract. Nice to see another p...
aimbirt.blogspot.com
Birt and AiM: Hyperlink to a new email off Birt Report
http://aimbirt.blogspot.com/2010/12/hyperlink-to-new-email-off-birt-report.html
Tuesday, December 21, 2010. Hyperlink to a new email off Birt Report. I made a series of contact list reports off the Human Resources module for use as a phone/email directory and I wanted to make the email addresses hyperlinked so that the default email application would start an email when the address was clicked off the report. Make a text field in the email column of your table. Set type to html. Subscribe to: Post Comments (Atom). Arlington, VA, United States. View my complete profile.
aimbirt.blogspot.com
Birt and AiM: Cascading Date Range Parameters
http://aimbirt.blogspot.com/2011/01/cascading-date-range-parameters.html
Thursday, January 27, 2011. Cascading Date Range Parameters. I've written about date range parameters in an earlier post. In that post. So using the technique described in the earlier post, I made two data sets, one called begin date and one called end date. Begin date has a query like:. Select distinct convert(datetime, convert(varchar,dateadd(day,-datepart(day,ae s fnd a.tranx date) 1,ae s fnd a.tranx date), 101) as starting date,. From ae s fnd a. End date has a query like:. From ae s fnd a. I'm the D...
aimbirt.blogspot.com
Birt and AiM: August 2010
http://aimbirt.blogspot.com/2010_08_01_archive.html
Tuesday, August 10, 2010. Nice looking Percents on Mouse-Over Chart Interactivity in Birt. If you're incorporating a mouse-over interactive feature in a Birt Chart and your data point is a percent, the resulting data flash can look sort of ugly (like 0.021200). You can control this by editing the format of the tooltip text. A = row["PERCENT CLOSED"]. A = a '%'. Saturday, August 7, 2010. Interactive Birt Chart Output Formats - Which one do you use? The other feature that I really like is hyperlink. Yo...
aimbirt.blogspot.com
Birt and AiM: Removing Hyperlinks from null values in a Birt Cross Tab
http://aimbirt.blogspot.com/2011/03/removing-hyperlinks-from-null-values-in.html
Friday, March 18, 2011. Removing Hyperlinks from null values in a Birt Cross Tab. When you use dynamic hyperlinks from a cross tab that has some null values in the cells, with a slight javascript modification to your hyperlink, you can hide all the little blue underscores in the cells with no values. If (data["count Building/bldg Work Code/craft code"]! Null) {"https:/ gwuapp.assetworks.com/fmax/screen/SC BROWSE? AeSCtrE.contractor=" data["contractor"] "&aeSCtrE.statusCode=" data["status code"]"}.
aimbirt.blogspot.com
Birt and AiM: December 2010
http://aimbirt.blogspot.com/2010_12_01_archive.html
Tuesday, December 21, 2010. Hyperlink to a new email off Birt Report. I made a series of contact list reports off the Human Resources module for use as a phone/email directory and I wanted to make the email addresses hyperlinked so that the default email application would start an email when the address was clicked off the report. Make a text field in the email column of your table. Set type to html. Monday, December 20, 2010. Creating Birt Sub-Reports Using Dataset Parameter Binding. Then go to your inv...
aimbirt.blogspot.com
Birt and AiM: July 2010
http://aimbirt.blogspot.com/2010_07_01_archive.html
Friday, July 9, 2010. Display Report Elements Based on Parameter Selection. Extending the capabilities described in my last post. You can also allow the user to decide whether to display report elements at run time. Create a parameter with static values of Y and N (with display values of Yes and No). Then in visibility select hide element for html and then use the expression builder to reference the parameter. If your parameter is something like 'Show Transaction Detail? Hiding elements with parameter.
