Kinamu Reporter Help Needed

[chris.marsden]

Hi Guys,

I need a little help with a report i am trying to create.

I want to output a selected number of days.

ie - account created on 12/12/2011called Mr Smith, i want to output this account and any other new accounts for the previous calender week.

it this possible?

[christianknoll]

(1) create a report for accounts
(2) select date created as select field and the operator within the last n days specifying the number of days you want to go back
(3) drag what ever fields you are looking for to the display fields.
(4) save the report and be happy

christian.

Hi Guys,

I need a little help with a report i am trying to create.

I want to output a selected number of days.

ie - account created on 12/12/2011called Mr Smith, i want to output this account and any other new accounts for the previous calender week.

it this possible?

[chris.marsden]

Ignore
≠
before
after
is between
current month
within the next 3 month
last month
within the last 3 month
this year
last year
is empty
is empty or NULL
is NULL
is not empty

above are the only control variables i have available.

[christianknoll]

Seems we added the days in 2.7 .. so you will need to take the before operator and select a date in the 2.6 basic edition.

Christian.

Ignore
≠
before
after
is between
current month
within the next 3 month
last month
within the last 3 month
this year
last year
is empty
is empty or NULL
is NULL
is not empty

above are the only control variables i have available.

[chris.marsden]

is there not a way I can program these functions in the code?

[christianknoll]

Updating the core code of the reporter is of course doable but this is not that easy.

The other thing you can easily do is to define a KReporter Field that holds the number of days (simple SQL doing a diff and then returning days) and then use that field for selection, sorting, etc. Look into the documetnation and find how to define KReporter Fields.

regards, christian.

is there not a way I can program these functions in the code?