To create a report off a Command Object:.This is because Crystal Reports is a reporting tool, and not a data manipulation tool. Crystal Reports does not support SQL Query Language for data manipulation like: CREATE TABLE, ALTER TABLE, INSERT, INTO, UPDATE, DELETE, DROP TABLE, ALTER SESSION, TEMP Table, Variable Declaration. If you need assistance in writing the SQL Query, contact your database administrator, or consult your database documentation.Īlso, Crystal Reports supports SQL Query Language in a Command Table to retreive data from a data source like: SELECT, FROM, WHERE, GROUP BY, ORDER BY, UNION. ![]() Command Objects allows the report developer to write his own SQL Query which will be represented in Crystal Reports as a table.Ĭommand Object is a powerful feature that enables a report developer to enter a SQL Query manually to retrieve data, but with power, comes responsibilities, therefore when using a Command Object to enter a SQL Query, it is the report developer's responsibility to ensure the SQL Query syntax is correct.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |