Eclipse Community Forums: BIRT » Providing "missing" rows via scripted dataset

Home » Archived » BIRT » Providing "missing" rows via scripted dataset

Providing "missing" rows via scripted dataset [message #171432]

Mon, 19 June 2006 12:06

Eclipse User

Originally posted by: dave.gross.logiclibrary.com

I would like to create a report that displays monthly cumulative totals. I
want a row (or line in a chart) for every month of the year. The problem
is, I do not have a row for every month in my dataset. I would like to
"fill in" the missing rows programmatically.

Is there a way to add the missing rows by scripting an existing dataset by
say keeping a current month counter and returning a fake row if the current
row is missing?

Thanks,
-- Dave

Re: Providing "missing" rows via scripted dataset [message #171446 is a reply to message #171432]

Mon, 19 June 2006 20:54

Eclipse User

There is no direct way of adding rows to an ODA data set. Just off the top
of my head, there may be a way to achieve this using a joint data set. You
will need to first define a Scripted Data Set which outputs a single Month
column with the complete series of months you want. Then create a joint data
set to LEFT OUTER JOIN the script data set with your ODA data set using the
Month field as the key.
--
Gary Xue
Actuate Corporation - Product Development
BIRT Committer

"Dave Gross" <dave.gross@logiclibrary.com> wrote in message
news:e76i2c$t3h$1@utils.eclipse.org...
> I would like to create a report that displays monthly cumulative totals.
I
> want a row (or line in a chart) for every month of the year. The problem
> is, I do not have a row for every month in my dataset. I would like to
> "fill in" the missing rows programmatically.
>
> Is there a way to add the missing rows by scripting an existing dataset by
> say keeping a current month counter and returning a fake row if the
current
> row is missing?
>
> Thanks,
> -- Dave
>
>
>

Previous Topic:	Problem with Javascript
Next Topic:	DataSet exception

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Jul 18 01:40:16 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter