Solved

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

Posted on 2011-09-13
8
524 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
Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …

726 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