Section Expert supressing groups

[sqw]

Please can someone help. I have a report that runs and generates a list of all calls logged in by a customer. What I want to do is to unsupress a section if the call registered date is older than the previous month. I want this section to be supressed if the call was registered within the last month. I have tried to add a formula into the section expert like ({call date} >lastfullmonth)but that does not work. I think it is a problem with the way my dates are formatted.
Thanks

 

[lbass]

What section are you trying to conditionally suppress? What error message do you get? Please identify the datatype of your date field by running your mouse over it.

-LB

 

[sqw]

Hi
Thanks for the quick feedback
I want to suppress some of the group headers
The data field is a date time field

Let me know if anything else can help
Thanks

 

[lbass]

What is the field you are grouping on? Your formula:

{call date} > lastfullmonth

...is a detail level formula, and would only suppress the group header if the first record in the group met the criterion. So please also explain a little more what you are trying to do.

Is there a reason you cannot eliminate unwanted records from your report in the record selection formula?

-LB

 

[sqw]

In the group header I have address and name of the company and I want this to show all the time. The next group header has all the calls that that company has logged in. What I want to do is always show the first group header now matter what. Then What I want to do is filter all the calls and any show ones that have been registered the previous month. Then if no calls have been logged in that previous month then I want to display "No calls logged". If I start to us the record selection then if there is no calls for that company it doesn't show anything for that company and I want it to show at least the 1st group header.

Hope that gives you a better picture of what I am trying to do.

Thanks for the help

 

[lbass]

Well, you could try using the conditional formula on the detail section.

You should use a table for your company name and address that has a left join TO the table that ocntains the calls, with no selection criteria on the calls table. Then you could create a formula:

if isnull({table.callId}) then "No calls logged" else ""

Place this in a group header section.

-LB

 

[sqw]

Excellent thanks I will try this