Report Viewer unstead of crystal reports

luckystar · June 5th, 2009, 06:14 PM

Hi,

Has any one used microsoft ReportViewer unstead of crystal? If so I would welcome any suggestion.

The ReportQuery.cs instantiates a new crystal document ie (page 395)
---
ReportDocument report = New ReportDocument()
report.Load (server.MapPath(currentReport.FileName))
--
is there an equivalent way in using microsoft reportViewer

thanks in advance

realkewl · June 9th, 2009, 05:07 PM

Hey Luckstar,

We have done a project that used ReportViewer and from what I can remember you will need to dim a variable to the class LocalReport (Microsoft.reporting.webforms namespace) we did something like this:

vb =

Code:

 
Imports  Microsoft.Reporting.Webforms
 
Dim report as new LocalReport
Dim dt as datatable = GetMydataTable()
Dim dataSource  as new ReportDataSource("ReportData",dt)
Dim renderedBytes AsByte()
 
report.Reportpath = server.MapPath("")
report.DataSources.Add(dataSource)
 
renderedBytes  = report.Render("PDF",nothing,nothing,nothing,nothing,nothing,nothing)

kind of something like that

c#

Code:

 

{ 
    LocalReport report = new LocalReport(); 
    datatable dt = GetMydataTable(); 
    ReportDataSource dataSource = new ReportDataSource("ReportData", dt); 
    byte[] renderedBytes = null; 
    
    report.Reportpath = server.MapPath(""); 
    
    report.DataSources.Add(dataSource); 
    
    renderedBytes = report.Render("PDF", null, null, null, null, null, null); 
}

Hope this helps.

Funny thing is that I was wondering which reporting tool to use crystal vs ReportViewer. We had so many problems before using crystal that we went to reportviewer. But now that Vince included a sample, which I will try, was wondering if we could use crystal now. What are your thoughts?

-realkewl

luckystar · June 10th, 2009, 04:04 PM

Hi,

Thank you so much I will have a go just the lead I needed.

the reason I am going report viewer is my customer does not want crystal ;he just wants microsoft. In my experience many customers see crystal as an expensive package and tend to avoid it,
particularily in web apps where licenses can be costly ( Even though I explain its integration with visual studio and we are using its objects etc..)

I tend to favour Report Viewer as also we have a team using SQL server reporting services and I understand report viewer is a reporting services component and therefore the web app rerpoting
and reports generated with SQL server reporting services integration should be straight forward.

regards