VFP 6 - Grid on Report Form

[button71]

Is it possible to show a list of a tables records in a grid on a Report form?

I don't see a grid control in the Report Tools.

I am converting an Access app to VFP and in Access have used subforms.


Thanks

William

 

[DSummZZZ]

Well, report forms are nothing more than table's records in the first place. You can draw lines wherever you want them if you want it to look like a grid.
But no. There no grid control to just dump on a report. Just add the fields you need.


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[white605]

Add a table to your data enviornment and put the fields you want to display in the detail band of the report. If you need to use the grouping bands to show grouped records.

 

[button71]

Thanks Guys,

I bit more information.

The report is one of a number of report forms with the answers to the questions held in fields of a table(s) printed onto a background image on the report.

Some have multiple rows of possible anwers - like - list all places you have lived in.

I have a related table with the records of places in n number of rows.

Hence the need for a grid-like list.

A seperate list can be used if there are too many rows for the form.

----------

I have my form image with appropriate fields in the detail area - works as expected.

I have tried with the second table only in the detail area and that works as expected.

How can I have two detail areas - one for each table?

Is this what was meant by 'grouping'?

Thanks

William.

 

[alvechurchdata]

Some have multiple rows of possible anwers - like - list all places you have lived in.

I have a related table with the records of places in n number of rows.

Fox doesn't have sub-reports like Access. All that the report will do is present the information in a table and your best way forward is to write a query which joins the master and child tables into a single flat table. Typically you then group the report on the primary key of the master table. This gives you a Group Header and a Group Footer above and below each Detail band. Put the information from the master table in the Header and any group summary in the footer. Put the data from the child table in the Detail band.

How can I have two detail areas - one for each table?

Multiple detail bands were introduced in VFP 9. Which version are you using?

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[DSummZZZ]

Actually, VFP 9 is supposed to be able to use child tables rather than only one table. I haven't used that functionality yet, but I've seen a couple write-ups on doing it.


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[button71]

Thanks guys,

I'll try Geoffs suggestion first but it looks like the upgrade to 9 is getting closer.

William

 

[button71]

Well,

I went to VFP 9 for this project, used two detail bands,and everything looks sweet in the reports area again at first viewing. Multi detail bands work fine.

Thanks to you all.

William