Eclipse Community Forums: BIRT » Filtering crosstab data by dates

Help

Home

Home » Eclipse Projects » BIRT » Filtering crosstab data by dates(crosstab filter)

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

Filtering crosstab data by dates [message #882087]

Tue, 05 June 2012 16:29

Shayne Paddock
Messages: 7
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 19:21

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
>

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: Filtering crosstab data by dates [message #882476 is a reply to message #882140]

Wed, 06 June 2012 10:27

Shayne Paddock
Messages: 7
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]

Wed, 06 June 2012 20:06

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

Attachment: crosstabtrailingweeks.zip
(Size: 5.61KB, Downloaded 41 times)

Jason Weathersby

BIRT Exchange

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 22 21:09:40 EDT 2013