asked on

Report Modifiction

I need to make the following changes:

NORMAL section:

1. Change the group name "NORMAL" comes from the database . . but I would like that formatted to say "MOVEDIN"

So if NORMAL >> DISPLAY the text "MOVEDIN"

2. Ignore the MOVEDOUT text when group is NORMAL

Past section group:

1. Ignore the MOVEDIN date

Finally I would to be able to INSERT the count of the moved in and moved on top the group section.

Can someone help me with these quick fixes?
Moveinout30day.rpt

James0628

As I understand it, you want to:

1) Change the displayed group name.
Easy. Create a formula that displays the desired values and put that in the group header.

2) Do not display the text field that says "Moveout" (or the move out date) for the "Normal" records.
Easy. Right-click on each of those report fields and select "Format Text" (or "Format Field"). On the Common tab, click the formula (X+2) button to the right of Suppress and enter this formula:
{viewLeaseStats.StatusName} = "Normal"

3) Do not display the text field that says "Movein", or the move in date, for the "Past" records.
Same basic process as #2. Add this suppression formula to the move in fields:
{viewLeaseStats.StatusName} = "Past"

4) Show a record count in the group header.
Easy. The "problem" with your counts is that they're running totals, which are calculated as the records are read, so they won't be correct in the group header. But you can just use a regular count summary. Right-click on StatusName (or any field) and select Insert > Summary. Select a Count summary, and make it for the group (not a grand total). CR will insert the count in the group footer, but you can just drag&drop it in the group header.

I'm attaching a copy of your report with all of those changes. Your old group name and count fields are still there, but I added a groupname formula that displays the modified name (you can change that formula to say whatever you want), and a count in the group header. And I added suppression formulas to the move in and out fields. All of the fields that I added or changed are in green.

James
Moveinout30day-J.rpt

Starquest321

ASKER

James - perfect!

Now one more quick fix: For the moveout group it's important for us to know if the tenant stayed LESS THAN 6 MONTH.
Can you make it so you subtract the date Move IN - Move OUT ...if less than 6 MONTH PUT TEXT : ---> TENANT LESS THAN 6 MONTH!

Much much appreciated!

James0628

How do you define 6 months?

Literally 6 calendar months? For example, 01/03 to 07/03 is 6 months, but 01/03 to 07/02 is not?

180 days?

180 days is simpler, so I'll start with that. :-)

Create a new formula (under "Formula Fields" in the "Field Explorer") like this:

if not IsNull ({viewLeaseStats.MoveOutDate}) and
not IsNull ({viewLeaseStats.MoveInDate}) and
{viewLeaseStats.MoveOutDate} - {viewLeaseStats.MoveInDate} < 180 then
"TENANT LESS THAN 6 MONTH!"

Subtracting one date from another gives you the difference in days.
Change the message to say whatever you want.
Put that formula in the detail section.

It looked like some of the dates in your sample data were null, and those can cause problems in formulas like this, so I included IsNull tests to make sure that neither field is null before it does the subtraction.

James

SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

James0628

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial