Report help?  
Author Message
Bobby110uk





PostPosted: Visual FoxPro General, Report help? Top

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  
 
 
dni





PostPosted: Visual FoxPro General, Report help? Top

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

 
 
David Frankenbach





PostPosted: Visual FoxPro General, Report help? Top

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.



 
 
Bobby110uk





PostPosted: Visual FoxPro General, Report help? Top

thanx for the info ;o)