Skip to main content

How To set up For Teleril Reports

1.First Of All install Telerik Control on Your Machine .
TelerikReporting_Q1_2007_dev_setup.exe
2.It will show Telerik Reports on Your tool box of Dotnet Framework
3.On ur Solution Explorer ,R.C on ur Project name and Click on "Add Asp.Net Folders"
4.Add App_Code on Ur Project.
5.R.c. on App_Code and add Telerik Reports
6.View Designer mode Of Reports and Design your Reports.
7..Place Textboxes on Report To View the Data.On Code Window Make function that are called on the .aspx page .
8.Set the Value Property of textboxes as the name of the Column used in the Table that you extract from DataBase.
e.g TextBox1.Value=[=salary]
9.Display Report on .aspx page

using Telerik.Reporting.Processing;
10.Place a TeleRik Report Viewer on Your Page
11. On Page Load Make a object of Report class
e.g. Report1 rp=new Report1();
Always make attention Report class and .aspx page Class is not same
if You pass some value to the function that are build in the Report then pass by using the object
e.g.
rp.BindValue((DateTime)startdate.SelectedDate, (DateTime)enddate.SelectedDate);
ReportViewer1.Report=rp;
ReportViewer1.ShowExportGroup = true;
ReportProcessor.ExtensionDir = Server.MapPath("~/bin");

Export the Data in the pdf Format in Report
Telerik.ReportViewer.Design.dll
Telerik.ReportViewer.WinForms.dll
Telerik.Reporting.VsPackage.dll
Telerik.Reporting.Interfaces.dll
Telerik.Reporting.ImageRendering.dll
Telerik.Reporting.HtmlRendering.dll
Telerik.Reporting.dll
Telerik.Reporting.Design.dll
Telerik.ReportViewer.WebForms.dll
Telerik.Reporting.Processing.dll
Telerik.Reporting.Data.dll


In Web.config Files Add these Code


















Comments

Popular posts from this blog

URL Rewritting

http://www.simple-talk.com/dotnet/asp.net/a-complete-url-rewriting-solution-for-asp.net-2.0/ http://msdn.microsoft.com/en-us/library/ms972974.aspx URL Rewriting in ASP.NET Summary: Examines how to perform dynamic URL rewriting with Microsoft ASP.NET. URL rewriting is the process of intercepting an incoming Web request and automatically redirecting it to a different URL. Discusses the various techniques for implementing URL rewriting, and examines real-world scenarios of URL rewriting. (31 printed pages) Download the source code for this article. Contents Introduction Common Uses of URL Rewriting What Happens When a Request Reaches IIS Implementing URL Rewriting Building a URL Rewriting Engine Performing Simple URL Rewriting with the URL Rewriting Engine Creating Truly "Hackable" URLs Conclusion Related Books Introduction Take a moment to look at some of the URLs on your website. Do you find URLs like http://yoursite.com/info/dispEmployeeInfo.aspx?EmpID=459-099&type=summ...

SEND A PDF FILE AS AN ATTACHEMENT OF MAIL!

System.Net.Mail.MailMessage m1 = new System.Net.Mail.MailMessage(); m1.From = "manpreet@gmail.com" m1.Subject = "Test mail "; m1.Body = str.ToString(); m1.IsBodyHtml = true; m1.To.Add("jasdeep@gmail.com"); m1.CC.Add("jasdeep123@gmail.com"); m1.Attachments.Add(new Attachment(strserverpath + @"\pdf\" + PdfFileName)); smtp.Send(m1);

Sql Server Tips

IF WE WANT TO SELECT  TOP N ROWS  FROM A TABLE ,  WE USE THE FETCH NEXT  SELECT    * FROM  table1   ---//First m rows ignore first n rows ORDER BY id OFFSET n ROWS FETCH NEXT m ROWS ONLY if n=0, m=10 then first  10 rows if n=10, m=10 then first  10 rows start from 11th row Row_number()   SELECT  ROW_NUMBER() OVER(order by db.id) Insertion Simultaneouly in temp table with output clause DECLARE @table1 table (   Id int,   name nvarchar(50) ); DECLARE @table2 table (  Id int,  name nvarchar(50) ); INSERT INTO @table2 OUTPUT INSERTED.*   INTO @table1   select top 10 id, name  from FinalTable SELECT * FROM @table2; SELECT * FROM @table1;