August 29, 2008 08:13pm pdt

Member Login

Hall of Fame

Yearly

1chrismc 150,964
2mlmcc 131,305
3PFrog 111,752
4jgv 103,501
5rickchild 48,445
6RWrigley 39,404
7tshel 38,349
8Yurich 26,248
9mark_wills 21,650
10peter57r 21,585
11bdreed35 18,900
12chapmandew 17,060
13James0... 11,920
14gdupadhyay 11,850
15angelIII 11,520
16EugeneZ 10,925
17CRXIuser... 10,700
18frodoman 10,060
19nmcdermaid 9,500
20wykabryan 8,850
21ValentinoV 8,500
22analliah 8,450
23zx10r 7,890
24WilyGuy 7,500
25PedroCGD 7,200

	[x] Attachment Details

Stream a rdlc report from dll to browser

Zones: SQL Reporting, MS SQL Server, SQL Server 2005

Tags: Microsoft, SQL Server, 2005, Reporting Services, RDLC, The report definition for report XXX has not been specified

I have a very simple test report created in Visual Studio 2005 as an rdlc file in my dll. The rdlc file is in the dll because it is built off of the business objects. I need to be able to stream this file (i.e. not use a report viewer) to the browser.

I found code that I included below, but get an error:

The report definition for report 'Monkey.Report1' has not been specified

Yes my test namespace in my dll is named "Monkey" :o)

Anyway, any idea on how to solve this? I just wanted to get this simple test report running (because I have a bad feeling that it will not generate the data I want, but that is a separate issue)

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:

           
           
             using Microsoft.Reporting.WebForms;
 
protected void Page_Load(object sender, EventArgs e)
{
	LocalReport localReport = new LocalReport();
	localReport.ReportEmbeddedResource = "Monkey.Report1.rdlc";
 
	ReportDataSource reportDataSource = new ReportDataSource("FamilyCollection", Monkey.Family.RetrieveAll());
	localReport.DataSources.Add(reportDataSource);
 
	string reportType = "PDF";
	string mimeType;
	string encoding;
	string fileNameExtension;
 
	string deviceInfo =
		"<DeviceInfo>" +
		"  <OutputFormat>PDF</OutputFormat>" +
		"  <PageWidth>8.5in</PageWidth>" +
		"  <PageHeight>11in</PageHeight>" +
		"  <MarginTop>0.5in</MarginTop>" +
		"  <MarginLeft>1in</MarginLeft>" +
		"  <MarginRight>1in</MarginRight>" +
		"  <MarginBottom>0.5in</MarginBottom>" +
		"</DeviceInfo>";
 
	Warning[] warnings;
	string[] streams;
	byte[] renderedBytes;
 
	//Render the report
	renderedBytes = localReport.Render(reportType, deviceInfo, out mimeType, out encoding, out fileNameExtension, out streams, out warnings);
 
	//Clear the response stream and write the bytes to the outputstream
	Response.Clear();
	Response.ContentType = mimeType;
	Response.AddHeader("content-disposition", "attachment; filename=foo." + fileNameExtension);
	Response.BinaryWrite(renderedBytes);
	Response.End();
}

           
         

Start your free trial to view this solution

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

6.4

Question Stats

Zone: Database

Question Asked By: mrichmon

Solution Provided By: mrichmon

Participating Experts: 0

Solution Grade: A

Translate:

Loading Advertisement...

20080723-EE-VQP-34 / EE_QW_2_20070628