month

[raadwiptec]

hi all,

I have a chart which needs to display only the previous months data based on a specific column transaction date.

whenever reopen the chart it shows current month. can I change it to previous month

suggest?

[raadwiptec]

Hi all,

Iam using a report with following data

transid ¦ custname ¦ billing date

1              xxx1          12/12/2015

2              xxx2          11/12/2015

3              xxx3          10/12/2015

4              xxx4          09/11/2015

5              xxx5          08/10/2015

My first problem is I have a Year and Month List box. So whenever I open the report fresh. it shows 2016 and chart shows empty as their is no data for 2016. So I want to make it always all data visible.  I tried to activate clear all.. it does not work..

secondly I am calling this report via nprinting. and would like to limit the data only to last month before sending to the user. I tried couple of option with billing date as mont(now() -1 ...et etc but it is not filtering

[HirisH_V7]

Hi ,

In your back end ,

     Num(Month([billing date])) as Month,

In Front end Report,

Expression:

   =Sum({<Month={'$(=Max(Month)-1)'}>}Sales)

Change expression As per your Requirement.

Hope this Helps,

Regards

Hirish

[MayilVahanan]

HI

Is billing date has 2016 year data?

[raadwiptec]

hi mayil

yes

[HirisH_V7]

Hi,

Means you need to get Dec data right ,when you open sheet or what ,

For activate sheet action you can keep,

->Select in field, Month , Search String   = '>=' & $(=Month(Today())-1)

->On leave sheet Clear All

Or else,

the above post of mine.

HTH,

Hirish