Printing from Calendar

[Keith Hubert]

Hi All

This is the form: It is a calendar with a child browse; on the form is a print button that asks for a date to print a report for all the items on that date. What I would like to be able to do is use the Date that has already been selected on the calendar and use that date as the veriable in the data selection for the report automatically. This would keep the whole thing mouse operated. All help greatfully appreciated.

Keith Hubert
London

[Stan Mathews]

RE: Printing from Calendar

"Date that has already been selected on the calendar" - What is "behind" the date being selected on the form? Is a parent record field?

You should be able to create a form veriable (variable?) global or session, have your print button make the variable assignment based on the value of that field, then use the variable in the report filter.

[Keith Hubert]

RE: Printing from Calendar

Stan

Thanks for your reply.

The form VARIABLE that I have is as follows: Level; Session, Name; Showdate, Type;D, Value / /. The script for the print button that I have for the moment is:

dim global GDATE as D
GDATE=ctod(UI_GET_DATE("Date Selection","Enter Schedule Date:"))
if dtoc(GDATE)="" THEN
END
end if
Report.preview("Schedule")
goto cleanup
cleanup:
end

Could you please tell me how to use the variable, instead of the UI_GET_DATE.

Thanks for your help.

Keith Hubert
London.

[Stan Mathews]

RE: Printing from Calendar

I still have the same question. What determines the "currently selected" date on the form?

How does the user select a date on the form?

You could put your variable on the form and have the user enter a value, then your print button could refer to

showdate = :yourformname:yourfieldname.value

As I understand it this is not what you want. You want the user to be able to click on a date and have showdate reference the "active" date. What type of object are they clicking?

Stan

[crimmelcp]

RE: Printing from Calendar

Keith:
Can you zip up the app and post it on the board.
maybe we can help more if we could see the forms.
Charlie Crimmel

[Keith Hubert]

RE: Printing from Calendar

Hi Stan

I think you have understood exactly what I am trying to do.

The button I am clicking on, is the calendar created by Michael Pesach. The report has a filter which at the moment works with the variable GDATE. This ofcourse can be changed.
Please let me know if you need any more info.

Keith Hubert
London.

[Stan Mathews]

RE: Printing from Calendar

Keith,

I took a look at the docs for the calendar as presented on learn alpha and found:

Showdate: This is the current focus date of the calendar. It is supposed to be global but you indicate it is session.

All you should need to do is:

dim global GDATE as D
GDATE = showdate
if dtoc(GDATE)="" THEN
END
end if
Report.preview("Schedule")
goto cleanup
cleanup:
end

Unless I'm missing something, which would not be unusual.

[Keith Hubert]

RE: Printing from Calendar

Thanks for help.

I changed the variable to Global and the script as follows.

dim global GDATE as D
GDATE=ctod("+showdate+")
if dtoc(GDATE)="" THEN
END
end if
Report.preview("Schedule2")
goto cleanup
cleanup:
end

It does just what I wanted. Thanks again.

Keith Hubert
London.