Skip to main content
Contact a Moderator

Question

7
Replies
101
Views
 Swaminath Sethuramen (swaminat259) Nationwide Building Society
Nationwide Building Society
GB
swaminat259 Member since 2017 9 posts
Nationwide Building Society
Posted: November 4, 2017
Last activity: January 11, 2018
Posted: 4 Nov 2017 4:30 EDT
Last activity: 11 Jan 2018 16:22 EST
Closed
Solved

Pass values from sqlquery to ReportViewer

Report

Hi,

In Robotic Automation, how to pass values from a sql query on to a report viewer .net component.

Robotic Process Automation
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 4 years ago
Posted: 6 Nov 2017 22:21 EST
Andrew Grondin (grona) PEGA GCS Solutions Engineer I
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.
Posted: 4 years ago
Posted: 9 Nov 2017 5:20 EST
Swaminath Sethuramen (swaminat259) Nationwide Building Society
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
Posted: 4 years ago
Posted: 17 Nov 2017 16:02 EST
Andrew Grondin (grona) PEGA GCS Solutions Engineer I
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.
Posted: 4 years ago
Posted: 26 Nov 2017 14:34 EST
Swaminath Sethuramen (swaminat259) Nationwide Building Society
Nationwide Building Society
GB

Hi,

Yes, I would like to  just pass the output of an sql query on to report viewer using automation.

 

 
Posted: 4 years ago
Posted: 11 Dec 2017 15:18 EST
Swaminath Sethuramen (swaminat259) Nationwide Building Society
Nationwide Building Society
GB

Hi,

Any Update I can get on this, Please?
Posted: 4 years ago
Posted: 28 Dec 2017 4:03 EST
Swaminath Sethuramen (swaminat259) Nationwide Building Society
Nationwide Building Society
GB

Hi,

Good Morning,

Request your guidance for the said query

Accepted Solution

Posted: 4 years ago
Posted: 28 Dec 2017 8:50 EST
Thomas Sasnett (ThomasSasnett) PEGA Lead Robotics Architect
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.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice