Question
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
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
![](https://accounts.pega.com/sites/default/files/styles/user_image/public/2024-05/e90c12b7-5a50-45b6-9408-8644c06fabca.jpg?h=9bedb0c7&itok=I_lzpbin)
![](https://accounts.pega.com/sites/default/files/styles/user_image/public/2024-05/e90c12b7-5a50-45b6-9408-8644c06fabca.jpg?h=9bedb0c7&itok=I_lzpbin)
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.
![](https://accounts.pega.com/sites/default/files/pega-user-image/257/REG-257204.png?source=PUMINIT)
![](https://accounts.pega.com/sites/default/files/pega-user-image/257/REG-257204.png?source=PUMINIT)
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.
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
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
![](https://accounts.pega.com/sites/default/files/pega-user-image/257/REG-257204.png?source=PUMINIT)
![](https://accounts.pega.com/sites/default/files/pega-user-image/257/REG-257204.png?source=PUMINIT)
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.
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
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
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
Nationwide Building Society
GB
Hi,
Any Update I can get on this, Please?
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
Nationwide Building Society
GB
Hi,
Good Morning,
Request your guidance for the said query
Accepted Solution
![](https://accounts.pega.com/sites/default/files/styles/user_image/public/2024-05/e90c12b7-5a50-45b6-9408-8644c06fabca.jpg?h=9bedb0c7&itok=I_lzpbin)
![](https://accounts.pega.com/sites/default/files/styles/user_image/public/2024-05/e90c12b7-5a50-45b6-9408-8644c06fabca.jpg?h=9bedb0c7&itok=I_lzpbin)
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.