Report - Print when condition is met (finding the next date)

[keepingbusy]

Hi

I have a table, part of which contains 16 date fields used for Due visits and Date visit complete. An example of the table names are FADATE01, FADATE01PR etc. These are used to record the actual date a visit is due and other fields such as FADATE01PR, FADATE02PR etc are used when the visit is actually made.

When visits are completed, it allows a report to be created showing date of visits and actual visit. This isn’t a problem as the fields are shown on a report using:

NOT EMPTY(FADATE01) AND FADATE01<mdatefrom AND NOT EMPTY(FADATE01PR)

I have been racking my brains for a few days on the problem I’m trying to resolve and that is I need to add another column on the report that shows the next date due.

Here is a scenario:

FADATE01 could be 01/03/2007 and FADATE01PR could be 18/03/2007

The next due date could be contained in FADATE02 but if my condition is showing FADATE03 then the next would be FADATE04 or if FADTE04 was showing it would revert back to FADATE01

How do I find out which field meets the condition so I can add the next one to the report?

Hope that makes sense guys and thanks in anticipation.

Version used VFP6 and mdatefrom=DATE()


Lee

Windows XP
Visual FoxPro Version 6 & 9

http://www.customsoftware.co.uk

 

[dgrewe]

I would place all the fields that need to be printed on the form and if only 1 of 3 field could print at one time I would place them all on the exact same place on the form.

In all 3 fields, That print in the same place, Propertys tab "Print When"
On the Print when line you can do
IIF(!EMPTY(date1),date1,IIF(!EMPTY(date2),date2,IIF(........))))

 

[keepingbusy]

DWGrewe

Thank you for the quick response.

I'll try that and post back.

Lee

Windows XP
Visual FoxPro Version 6 & 9

http://www.customsoftware.co.uk

 

[keepingbusy]

DWGrewe

Tried this line:

IIF(!EMPTY(fadate01),fadate01,IIF(!EMPTY(fadate02),fadate02,IIF(!EMPTY(fadate03),fadate03,IIF(!EMPTY(fadate04),fadate04))))

and I'm getting an error message "Missing comma (,)"

I'm sure this must be a typo somewhere.

Lee

 

[r0gerc]

Lee

I may be wrong, but Immediately after the final'fadate04' I think there should be a comma plus whatever you wish to print if fadate04 IS empty. Nested IIFs always give me trouble too, but it's all part of the fun isn't it!

Roger

 

[keepingbusy]

Hi Roger

I'll try that

Lee

Windows XP
Visual FoxPro Version 6 & 9

http://www.customsoftware.co.uk

 

[keepingbusy]

All,

I was able to resolve this issue by adding two new date fields to a form. This gave us a date from and date to and also advance dates from and two. This in turn allowed us to set a condition which was placed in the Print When of the report:

not empty(FADATE01) and empty(FADATE01PR) and between(FADATE01,mnextfrom,mnextto)

As DWGrewe suggested, all the relevant fields were added to the report and the subsequent Print When commands were changed accordingly e.g.

not empty(FADATE02) and empty(FADATE02PR) and between(FADATE02,mnextfrom,mnextto)
not empty(FADATE03) and empty(FADATE03PR) and between(FADATE03,mnextfrom,mnextto)

etc...

Thanks to all on this post for the suggestions (and inspiration!)

Lee

Windows XP
Visual FoxPro Version 6 & 9

http://www.customsoftware.co.uk