Select Previous month and current month to date

[nosajld]

Greetings -

I need a formula (not sql) so I can select all records by date from the previous month and also all records for the current month to date.

Thank you for any assistance you provide!

Jason

 

[nosajld]

oh - and using CR XI.

Thank you!

 

[lbass]

{table.date} in minimum(lastfullmonth) to currentdate

-LB

 

[nosajld]

I'll need these two broken out though so will

{table.date} in minimum(lastfullmonth)

{table.date} in minimum(currentdate)

work?

I need all the data from the previous month. Then all the data from the current month to date.

Thank you again!

 

[lbass]

No, use the selection formula I gave you. Then you can group on {table.date}->print on change of month. Or insert a crosstab that uses {table.date} as the column->group options->print on change of month.

-LB

 

[nosajld]

Hmmm - not sure if that will work when I'm doing the summary though? I'm working on two reports a detailed report and a summary report.

 

[lbass]

I am unclear what you see as the issue. Why don't you show a little mockup of the report you want to see.

-LB

 

[nosajld]

The report is pulling phone call information from our local ShoreTel DB. So what I have currently is a report that will only show one period and I am working to have it show current month compared to previous month.

Somethign like this is what I have

Call summary report for Smith, John (2218)

Current Month Previous Month
October September

Total Incoming: 54 37
Total Outgoing: 23 45
Total Transfered: 12 07

Then I have a graph shown below with the data from above.

So the numbers above are a sum of the data in a group section pulling from the call.connect table.

Hope this helps and thank you again!

 

[lbass]

So you have a group on employee, right? You can insert a crosstab in the group header or group footer that uses the datefield as the column. While it is selected in the crosstab expert->click on "group options" and choose "print for each month". Then add the three summaries as your summary fields. Then click on the Customize Style tab->check summary fields->"show labels".

Insert a second group header (GH1b) or footer section (GF1b) for the graph.

-LB