Problem with Reports from local view

[GKBray]

Hi all,

I am trying to create a report using a Parameterised Local as a child table replacement.

I keep getting a single line in the detail band, as opposed to the group of records I expect to see.

Any Ideas

G K Bray MCSE(Win2k) Trainee Programmer

 

[mspratt]

Hi G,

When you BROWSE your parameterized view, how many records do you see?

Regards,

Mike

 

[GKBray]

I see all the records if I browse the view, but I don't see them on the printed or previewed report.

I must admit that I have spent all my time trying to learn my way around Fox, and its programming language, but I have spent VERY little time with the Report writer.

So, I am very lost indeed, without the Wizard.

I don't understand Data Grouping, and I wonder if this is the problem.

Many thanks

Graham

G K Bray MCSE(Win2k) Trainee Programmer

 

[mspratt]

Hi Graham,

If you are using the detail band you should see all available records there. Are you opening the view manually or using the reports DE?

Never tried it, but I suspect you could issue a BROWSE in the reports DE init to see what data it sees.

Regards,

Mike

 

[jimstarr]

Hi Graham,

My guess is that your view definition is causing the report to see the child record(s) for only the CURRENT parent. I'd recommend forgetting about the view and do one of the following:

1. Use SET RELATION to link the tables.

2. Combine the parent and child tables into one cursor prior to the report using SELECT - SQL. This makes the report very straightforward.

3. Use the One-To-Many Report Wizard.

Jim