You are not logged in.
Pages: 1
I am very new to ReportServer, I am wondering is there a option to pass values from datasource to Email Body sent via Scheduler?
Offline
Hi auchentoshan,
what values are you talking exactly about? Could you please elaborate?
Regards,
Eduardo
Offline
For example binding sql results to a variable that can be use in the message body of the mail sent by scheduler, results like counts of records from a specific query.
Hi auchentoshan,
what values are you talking exactly about? Could you please elaborate?
Regards,
Eduardo
Offline
Hi auchentoshan,
the available substitutions that can be used are these: https://reportserver.net/en/guides/conf … Scheduler/ (4.3.3.: available substitutions).
If you need other data, you can create your own "Send to" script, which can also be scheduled. There, you can include any information you need, as you can see in this example:
https://reportserver.net/en/guides/scri … s/Send-To/
Count of records could be implemented by executing a given report and exporting it to a RS_TABLE or RS_DATACOUNT format.
Then, use the net.datenwerke.rs.base.service.reportengines.table.output.object.CompiledTableReport or net.datenwerke.rs.base.service.reportengines.table.output.object.CompiledDataCountTableReport for counting the records and including it into the email body:
def myExportedTable = reportExec.execute(report, "RS_DATACOUNT", execConfig)
def dataCount = myExportedTable.getDataCount()
Regards,
Eduardo
Offline
Dear Eduardo,
Thanks for the explanation, I will give it a try.
Hi auchentoshan,
the available substitutions that can be used are these: https://reportserver.net/en/guides/conf … Scheduler/ (4.3.3.: available substitutions).
If you need other data, you can create your own "Send to" script, which can also be scheduled. There, you can include any information you need, as you can see in this example:
https://reportserver.net/en/guides/scri … s/Send-To/Count of records could be implemented by executing a given report and exporting it to a RS_TABLE or RS_DATACOUNT format.
Then, use the net.datenwerke.rs.base.service.reportengines.table.output.object.CompiledTableReport or net.datenwerke.rs.base.service.reportengines.table.output.object.CompiledDataCountTableReport for counting the records and including it into the email body:
def myExportedTable = reportExec.execute(report, "RS_DATACOUNT", execConfig)
def dataCount = myExportedTable.getDataCount()Regards,
Eduardo
Offline
Pages: 1