Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Filtering crosstab data by dates(crosstab filter)
Filtering crosstab data by dates [message #882087] Tue, 05 June 2012 20:29 Go to next message
Shayne Paddock is currently offline Shayne Paddock
Messages: 9
Registered: December 2009
Junior Member
I have a dataset that returns values for the past year. I create a last 12 month crosstab based on that.

I also want to show the last 12 weeks of values as well using the same dataset as above. I've set up my dimensions to be year and week of year. How do I only return the last 12 weeks of data for that particular crosstab?

I'm running BIRT 3.7.1

Kindest regards,
Shayne
Re: Filtering crosstab data by dates [message #882140 is a reply to message #882087] Tue, 05 June 2012 23:21 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Have you tried using a filter on the crosstab that make use of:
BirtDateTime.addWeek()

Use your date field as the expression and then use a between operator
and then the first value should be :
BirtDateTime.addWeek(new Date, -12) and the second value should be
new Date

Jason


On 6/5/2012 4:29 PM, Shayne Paddock wrote:
> I have a dataset that returns values for the past year. I create a last
> 12 month crosstab based on that.
>
> I also want to show the last 12 weeks of values as well using the same
> dataset as above. I've set up my dimensions to be year and week of year.
> How do I only return the last 12 weeks of data for that particular
> crosstab?
>
> I'm running BIRT 3.7.1
>
> Kindest regards,
> Shayne
>
Re: Filtering crosstab data by dates [message #882476 is a reply to message #882140] Wed, 06 June 2012 14:27 Go to previous messageGo to next message
Shayne Paddock is currently offline Shayne Paddock
Messages: 9
Registered: December 2009
Junior Member
it doesn't seem like I have access to the date field from the dataset in the crosstab filter area. I can filter based on dimensions which are year and week of year. Is there a way to get access to filter on the date in the data set?

Kindest regards,
Shayne
Re: Filtering crosstab data by dates [message #882668 is a reply to message #882476] Thu, 07 June 2012 00:06 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Shayne

Take a look at the attached example. You also could make use of the new
relative time period report item described in this post:
http://birtworld.blogspot.com/2012/03/birt-372-new-features.html

Jason

On 6/6/2012 10:27 AM, Shayne Paddock wrote:
> it doesn't seem like I have access to the date field from the dataset in
> the crosstab filter area. I can filter based on dimensions which are
> year and week of year. Is there a way to get access to filter on the
> date in the data set?
>
> Kindest regards,
> Shayne
Previous Topic:Problem with namespace on web service parameters
Next Topic:a ReportServiceException while running the report using BIRT Viewer 3.7.1
Goto Forum:
  


Current Time: Tue Sep 30 11:51:14 GMT 2014

Powered by FUDForum. Page generated in 0.02161 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software