Question


Nationwide Building Society
GB
Last activity: 11 Jan 2018 16:22 EST
Pass values from sqlquery to ReportViewer
Hi,
In Robotic Automation, how to pass values from a sql query on to a report viewer .net component.
-
Like (0)
-
Share this page Facebook Twitter LinkedIn Email Copying... Copied!
Accepted Solution


Pegasystems Inc.
US
The ReportViewer control is not a Pega Robotics created control. You would need to research it specifically for how to get it to accept a DataTable. From a first glance, it does not accept that as a DataSource, so you would need to write code for it.


Pegasystems Inc.
US
You'll have to pull the table out as a datatable object, then pull out rows as strings to pass to the report viewer.


Nationwide Building Society
GB
Hi,
Thanks for your response.
Request you to assist with a data/execution flow snapshot for passing from datatable object onto report viewer
Appreciate your assistance


Pegasystems Inc.
US
I'm not certain what you are asking for here; you would just pass the data from the query to the viewer.


Nationwide Building Society
GB
Hi,
Yes, I would like to just pass the output of an sql query on to report viewer using automation.
-
Andrew Saunders


Nationwide Building Society
GB
Hi,
Any Update I can get on this, Please?


Nationwide Building Society
GB
Hi,
Good Morning,
Request your guidance for the said query
Accepted Solution


Pegasystems Inc.
US
The ReportViewer control is not a Pega Robotics created control. You would need to research it specifically for how to get it to accept a DataTable. From a first glance, it does not accept that as a DataSource, so you would need to write code for it.