Hi,

I have never used the ReportViewer before. When I add the ReportViewer to my web application, it looks great and styled as it should in the design, but when I go to run my program, the images are all broken, and there is no styling of the bar. This is before I assign any report to the viewer.

Unfortunately, I have this project which is due in a very short time frame, and this is holding me up. I hope that someone may have a quick answer for me.

I am running Reporting Q3 2007 and Visual Studio 2008.

I tried my existing application that I am trying to get the ReportViewer to show up in and I created a brand new application with just the ReportViewer and I received the same result.

Any help anyone has would really be great. I may be forced to use Crystal Reports to finish my project otherwise. Thanks.

Andre

Hi,

We are experiencing the following error when adding these lines to the web.config:

    <Telerik.Reporting>
        <Extensions>
            <Render>
                <Extension name="XLS">
                    <Parameters>
                        <Parameter name="DefaultPageFooter" value="false"/>
                    </Parameters>
                </Extension>
                <Extension name="XLSX">
                    <Parameters>
                        <Parameter name="DefaultPageFooter" value="false"/>
                    </Parameters>
                </Extension>
            </Render>
        </Extensions>
    </Telerik.Reporting>

This only happens when it is outside of the development environment and it seems to be down the the XLSX segment (if I remove that then it works).

The error that we are getting is this:

Server Error in '/' Application.

---

