Report Date paramaters 1

[timbaktuu]

Hello Everyone,

I need to run the reports for specified interval.
The parameter should look something like this after deploying:

A)daily for interval 7:00 AM to 8:00 PM every 15 minutes

B)Monthly for interval 12:00 PM to 11:45 AM every 15 minutes

I have the start date and end date Parameters for my report. How should I write the expression for this?

Please advise. Thank you.

 

[lbass]

So you will be running the report each day for the daily interval? The monthly interval is confusing--is this being run once a month? Then how does the "every 15 minutes" fit in? I think you should show an example of report results for each scenario.

Also, please clarify what you are having trouble with.

-LB

 

[timbaktuu]

Thanks lb for ur reply. Sorry that 15 min thing does not apply to mmonthly report. It was a typo.
I m unable to show the results right now. But the example would be for today between 7 to 8 pm, whenver anyone runs the report, it should be for the last 15 min. I hope I m clear this. Time. Thanks again

 

[lbass]

{table.datetime} in dateadd("n",-15, currentdatetime) to currentdatetime and
{table.datetime} in datetime(currentdate,time(6,45,0)) to datetime(currentdate,time(20,0,0))

You would have to allow in the 15 minutes prior to 7AM so that the 7AM values are correct for the previous 15 minutes. To eliminate the values prior to 7AM from the display you could use group selection where you display results only for:

{table.datetime} >= datetime(currentdate,time(7,0,0))

Still not sure what you would want to happen for the monthly one.

-LB

 

[timbaktuu]

Thank you LB. That looks good. I will try that.

For the monthly report, I think I may have to check again.

 

[timbaktuu]

The monthly report should show the data for last month.
IF I run it today then it should show 12/1/2010 00:00:00 to 1/1/2011 00:00:00

Also I have a daily report that if I run it today, should show 1/24/2011 00:00:00 to 1/25/2011 00:00:00.

Please let me know. Thanks.

 

[lbass]

You can use:

{table.datetime} in lastfullmonth

For yesterday, you would use:

{table.datetime} = currentdate-1

Note that these would show data up through the last second before midnight, but not including the ending midnight.

-LB

 

[timbaktuu]

Thank you LB. I removed the start date end date report parameters and used record selection formula for the same.

A) for the daily every 15 min one, some how it did not show the data for last 15 min while there was data in the system. I m still checking if something is supressed, so far nothing..

B) On the monthly report I have to show the period the report ran for like 1/1/2010 00:00:00 to 1/1/2011 00:00:00. I was able to do the period thing for daily report by breaking ;

dateadd("n",-15, currentdatetime) to currentdatetime into 2 formulas and placing 'em on report. How can I do the same thing for the monthly report, will that be;

DateAdd( 'm', -1 , {table.Date} ) to currentdatetime ?

Thanks a ton for your help!!!