You can using a Command object, there you write the SQL and CR sends it to the Server... must be valid of course. You may also be able to use a SQLExpression, it's in the Field Explorer, but.... see below...
BUT BE CAREFUL, each time the report runs it executes the Command so if you are planning to increment a counter it can cause issues if the report is not completed etc.
Also be aware if using a subreport it runs for each row of data returned in the main report.
So don't use active DB server for testing, it could causes data issue.
Ido has a lot of UFL's that can do a lot of custom things so have a chat with him so things a re clear for your work flow and data integrity...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.