Solved

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

Posted on 2011-09-13
8
503 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
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

705 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

15 Experts available now in Live!

Get 1:1 Help Now