Search results for query: *

I have used the DataEnviornment in a very few reports. In each case I set a group header with information from the "primary" table and placed information from the "related" table in the Detail band. I put totals and whatknot in the Page Footer. (don't know what your table...

Check help for the sys(14)- index expression which should give you what you want. I use this in an array and let the user see which index (and expression) they want to use.

Just looked at your response to my posting. Wonder if there is a typo somewhere. You say you tried (iif(transfer.status='V','VOID','Cancelled')) when your first post said the table name was transaction. If this is the case all would show Cancelled as if would equate as false. Any help?

You can place an immediate if in the control source property of the grid column holding the text for the column. For example, if the grid column name is Status, then in properties go to the text for the column Status and in the Control Source property place the code...

Help says that: SET DATABASE Command Specifies the current database. Syntax SET DATABASE TO [DatabaseName] Arguments DatabaseName Specifies the name of an open database to be made the current database. If you omit DatabaseName , no open database is made the current database. Remarks...

Can you just e-mail it as an attachment?

You are actually bringing over every record across the network to look at it. If you can create a SQL query to accomplish the task you will do the work on the machine with the .dbf -- at least my experience shows putting SQL code in place of the kind you are trying speeds up network access by a...