Questions on Reporting Forum

1 answer

83 views

Report Page

hi

i created one report in my web application.

I have to show 12 fields in report so when i was show that filed the report is expanded.I cant show all the value sin report viewr
if i generate as pdf some fiedls missing

string

mimeType = string.Empty;

string ext = string.Empty;

Encoding encoding = Encoding.Default;

byte[] reportBytes = Telerik.Reporting.Processing.ReportProcessor.Render(

"PDF"

, reportToExport

,

null

,

out mimeType

,

out ext

,

out encoding);

string fileName = reportName + ".pdf";

Response.Clear();

Response.ContentType = mimeType;

Response.Cache.SetCacheability(

HttpCacheability.Private);

Response.Expires = -1;

Response.Buffer =

false;

Response.AddHeader(

"Content-Disposition",

string.Format("{0};FileName=\"{1}\"",

"attachment",

fileName));

Response.OutputStream.Write(reportBytes, 0, reportBytes.Length);

Response.End();

PDF is generated but Recodr is not coming fully
how to solv this prob

Regards

Abdul Ajees

General Discussions

answered on 22 Jun 2009

4 answers

100 views

[Solved] Giving a report wizard to the client

Hi, I'm new to telerik reporting and I admit that I have never tried this before.
I'm looking for an answer if my scenario is possible with telerik reporting:

I want to have an engine for displaying report that I will include in my web app for the client (one institution) with a couple of predefined reports. However, the requirement is that those reports will need to be flexible and the client should be able to modify them and create others. So, it seems like I would like to have a component that would be able to run a wizard on the installed app and let the business admin generate report templates that he will place on the site, so that the users can take advantage of them. Everything without visual studio. Is this scenario possible? - I doubt, but it doesn't hurt to ask. If no? is there any other way to include new reports on the site by my client themselves without the need of recompiling ?

thanks

General Discussions

answered on 22 Jun 2009

1 answer

277 views

Dynamically Add TextBoxes Into PageHeaderSection

Hello,

I am trying to build a Telerik Report (Template) to dynamically build reports based on the DataSource that it binds to. How can I dynamically add controls into each (header, details & footer section)? Please help.

I am trying something similar. But it is not letting me to do that. Please help. Thanks

    
            public partial class _Default : System.Web.UI.Page {  
        
                    protected void Page_Load(object sender, EventArgs e) {  
        
                        // ReportTemplate is an Empty Report without any controls.  
        
                        ReportTemplate Rep = new ReportTemplate();  
        
                        for (int i = 0; i < 8; i++) {  
        
                            Telerik.Reporting.TextBox h = new Telerik.Reporting.TextBox();  
        
                            h.Value = "Column" + i.ToString();  
        
                            PageHeaderSection header = new PageHeaderSection();  
        
                            Header.Controls.Add(h);  
        
                        }  
        
                    }  
        
                }

General Discussions

answered on 22 Jun 2009

4 answers

548 views

[Solved] Hosting ReportViewer in WPF

I'm trying to display a report in a WPF window and I'm stuck.

I know I had something similar working a while back but with the changes I've made and upgrade to the Telerik ReportViewer I can't seem to accomplish the task now.

Here's the code for my ReportViewer window:

    
                public partial class MyReportViewer : Window  
        
                {  
        
                    private IReportDocument myReport;  
        
                    public MyReportViewer(IReportDocument document)  
        
                    {  
        
                        myReport = document;  
        
                        InitializeComponent();  
        
                    }  
        
                    private void WindowLoaded(object sender, RoutedEventArgs e)  
        
                    {  
        
                        System.Windows.Forms.Integration.WindowsFormsHost host = new System.Windows.Forms.Integration.WindowsFormsHost();  
        
                        ReportViewer rptViewer = new ReportViewer();  
        
                        rptViewer.Report = this.myReport;  
        
                        rptViewer.RefreshReport();  
        
                        host.Child = rptViewer;  
        
                    }  
        
               }

Here's the calling window:
...

    
                        KeyFront keyfront = new KeyFront(zone.ZoneID);  
        
                        MyReportViewer rptViewer = new MyReportViewer(keyfront);  
        
                        rptViewer.Show();

Here's the report code:

    
                    public KeyFront(int zonepk)  
        
                    {  
        
                        /// <summary>  
        
                        /// Required for telerik Reporting designer support  
        
                        /// </summary>  
        
                        InitializeComponent();  
        
                        this.sqlDataAdapter1.SelectCommand.Parameters["@ZonePK"].Value = zonepk;  
        
                        this.DataSource = this.sqlDataAdapter1;  
        
                        //  
        
                        // TODO: Add any constructor code after InitializeComponent call  
        
                        //  
        
                    }

The report viewer window does appear but is blank. What am I missing?

Thanks,
-Sid Meyers.

General Discussions

answered on 18 Jun 2009

1 answer

115 views

Visual web studio 2008/no telerik templates

Hi,

I have a web app developed using Visual Web studio 2008 express. I have installed your Telerik Reports Trial version but i do not see the templates needed to get me started with your reports.

Brian

General Discussions

answered on 18 Jun 2009

4 answers

222 views

Bind chart to a dataset ?

Was wondering if there is an easy way to bind a dataset to a chart programmatically. Would like to use one of my prebuilt stored procedures without using a strongly typed dataset. Would like to do something like the following. The last line fails however as the chart1 object does not appear to have a datasource property.

SqlConnection connSomsys = new SqlConnection(@"Server=cmdivst004\Jason08;Integrated Security=true;Database=QuoteDB");

SqlCommand selectChartinfo;

selectChartinfo =

new SqlCommand("sprocgetinternationalsales", connSomsys);

selectChartinfo.CommandType =

CommandType.StoredProcedure;

selectChartinfo.Parameters.AddWithValue(

"@year", 2008);

SqlDataAdapter adapter6 = new SqlDataAdapter(selectChartinfo);

DataSet dataSet6 = new DataSet();

adapter6.Fill(dataSet6);

this.chart1.datasource = dataSet6;

General Discussions

answered on 17 Jun 2009

3 answers

198 views

Report in web application

Hi

I am new in telerik reporting.how to create and use report in web application
can i use dropdown in telerik report. i need to create dynamic report like when i
passed parameter the report the content of the report will be changed based on data from database

how to i create it ? its Urgnet

Regards

Abdul

General Discussions

answered on 17 Jun 2009

1 answer

118 views

How to control what exporting to csv file

Hi,

I'm trying to control what get exported to a csv file an the only way i found is to put it in page header and foter. This is not sutable for me. Does someone know another way?

General Discussions

answered on 17 Jun 2009

5 answers

313 views

[Solved] Can't get parameter value in NeedDateSource event

I am trying to pass a parameter to my data source, but it isn't passing the correct value. How does my code look below? Is there a way to debug and use breakpoints when building report classes?

    
            namespace AWS_Reports 
        
            { 
        
                using System; 
        
                using System.ComponentModel; 
        
                using System.Drawing; 
        
                using System.Windows.Forms; 
        
                using System.Configuration; 
        
                using Telerik.Reporting; 
        
                using Telerik.Reporting.Drawing; 
        
                /// <summary> 
        
                /// Summary description for MyAccountEstimator. 
        
                /// </summary> 
        
                public partial class MyAccountEstimatorStats : Telerik.Reporting.Report 
        
                { 
        
                    public MyAccountEstimatorStats() 
        
                    { 
        
                        /// <summary> 
        
                        /// Required for telerik Reporting designer support 
        
                        /// </summary> 
        
                        InitializeComponent(); 
        
                        // Remove the design time data source to force use of NeedDataSource event 
        
                        this.DataSource = null; 
        
                        lstSummary.DataSource = null; 
        
                    } 
        
                    private void MyAccountEstimatorStats_NeedDataSource(object sender, EventArgs e) 
        
                    { 
        
                        // Try to get connection string from config file 
        
                        ConnectionStringSettings cnStr = cnStrSettings(); 
        
                        if ((cnStr != null) && (cnStr.ConnectionString != null)) 
        
                        { 
        
                            this.dsEstimatorUsageDetailsTableAdapter1.Connection.ConnectionString = cnStrSettings().ConnectionString; 
        
                        } 
        
                        try 
        
                        { 
        
                            this.dsEstimatorUsageDetailsTableAdapter1.Fill(this.dsEstimatorUsage.dsEstimatorUsageDetailsTable, StartDate, EndDate); 
        
                            this.DataSource = this.dsEstimatorUsage; 
        
                            this.DataMember = "dsEstimatorUsageDetailsTable"; 
        
                        } 
        
                        catch (System.Exception ex) 
        
                        { 
        
                            // An error has occurred while filling the data set. Please check the exception for more information. 
        
                            System.Diagnostics.Debug.WriteLine(ex.Message); 
        
                        } 
        
                    } 
        
                    private void lstSummary_NeedDataSource(object sender, EventArgs e) 
        
                    { 
        
                        // Try to get connection string from config file 
        
                        ConnectionStringSettings cnStr = cnStrSettings(); 
        
                        if ((cnStr != null) && (cnStr.ConnectionString != null)) 
        
                        { 
        
                            this.prWEP_MyAccountUsageTotalsTableAdapter1.Connection.ConnectionString = cnStrSettings().ConnectionString; 
        
                        } 
        
                        try 
        
                        { 
        
                            this.prWEP_MyAccountUsageTotalsTableAdapter1.Fill(this.dsEstimatorUsage.prWEP_MyAccountUsageTotals, StartDate, EndDate); 
        
                            this.lstSummary.DataSource = this.dsEstimatorUsage; 
        
                            this.lstSummary.DataMember = "prWEP_MyAccountUsageTotals"; 
        
                        } 
        
                        catch (System.Exception ex) 
        
                        { 
        
                            // An error has occurred while filling the data set. Please check the exception for more information. 
        
                            System.Diagnostics.Debug.WriteLine(ex.Message); 
        
                        } 
        
                    } 
        
                    private ConnectionStringSettings cnStrSettings() 
        
                    { 
        
                        // Get connection string from web.config 
        
                        ConnectionStringSettings connStrSettings = ConfigurationManager.ConnectionStrings["AnchorWallConnectionString"]; 
        
                        return connStrSettings; 
        
                    } 
        
                    public DateTime StartDate 
        
                    { 
        
                        get { return DateTime.Parse(this.ReportParameters["StartDate"].Value.ToString()); } 
        
                        set { this.ReportParameters["StartDate"].Value = value; } 
        
                    } 
        
                    public DateTime EndDate 
        
                    { 
        
                        get { return DateTime.Parse(this.ReportParameters["EndDate"].Value.ToString()); } 
        
                        set { this.ReportParameters["EndDate"].Value = value; } 
        
                    } 
        
                } 
        
            }

General Discussions

answered on 17 Jun 2009

5 answers

259 views

Combine paramertized reports in Report Book problem

Hi,
Lets suppose that Region consists of multiple Areas
I have two reports: RegionReport and AreaReport that I would like to combine into one report book.
RegionReport takes one non-mergable parameter, integer - regionId, that I use in NeedDataSoruce in my db query.

In my report book I am trying to achieve the following:
RegionReport - ie California
AreaReport - Sacramento
AreaReport - LA
RegionReport - ie Texas
AreaReport - Dallas
AreaReport - Huston

To achieve this I construct the report book in the following way:

    
            reportBook = new ReportBook(); 
        
            for (int i = 0; i < regionList.Count; i++) 
        
            { 
        
                RegionReport regionReport = new RegionReport(); 
        
                regionReport.ReportParameters["RegionId"].Value = regionList[j]; 
        
                reportBook.Reports.Add(regionReport); 
        
                for (int j = 0; j < areaList.Count; j++) 
        
                { 
        
                    AreaReport areaReport = new AreaReport(); 
        
                    areaReport.ReportParameters["AreaId"].Value = areaList[j]; 
        
                    reportBook.Reports.Add(areaReport); 
        
                } 
        
            }

When processing the reports, in NeedDataSource event, the value for the RegionId paramenter in the following code is always of the last value added. In other words it is not preserved from one RegionReport to another.

    
            private void RegionReport_NeedDataSource(object sender, EventArgs e) 
        
            { 
        
                Telerik.Reporting.Processing.Report report = (Telerik.Reporting.Processing.Report)sender; 
        
                //If I had two RegionReport reports added to the book, RegionId parameter's value would be always of the last one added. 
        
                int param = Convert.ToInt16(this.ReportParameters["RegionId"].Value); 
        
                ...

What is the proper way of preserving individual reports paramenters' values in a report book ?
Thank you
Pawel Mozdzen

General Discussions

answered on 17 Jun 2009

	public partial class _Default : System.Web.UI.Page {

	protected void Page_Load(object sender, EventArgs e) {

	// ReportTemplate is an Empty Report without any controls.
	ReportTemplate Rep = new ReportTemplate();
	for (int i = 0; i < 8; i++) {
	Telerik.Reporting.TextBox h = new Telerik.Reporting.TextBox();
	h.Value = "Column" + i.ToString();
	PageHeaderSection header = new PageHeaderSection();
	Header.Controls.Add(h);

	}
	}
	}