...
- Most pages which show a single record will have an
IDproperty which relates to the primary key of a database table.- Trust Transaction Lines, however, have a composite primary key based on the transaction id and line number.
- Pages which allow searching of records commonly have a Name property (and various others depending on the needs of the search page).
- You can view the raw view model data by appending
?__ViewModelDebug=yto a page you load. This will show all the view model properties available; usually there will be enough there to pass to a report.
...
| Crystal Name | Data Type | Sample Value | Comments | ||||
|---|---|---|---|---|---|---|---|
TransId | integer | 123 | The transaction id of the cheque or bank transfer. This is the TrustJournalHeader.Id database field and TrustCheque.TransactionId database field. | ||||
ChqId | integer | 76 | The cheque id of the written cheque. Note that this is not the cheque number itself (because you can duplicate cheque numbers) but the TrustChequeWritten.Id field. | TransType | string | CHQ | Either CHQ for trust cheque or BTR for bank transfer. |
IsOriginal | boolean | false | Set to true when the printed cheque is first printed. False when the cheque is re-printed from a transaction details page. Note that the database does not track when the report is actually printed to paper (as it can't reliably do that), so the value of this parameter is a best guess. |
...