CR will generate a SQL statement for you based on your table links, groupings etc. If you're not familiar with it, using a "command query" gives you that control. You build the query used in the CR report, instead of using table links, etc.
Read up on the command query option, then you can actually copy the SQL code generated by the CR report, modify it, then create a report using a command query and your modified query
Proposed as answer byEng.salimThursday, February 18, 2010 12:58 PM
Marked as answer byHarry ZhuThursday, February 25, 2010 2:37 AM
CR will generate a SQL statement for you based on your table links, groupings etc. If you're not familiar with it, using a "command query" gives you that control. You build the query used in the CR report, instead of using table links, etc.
Read up on the command query option, then you can actually copy the SQL code generated by the CR report, modify it, then create a report using a command query and your modified query
Proposed as answer byEng.salimThursday, February 18, 2010 12:58 PM
Marked as answer byHarry ZhuThursday, February 25, 2010 2:37 AM
What if you want to compare the text or value of the textbox of the other form to the crystal report databse? Because i want to edit the query of the crystal report that will show the account_number that is equal to the value of textbox in the other form.
Tnx
