?
Solved

How to display SSRS report results in a datagrid in a windows application

Posted on 2011-09-13
8
Medium Priority
?
530 Views
Last Modified: 2012-05-12
I have a WPF windows application, and I have created a page that opens a SSRS report when the user clicks on a link. WHen the user clicks on a link, the SSRS url is passed into the page, and the page opens with the report, and then the user selects the parameters, clicks View Report, and then sees the report results. How would I go about displaying these results in a datagrid?
0
Comment
Question by:jjliu4492
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
8 Comments
 
LVL 16

Expert Comment

by:Easwaran Paramasivam
ID: 36534937
As reportviewer control is there why do you want to display result in datagrid?

http://www.johnstagich.com/Blog/post/Adding-a-Local-SSRS-Report-to-WPF-Application.aspx
0
 
LVL 7

Expert Comment

by:mr_nadger
ID: 36535422
are you intending to use the contents of the grid for something, or do you just want to diplay the report?
0
 

Author Comment

by:jjliu4492
ID: 36536228
The end user wants to display the report results in a datagrid, we are not using the contents of the grid for anything.
0
AWS Certified Solutions Architect - Associate

This course has been developed to provide you with the requisite knowledge to not only pass the AWS CSA certification exam but also gain the hands-on experience required to become a qualified AWS Solutions architect working in a real-world environment.

 
LVL 7

Expert Comment

by:mr_nadger
ID: 36536367
I don't understand why they're wanting to display a report in a data grid; as EaswaranP said, reports shoudl be displayed in the reportviewer tool, datagrids are a different animal altogether.
If it has to be a datagrid, performance would be better if you ignored the report and queried the data directly into the grid, rather than rendering the report.
0
 

Author Comment

by:jjliu4492
ID: 36536373
We have already created all the report rdl's, and the user's request is to display the report results in a datagrid format.
0
 
LVL 7

Accepted Solution

by:
mr_nadger earned 2000 total points
ID: 36536418
What you're being asked to do is display a rendered webpage into a datagrid, which it's not designed to do.
You will also lose the ability to enter any parameters.

The user may have requested you do this, but it really isn't a good idea; you either need decline their request, or modify your RDLs to look like a datagrid.
0
 

Author Comment

by:jjliu4492
ID: 36536425
How would I modify my rdl to look like a datagrid?
0
 
LVL 7

Expert Comment

by:mr_nadger
ID: 36536479
just format the table in the report to match the layout of a gridview on your form
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question