Report without records, only headings!!!

[bhecht]

I have set up a form that allows the user to create a CV with different headings etc, I have managed to set it so it creates a report with the headings and records, but at the top it places the headings as just the field names, without showing the actual data.

How do i fix this?

 

[mark curtis]

This sounds like a sorting and grouping problem.

If you wish to set the report to print out like it looks on the form then you need to lay the report out to look like the form does.

Also

If you wish to print out on a separete page for each person then force new page after footer.

If you want any more help zip up the db and I'll look at it.

 

[bhecht]

Thanks

I emailed you through the system, i hope it worked.
The file is on
http://www.btinternet.com/~dodo/boaz/project.zip

Thank you very much for your help
Boaz

 

[Rich]

You need to compact your db and zip it, then you can post it here

 

[Fornatian]

Could it be that you've set the Caption property of a Label control to the field name and not the control source of a textbox.

 

[bhecht]

I zipped it, but it's still 7megs

I can't upload it as it's too big, and i've already compressed it.

I uploaded it online anyway on http://www.btinternet.com/~dodo/boaz/project.zip

Thanks
Boaz

 

[mark curtis]

I have looked at the db and I think you need to define the reports(the data you want to show) and provide a little background on why so many tables are required. I can then look at creating an example for you.

Spec out a report and the fields you want to see on it.

 

[bhecht]

Thanks

I am basically interested in a report containing the fields in
Tables:

tbl_step 1 (if q1_employment is ticked then also tbl_q1, AND if q5_land_property is ticked then also table q5)
tbl_q10
tbl_q11


The project is meant to demonstrate constraints, so the reason there are so many other tables, is to demonstrate the possibility of just creating forms for them, because they have the same constraints as q1, 5, 10 and 11 and i therefore didn't just duplicate them in order to save time.

Perhaps you might be able to tell me why the forms lose the data when you close them. It is obviously really important and i don't know why it's happening, as it appears that the relationships are correct. (see attached ERD).

Thank you very much for you help.
Best Regards
Boaz

 

[bhecht]

Second report

I also need to create a report for tables:
Programmer Mode and CVpersonal details.

The report needs to be with personal details at the top,
and the headings, and contents in order given.

I tried doing this and i could only get rpt_CV which only has the headings, but not the actual personal details at the top.

Thank

Boaz