Report help?

Hi there

I was wondering if any ones can help.

What will be the report builder expression in vfp to access a single FieldList (text2) from table (mms) where the condision equals to (field="02")

I tried using: SELECT text2 FROM mms WHERE fileid="02" in the command runner in vfp and it gave me the correct result.

But when i copied n pasted it in report builder as an expression it gave a syntax error. Any ideas

Thanx for your time.

Bobby

Visual FoxPro1

As I know you can not use a command as a expression.You should use the command prior "do report".

Bobby,

Typically in VFP reporting is done by using a SQL select to get your data all together into a reporting cursor and run the report with that cursor as the input.

SELECT text2 ;
FROM mms ;
into cursor reportresult ;
WHERE fileid="02"

report form TheReport...

You can run the query and start up the report designer, when you do not add the alias because it makes your life easier down the line.

thanx for the info ;o)