How we have to create a sql query using the report key and that query must send out email of that report key to the relevant employee's email address?
Userlevel 4
+8
Can you elaborate? What is the report type? Is it an IFS RD report, crystal, etc.? By Report Key, did you mean the Result Key?
Nevertheless, this can be done by creating your desired SQL and using Application Server Tasks. Mind that you need to firmly decide if the data you fetch are from the XML data (XML_REPORT_DATA_TAB) or the tabular data (_RPT) which is more readable and easy format for scripting.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.