I can write the SQL statement to get exactly the data that I want for a report. But how do I send this to a report?
I have a statement to count and summarize records, but how can I set the layout to use this new dataset?
It this possible?
What about a chart? Can I set the dataset of a chart to get the data summary from an ExecuteSQL satement?
I'm a rookie and would appreciatel your input. Thanks.