Is it possible to add a new last row to table or dataset?

Hi all,

I have a chart that looks like the upper one of the attached images. In the second I added manually blue lines and this is what I try to get with BIRT. The min/max-values of the x-axis are scripted and defined by two parameters. The y-values of the series are aggregated with a running-sum-function and end with the last date in the table/dataset. But between the last date and today I need this horizontal blue lines from the second image although there happens nothing. My idea is to add in the date-column of the table/dataset a new last row with the date of today. So the running count will count on till today I guess. But how can I script this additional row. Or someone has a better idea?

Thanks

Find more posts tagged with

Comments

mwilliams

Hi doublehawk,

You could have a scripted dataSet that has all the dates in your range up til today and do a join to get all the dates in there.

doublehawk

Hi Michael,

this problem is solved with the scripted dataset and a join like you proposed me. I generated a scipted dataset just with the date of today and made a outer join with the date-column. After this I filled a computed column to get both values in one column. Is this what you meant? But i have another question. Is it possible to set the default-values of the parameters, which gets the min/max-values for the x-axis, to the lowest and highest value of the datasets date-column? Birt-Version 2.51

Thanks for response

mwilliams

doublehawk,

I'm not sure I understand completely your new question. How are the dates in the report determined? By user input? Or is there a default range? The scripted dataSet was meant to have all the dates in the range and past the range in your report so that they would all be represented on the axis for sure. No need to set a min/max if you have all the dates. Then you could create a computed column to fill in values for the dates that are not included in the original range.

doublehawk

Hi Michael,

the dates in the report are determined by user input. Maybe you have a look at the attached design-file. The design is nearly done.There are two list-parameters (startdate and enddate) getting default values from a date-column. But it should not be possible that can be choosen that the enddate is temporal earlier than the startdate. I thought about a cascading parameter but I dont know how to solve this in my design.

Thanks for your response

mwilliams

doublehawk,<br />
<br />
You can do some parameter validation script to check for the enddate being before the startdate which will stop the report from running. There is a standard pop up error that would be triggered if you use the validation script section. If you want to handle your own parameters how you'd like, you can create your own parameter page. See the following devShare post:<br />
<br />
<a class='bbc_url' href='http://www.birt-exchange.org/devshare/deploying-birt-reports/298-2-2-birt-tag-library/#description'>2.2 BIRT Tag Library - Tips & Tricks - BIRT Exchange</a>