A null or zero length string does not represent a valid Type.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.TypeLoadException: A null or zero length string does not represent a valid Type.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[TypeLoadException: A null or zero length string does not represent a valid Type.] System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark) +10161414 System.RuntimeType.PrivateGetType(String typeName, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark) +42 System.Type.GetType(String typeName, Boolean throwOnError) +71 Telerik.Reporting.Processing.ExtensionManagerBase.CreateExtensionInfo(String typeName, String extensionName) +55 [ExtensionManagerException: Error loading extension type with name .] Telerik.Reporting.Processing.ExtensionManagerBase.CreateExtensionInfo(String typeName, String extensionName) +214 Telerik.Reporting.Processing.ExtensionManagerBase.Config(ExtensionInfoCollection extensions, ReportingConfigurationSection section) +539 Telerik.Reporting.Processing.ExtensionManager.get_Instance() +98 Telerik.Reporting.Processing.ExtensionManager.ListExtensions(Type extensionType) +13 Telerik.Reporting.Processing.ReportProcessor.ListRenderingExtensions() +27 Telerik.Reporting.Processing.ReportProcessor.GetExtensionInfoCore(String name) +29 Telerik.Reporting.Processing.ReportProcessor.GetExtensionInfo(String format) +136 Telerik.Reporting.Processing.ReportProcessor.RenderCore(String format, IList`1 reports, Hashtable deviceInfo, Hashtable renderingContext, CreateStream createStreamCallback) +22 Telerik.ReportViewer.WebForms.ReportRenderOperation.RenderReport(String format, IList`1 processingReports, Hashtable deviceInfo, Hashtable renderingContext, CreateStream createStreamCallback) +43 Telerik.ReportViewer.WebForms.ReportPageOperation.RenderReport(String format, IList`1 processingReports, Hashtable deviceInfo, Hashtable renderingContext) +192 Telerik.ReportViewer.WebForms.ReportRenderOperation.PerformOperationOverride() +223 Telerik.ReportViewer.WebForms.BasicHandler.ProcessRequest(HttpContext context) +195 System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +599 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +171

---

Version Information: Microsoft .NET Framework Version:2.0.50727.5420; ASP.NET Version:2.0.50727.5420

We are using 2011 Q3 or the reporting so we know it is not a case of missing the XamlRendering dll (as it is no longer required we believe).

Any help would be appreciated.

Many thanks


Carl Howarth
PSP IT Design & Development

Dear Telerik Support Team,

would it be possible for you to provide with a sample solution on how to generate a report containing a Chart (Lines) that is filled with a SqlDataSource with a multi valued parameter using  the datagroupcolumn value.

I have tried for hours to achieve this but cannot get it to work. The chart does not split the selected values into series or the datasource does not select multiple data.

To recreate the problem the steps would be as follows:

- Create a report with a multi value parameter that accepts instance ids e.g. person ids
- Create a SqlDataSource with the same parameter and pass the reports parameter value to it
- Create a chart and set the DataGroupColumn to the persons id to get a series for each person contained in the datasource
- Execute the preview and select two or more persons via the report parameter
- The chart will only display one series, independant of what is selected as a parameter whereas a crosstable set to the same datasource with column grouping set to the person id will display multiple rows.

I did not add any series explicitly. If I add some series explicitly the legend text will be the explicitly specified name. What I need would be the value of the DataGroupColumn as a Legend entry. The workaround you provide in your example with #NAME:#VALUE does not work as it references the Series name.

Is there a way to tell the Chart which DataSource Columns to use for X,Y, LEGEND if no Series have been defined explicitly?
I have found the PlotArea.XAxis.DataLabelsColumn but nothing for Y or Legend. Is it mandatory to specify series explicitly?

I'd appreciate a quick response,
thank you for your time.

We have purchased Q2 2012 .i have a query in reporting

I need to dyamically bind the columns based on the dataset columns.i have used the sample you have provided, but no luck .
we are not getting any data in reporting panel.

i have created on .aspx page using web form development and used the below shown code.
On button click it has to display 5 rows from the table i have mentioned.
Note: i can see the Getdata() method returns 5 rows in debug mode.But this dataset is not able to bind in report viewer.

what is the wrong in my code.please guide us

ASPX page
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="test.aspx.cs" Inherits="teleriksample.test" %>
<%@ Register Assembly="Telerik.ReportViewer.WebForms, Version=6.1.12.611, Culture=neutral, PublicKeyToken=a9d7983dfcc261be"
    Namespace="Telerik.ReportViewer.WebForms" TagPrefix="telerik" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server"></head>
<body>
    <form id="form1" runat="server">
    <asp:Button ID="Button1" runat="server" Text="Button" onclick="Button1_Click" />
    <telerik:ReportViewer ID="ReportViewer1" runat="server"></telerik:ReportViewer>
    </form>
</body></html>

Code behind part
 public DataTable GetData()
        {
            string conn1 = "Data Source=AES159\\SQLEXPRESS;Initial Catalog=TestDB;User Id=sa;Password=passwd@123;";
            SqlConnection sqlconn = new SqlConnection(conn1);


            string selectCommandText =      "SELECT top 5 * from login_master";

            sqlconn.Open();
            SqlDataAdapter dataAdapter = new SqlDataAdapter(selectCommandText, sqlconn);
            DataTable dataTable = new DataTable();

            dataAdapter.Fill(dataTable);
            sqlconn.Close();
            return dataTable;
        }
        protected void Button1_Click(object sender, EventArgs e)
        {
            Telerik.Reporting.ObjectDataSource objectDataSource = new Telerik.Reporting.ObjectDataSource();
            objectDataSource.DataSource = GetData(); // GetData returns a DataTable
            //objectDataSource.CalculatedFields.Add(new Telerik.Reporting.CalculatedField("FullName", typeof(string), "=Fields.Name + ' ' + Fields.ProductNumber")); // Adding a sample calculated field.

            // Creating a new report
            Telerik.Reporting.Report report1 = new Telerik.Reporting.Report();

            // Assigning the ObjectDataSource component to the DataSource property of the report.
            report1.DataSource = objectDataSource;
            
    
            //// Use the InstanceReportSource to pass the report to the viewer for displaying
            Telerik.Reporting.InstanceReportSource reportSource = new Telerik.Reporting.InstanceReportSource();
            reportSource.ReportDocument = report1;

            //// Assigning the report to the report viewer.
            ReportViewer1.ReportSource = reportSource;

            // Calling the RefreshReport method in case this is a WinForms application.
            //ReportViewer1.RefreshReport();

            ReportViewer1.Visible = true;

        }

regards,
Sanjay

Hi,
I  have a 13- digit number. and i want to create a barcode in report. how can i create this.
i wanted to create a barcode for books.
can anyone help me..


code 128 is working fine with 10 digits..but i need 13 digit or universal for books.
because i tried all sybology .but it did'nt work 

thanks

Hi!

I'm currently working with a sub report, and trying to set the stylename of a textbox dynamically in code based on it's value.

switch (data.Value)
    {
        case "Value1":
            tbxScanState.StyleName = "Stylename1";
            break;
        case "Value2":
                tbxScanState.StyleName = "Stylename2";
                break;
    }

However, it seems that this changes the stylename for tbxScanState in all of the subreports, rather than just the subreport I'm currently working with. Do you know how I might achieve my goal?

Hi..
I'm trying to bind 1 datasource and add another series programmatically.
But my code to add  new series does not show up. If I remove the datasource it does. 
What's wrong with this?   thx!

   SQL = "SELECT  *  TEMP_HUMID_ANALYSIS ";
            


            this.chartTEMP_HUMID.DataSource = new SqlDataSource(DC.Connection.ConnectionString, SQL);
            
// THIS WORKS


// THIS DOES NOT nothing.. if I remvoe the above it works
            // Red Series
            ChartSeries serie1 = new ChartSeries();
            serie1.Name = "Red";
            serie1.Type = ChartSeriesType.Area;
            serie1.YAxisType = ChartYAxisType.Secondary;


            serie1.Appearance.Border.Visible = false;
            serie1.Appearance.FillStyle.FillType = Telerik.Reporting.Charting.Styles.FillType.Hatch;
            serie1.Appearance.FillStyle.MainColor = System.Drawing.Color.Red;
            serie1.Appearance.LegendDisplayMode = ChartSeriesLegendDisplayMode.SeriesName;


            Telerik.Reporting.Charting.ChartSeriesItem item = new Telerik.Reporting.Charting.ChartSeriesItem();
            
            item.XValue = 70;
            item.YValue = 0;


            serie1.AddItem(item);




            item = new Telerik.Reporting.Charting.ChartSeriesItem();


            item.XValue = 68.7;
            item.YValue = 82;


            serie1.AddItem(item);




            item = new Telerik.Reporting.Charting.ChartSeriesItem();


            item.XValue = 80;
            item.YValue = 55;


            serie1.AddItem(item);




            item = new Telerik.Reporting.Charting.ChartSeriesItem();


            item.XValue = 83.3;
            item.YValue = 0;


            serie1.AddItem(item);




            this.chartTEMP_HUMID.Series.Add(serie1);

I am in the process of upgrading from 2008 Q3 reporting tool to 2012 Q1, and am having to find new ways to do what we were doing.

I found this FAQ, and it is essentially exactly what I need to do: http://www.telerik.com/help/reporting/faq-display-pdf-browser.html

It is marked as 2012 Q2...is this new between Q1 and Q2?  How would I do it with the Q1 tools?  The problem I am running into is there does not seem to be a RenderReport method I can use.

Thanks.

Rich

Hi there!

I am trying to use telerik reporting to show customer's invoice table. I want every page with just one customer and one invoice table so I use report group. But I don't know how to set the datasource of the invoice table in every page. Can anyone help me?

My data structure is 

Customer
{
string customer_name;
List<Invoice> invoiceList;
}
 And I pass a List of Customers to report, and want it to show in this way

first page
customer1.name
the table of invoices of customer1
----------
second page
customer2.name
the table of invoices of customer2
----------
third page
.....

Before binding a report to a aspx report viewer, I run the following command:
rpt.Items["detail"].Visible=false;

However, the detail is still shown on the rendered report. Should this work?