Solved

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

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

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

 
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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.

773 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