01-08-2004, 01:40 PM
i m using Crystal Report 7. i want to use sql query to retrieve records and show in report, tell me plz.
my 2nd question is that can i show a non database field in a text box in my report?
01-08-2004, 02:10 PM
1) Read the Crystal tutorials linked to from the FAQ at the top of this forum.
2) Right click and choose Insert Text Field (or whatever the command is called in CR 7).
01-09-2004, 12:43 PM
thanks for help but i want to ask that i m using vb and textbox value from a form of vb, want to display in report
01-09-2004, 12:57 PM
do you currently have any code? If so, can you post what you have? If you want to pass a parameter value (such as the value of a text box or combo box) to restrict the records for the report use can you the .recordselectionformula method or pass an entire recordset via an sql statement and binding your new recordset to the report with the setdatasource method.