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

Help

Home

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

Show: Today's Messages :: Show Polls :: Message Navigator

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

Mon, 19 June 2006 16: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

Report message to a moderator

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

Tue, 20 June 2006 00:54

Gary Xue

Messages: 193
Registered: July 2009

Senior Member

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
>
>
>

Report message to a moderator

Previous Topic:	Problem with Javascript
Next Topic:	DataSet exception

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 01 00:10:29 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter