Dummy Form

[davidv43]

I have a patient database which has several forms. On any given clinic visit, I would like to print out a form which is the same as the data entry form which I have in A5. Ideally, I would print a form with information frmo the parent table in the header of the form, but then pring only the field labels and a blank to fill in for the fields which will be captured on this office visit. I want to print out this form with the appropriate blanks for each patient in that clinic.

Is there a simple way to copy a form to a report, basing it on the parent table and leave blanks for the child table fields?

Thank you!

Dave

[Al Buchholz]

Re: Dummy Form

I have a patient database which has several forms. On any given clinic visit, I would like to print out a form which is the same as the data entry form which I have in A5. Ideally, I would print a form with information frmo the parent table in the header of the form, but then pring only the field labels and a blank to fill in for the fields which will be captured on this office visit. I want to print out this form with the appropriate blanks for each patient in that clinic.

Is there a simple way to copy a form to a report, basing it on the parent table and leave blanks for the child table fields?

Thank you!

Dave

The first thought that comes to mind is to make another set with the same tables, but change the linkages to the child tables so no data is ever found in the child tables.

Then copy the report to that set and you should get the desired effect.

I would make the name of that report to include the idea that all child records are left behind. (pun intended)

If you make a change to the original report, all you have to do is copy from original to the new one.

[davidv43]

Re: Dummy Form

Al, thank you. I thought about this, but the set contains four tables and there are 4 forms, each with 3 different child tables. You can see that soon, the number of dummy tables will be large.

Would be nice to find some more elegant way to do it.

Dave

[Al Buchholz]

Re: Dummy Form

Al, thank you. I thought about this, but the set contains four tables and there are 4 forms, each with 3 different child tables. You can see that soon, the number of dummy tables will be large.

Would be nice to find some more elegant way to do it.

Dave

I still see one new set and 4 reports.

But to do it more elegantly, you can use the OnPrintInit event and set

topparent:<YourFieldObjectName>.Object.Visible = .f.

for the data object

I'd pass a variable(shared/global) saying if you want to see these objects and set the properties accordingly.

ps - using the object explorer is very helpful


Edit:
David

or better yet create a calc field
blank_value = ""

and use this code in the OnPrintInit
topparent:<YourFieldObjectName>.Entry.Name ="CALC->blank_value"

then all of the other properties still show... - borders.....

John - Thanks for the import portion - got caught up in the other part and forgot to include it.. That is a nifty way to move from a form to a report....

[John Lemisch]

Re: Dummy Form

I have a patient database which has several forms. On any given clinic visit, I would like to print out a form which is the same as the data entry form which I have in A5. Ideally, I would print a form with information frmo the parent table in the header of the form, but then pring only the field labels and a blank to fill in for the fields which will be captured on this office visit. I want to print out this form with the appropriate blanks for each patient in that clinic.

Is there a simple way to copy a form to a report, basing it on the parent table and leave blanks for the child table fields?

Thank you!

Dave

1. create a new report based on the set
2. choose create a blank report
3. go to the detail section and choose (from the menu)
report, import, form
4. import your form and make any adjustments
5. remove/adjust the child info by changing the fields to lines or frames
to be filled in. Now, save the report
Note: we often do this type of thing for our clients and usually provide
an xdialog box for them to select which report to print