Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » 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 PaddockFriend
Messages: 11
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

Report message to a moderator

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

Report message to a moderator

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 PaddockFriend
Messages: 11
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

Report message to a moderator

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

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 15:54:39 GMT 2024

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

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

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly