Calendar view in Birt
I have asked to create a Foward Schedule of Change using Birt 2.2.1.1.
What my boss wants is a Calendar view for a month (like in Outlook) that per calendar day shows which Changes are due to implemented on that day.
I can create the data sets I need but am having difficulty creating something that resembles a Calendar view.
I have created a crosstab that creates a view for a month that looks like a calendar linked to one data set. I now need to display data from another dataset and using the groups of the crosstab as filters. To do this I have inserted a list in the crosstab summary field and link this to a different dataset. I then use the date value from the crosstab as a filter on the list. However when I run the report I get a Birt error :
ReportDesign (id = 1):
+ The filter definition using expression "row["start_date"]" is not valid.
A BIRT exception occurred: Error evaluating Javascript expression. Script engine error: TypeError: Cannot read property "report_date" from null
Script source: source, line: 0, text:
data._outer["report_date"]. See next exception for more information.
Error evaluating Javascript expression. Script engine error: TypeError: Cannot read property "report_date" from null
Script source: source, line: 0, text:
data._outer["report_date"]
Any help with this issue or any ideas on another way to create this type of report in Birt would be greatly appreciated.
What my boss wants is a Calendar view for a month (like in Outlook) that per calendar day shows which Changes are due to implemented on that day.
I can create the data sets I need but am having difficulty creating something that resembles a Calendar view.
I have created a crosstab that creates a view for a month that looks like a calendar linked to one data set. I now need to display data from another dataset and using the groups of the crosstab as filters. To do this I have inserted a list in the crosstab summary field and link this to a different dataset. I then use the date value from the crosstab as a filter on the list. However when I run the report I get a Birt error :
ReportDesign (id = 1):
+ The filter definition using expression "row["start_date"]" is not valid.
A BIRT exception occurred: Error evaluating Javascript expression. Script engine error: TypeError: Cannot read property "report_date" from null
Script source: source, line: 0, text:
data._outer["report_date"]. See next exception for more information.
Error evaluating Javascript expression. Script engine error: TypeError: Cannot read property "report_date" from null
Script source: source, line: 0, text:
data._outer["report_date"]
Any help with this issue or any ideas on another way to create this type of report in Birt would be greatly appreciated.
0
Comments
-
mennovh,
Try this out. I used a series of tables and a grid to create the look of a calendar and a list to filter down which items are "due" on that day. I changed your flat files just a bit so the dates could be brought in as dates, so you'll need to use the new flat files to run this report. Let me know if you have questions.Warning No formatter is installed for the format ipb0
Categories
- All Categories
- 108 Developer Announcements
- 53 Articles
- 107 General Questions
- 144 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 899 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 119 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management