Page 1 of 1

How to choose field 2 print

PostPosted: Tue Jul 10, 2007 1:29 pm
by carlos torres
Hi

Working with dbp, how can I choose some fields in order to print an special report? and the other questions is... how can i know the number of records in a recordset or a query result?

regards

carlost

PostPosted: Tue Jul 10, 2007 4:25 pm
by Gaev
Carlos:
Working with dbp, how can I choose some fields in order to print an special report?
Current beta includes just a simple reporting facility ... full one is expected later in the summer/fall ... I haven't tried it myself, but just before you invoke dbpListPrint, you might try ...
Code: Select all
dbpSetFieldProperties "database id" "table" "field" "properties"
... and specify Visible=no for fields you do not want printed.

... how can i know the number of records in a recordset or a query result?
From the Special Variables section in the Help file ...
Code: Select all
[ID.Table.$RecCount]
If a query is active, the result reflects the number of found records. When no query is active, the result reflects the total number of records in the database.

Thanks

PostPosted: Tue Jul 10, 2007 5:00 pm
by carlos torres
Dear Gaev,

I got it. Thanks Again.

regards

carlost