Eclipse Community Forums: BIRT » Filtering crosstab data by dates

Home » Archived » BIRT » Filtering crosstab data by dates(crosstab filter)

Filtering crosstab data by dates [message #882087]

Tue, 05 June 2012 16:29

Eclipse User

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 19:21

Eclipse User

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 10:27

Eclipse User

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]

Wed, 06 June 2012 20:06

Eclipse User

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 354 times)

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

Current Time: Sun Jul 27 09:40:16 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter