Solved

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

Posted on 2011-09-13
8
506 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
  • 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
 
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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 

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 500 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

IntroductionWhile developing web applications, a single page might contain many regions and each region might contain many number of controls with the capability to perform  postback. Many times you might need to perform some action on an ASP.NET po…
Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

932 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now