>thanks for the explaination .. but I am not understand what you mean, can you give me an example for make visible true and false in Data Report .. ( sorry I am a beginner of VB 6) .. thanks and good luck
>
Hi Winan,
Sorry to take so long getting back to you. Have been stuck myself on a problem using the Data Report. Actually, more specifically the Data Environment. I believe his to be the key in your case too. You need to structure a SQL command object on the DE for the report that will make an inteligent decision to display or not to display.
For example, if I had a table, customer, with two fields, say name and balance, anfd I wanted to create a report that showed all names, but only the balance for a given name if it is greated than $500.00. I would create a command object based on a SQL statement, where that SQL statement would be:
SELECT name, (IIF(balance > 500, STR(balance), " ")) AS CustBal FROM CUSTOMER
Please note that I used STR() to represent the conversion from numeric to string in VB. STR() is a VFP command, but I forget the one for VB offhand.
On the report, hook the report up to this command object, and place the two fields Name and CustBal on the report. Voila.
I think that the key to these problems are in how we need to structure the data environment command object. Keep inm mind too, that this is the first version of the VB report writer, so they are bound to be numerous fixes and patches.
Phil