Filtering output in a report builder report

Getting your data onto paper - or the web - Discussing the reports features of Base

Filtering output in a report builder report

Postby chedderslam » Mon Sep 08, 2008 8:02 pm

Right now my report outputs all of the records in the database. I would like to only display the results from the last 7 days. How would I do this?

Thank you.
OOo 2.4.X on MS Windows Vista
chedderslam
 
Posts: 15
Joined: Mon Aug 18, 2008 4:42 pm

Re: filtering output in a report builder report

Postby QuazzieEvil » Thu Sep 11, 2008 4:33 pm

either base your report on a query or SQL command. in either case, use the DateDiff function. the assumption is that you have a date column that determines the age of the record.

in the query builder enter something along the lines of DateDiff('dd',"INVOICEDATE",CurDate() ) as the Field, and type <7 as the criterion for that column. In this case INVOICEDATE is the name of my date column.
QuazzieEvil
Volunteer
 
Posts: 283
Joined: Tue Dec 04, 2007 6:38 pm
Location: Houston, TX

Re: Filtering output in a report builder report

Postby chedderslam » Fri Sep 12, 2008 3:54 pm

Thank you for the help. I will give it a try.
OOo 2.4.X on MS Windows Vista
chedderslam
 
Posts: 15
Joined: Mon Aug 18, 2008 4:42 pm


Return to Reporting

Who is online

Users browsing this forum: No registered users and 1 guest