Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dinamic Form fo dinamic Report
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00344613
Message ID:
00344643
Views:
23
>Hi, all
>
>I want to do a generic report for my tables, something like that,
>
>Based in table fic, generate a form only with the name field and a check box, then, if the users check box choice done, generate the report, only with the check boxes choices.
>
>Thank's in advance,
>
>Joao Batista
>(jbinf@mail.telepac.pt)
>(Beginner VFP6.0)

I think I understand what you are saying... all you need to do is build a string of your select statement and use the & macro expansion available in VFP to run like you want...

lcSql = 'select * from table where '
lcWhere = ' x=1'
lcInto = ' into cursor genreport'
lcselect = lcSql + lcWhere + lcInto

&lcSelect

Then build your report against the genreport cursor...

HTH
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform