General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>I am creating a program in which I create tables to preview reports. I delete the temporary tables after the report is done being viewed/printed.
SYS(2015) gives a unique name, but I'll have to agree with using a cursor. I always use a cursor for reports, you create the cursor with only the records you want and in the order you want, so the report won't be on a filtered or indexed source, just straight up data, its a little nicer.
When creating your reports, do not add alias names to the expressions, make sure you have an empty, default data session, and select the cursor before you run the report.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only