Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

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
Posted: 5 years ago
Posted: 6 Nov 2017 22:21 EST
Andrew Grondin (grona) GCS Solutions Engineer I
Pegasystems Inc.
US
Report

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: 5 years ago
Posted: 9 Nov 2017 5:20 EST
Swaminath Sethuramen (swaminat259) Nationwide Building Society
Nationwide Building Society
GB
Report

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: 5 years ago
Posted: 17 Nov 2017 16:02 EST
Andrew Grondin (grona) GCS Solutions Engineer I
Pegasystems Inc.
US
Report

I'm not certain what you are asking for here; you would just pass the data from the query to the viewer.
Posted: 5 years ago
Posted: 26 Nov 2017 14:34 EST
Swaminath Sethuramen (swaminat259) Nationwide Building Society
Nationwide Building Society
GB
Report

Hi,

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

 

 

Andrew Saunders
Posted: 5 years ago
Posted: 28 Dec 2017 4:03 EST
Swaminath Sethuramen (swaminat259) Nationwide Building Society
Nationwide Building Society
GB
Report

Hi,

Good Morning,

Request your guidance for the said query

Accepted Solution

Posted: 5 years ago
Posted: 28 Dec 2017 8:50 EST
Thomas Sasnett (ThomasSasnett) PEGA Lead Robotics Architect
Pegasystems Inc.
US
Report

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