report form scenario

[keepingbusy]

Hi

The little hair I have left has almost been pulled out!

Can someone please explain this with the REPO FORM command?

I have a table called DTMG11

Within the table is a field called REFNUMB

The report is a single page type with a memo field called FREETEXT that takes up most of the page therefore there is only one report for each record.

For test purposes I know that the table contains four records, two of which have the reference number 280.

The variable mrefnumb=280 but could be any other number depending on what information is being searched (280 for this example)

When I issue the following it only shows the first of the two records:

REPO FORM mg11 NOCONSOLE PREVIEW FOR REFNUMB=mrefnumb

I have also tried:

REPO FORM mg11 NOCONSOLE PREVIEW WHILE REFNUMB=mrefnumb

I also tried puting this into a DO WHILE... etc without success.

This is quite frustrating and I suspect I'm missing something really easy here.

Please can someone suggest?

Many thanks

Lee

 

[bborissov]

How about:

SELECT YourTable
SET FILTER TO REFNUMB=mrefnumb
GO TOP
REPORT FORM mg11 NOCONSOLE PREVIEW
SET FILTER TO

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[keepingbusy]

Hi Borislav

Tried your suggestion and it only shows the one report as before.

Lee

 

[bborissov]

But how many reports you will want to see?
Did you have DE in that report? If so REMOVE it.

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[keepingbusy]

Perhaps I can explain a little further.

The table mentioned contains statements made by individuals for example one from Steve, John, Dave, Pete etc. These statements will all have a unique reference number (example 280).

What I am trying to is use the mrefnumb variable (or some toher way) to printout all the statements that have the REFNUMB 280 or REFNUMB=mrefnumb

Hope that makes sense.

Lee

 

[bborissov]

SELECT YourTable
SET FILTER TO INLIST(REFNUMB, 280, mrefnumb)
BROWSE NORMAL && How many records you see here?
GO TOP
REPORT FORM mg11 NOCONSOLE PREVIEW
SET FILTER TO

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[keepingbusy]

Hi Borislav

I have to go out for a while, will take a look later and reply back.

Many thanks

Lee

 

[dgrewe]

Question ?
Is the field REFNUMB a Numberic, Integer, Char ?


David W. Grewe Dave

 

[keepingbusy]

Borislav and David

Sorry for the delay in posting back but I have managed to resolve the issue all be it with some old fashion syntax code which I'll post soon.

David: The field is numeric but as mentioned, I've resolved the issue.

Thank you for replying.

Lee