Telerik Forums
Reporting Forum
9 answers
282 views
Has anyone else had a problem exporting a report to Excel that generated a dialog box that reads:

Errors were detected in '[filename]', but Microsoft Office Excel was able to open the file by making the reports listed below. Save the file to make the changes permanent.

Damage to the file was so extensive that repairs were not possible. Excel attempted to recover your formulas and values, but some data may have been lost or corrupted.


I am building a report programmatically, not using the designer. But it is a simple, tabular report, and exports perfectly to all the other formats.

The version of Telerik reports is Q2 2008.

Has anyone seen this before?

Thanks,
Kirby
Nasko
Telerik team
 answered on 14 Apr 2014
1 answer
107 views
My Pie chart display #1.  I want to exploded one slice.  Can I do it from the properties sheet?  If not, how I can achieve it? Progamming C# in whitch event?  Example please.
Nasko
Telerik team
 answered on 11 Apr 2014
3 answers
151 views
Just downloaded the Reports trail.  Looked at the quickstart documentation and the VB.NET silverlight example (which runs just fine).

I attempted to replicate the demo on my own, so I created a solution with a report class, a web project, and a silverlight project.  I referenced all the proper dll's per the demo example.  I added the svc file as the documentation described.  The preview of the report class works, it loads and displays records from my database.

After going over it line by line I can find no substantive differences between my project and the demo project but I have 2 problems:

1. The report viewer does not show in the designer.  This is not a big deal but it does show in the demo.

2. when I run the project everything renders fine but the report says 'A report cannot be created form Report1, ReportClassLibrary1', which is the name of the report class and project respectively.

The only difference between the demo and my project is I use a sql data source pointing to a sql server 2008 r2 on a server hosted on my local network.  I put in a simple select Name query against a client table.  As I said the report works in the preview tabs provided by the report designer.

I checked all the paths and names pretty carefully, I can find nothing wrong except what I may be missing because I don't know exactly all the details of how everything fits together (but I have a pretty good idea, I think).

So...what can I try to get this working?  I need be I can upload the sample project I created, but the database will need to be provided and the connection string changed.
Hinata
Top achievements
Rank 1
 answered on 11 Apr 2014
7 answers
345 views
Sorry, could not think of a proper title for this question: I have a customer requirement for an invoice which I have designed and working perfectly. The trouble I am having is that they want a "Terms and Conditions" page to be printed on the back of the invoice (duplex printing) and I am struggling with how and where to add this into the report so it always prints on a seperate page.

The invoice will always be page 1 and will 100% of the time be only 1 page.

I have only recently purchased the report control so I am hoping it is just my newbie brain not knowing how to get this done.

Thank you for your assistance.
Nasko
Telerik team
 answered on 11 Apr 2014
2 answers
787 views
Q1 2014 silverlight

I am using the ObjectDataSource with a business object with this signature:

Public Class TransferReportClass
    <DataObjectMethod(DataObjectMethodType.Select)> _
    Public Function TransferReportList(ByVal sn As String, _
                                       ByVal transferBy As Integer, _
                                       ByVal sortBy As Short, _
                                       ByVal allDates As Boolean, _
                                       ByVal FromDate As Date, _
                                       ByVal ToDate As Date, _
                                       ByVal direction As Short) As List(Of DataTransfer)

If I initialize the parameters in the configure data source wizard the report runs fine.
However I want to pass the paramenters at run time so in RenderBegin I do this:

        args.ParameterValues("sn") = Application.Current.Resources("sn")
        args.ParameterValues("transferBy") = rp.transferBy
        args.ParameterValues("sortBy") = rp.sortBy
        args.ParameterValues("allDates") = rp.allDates
        args.ParameterValues("FromDate") = rp.FromDate
        args.ParameterValues("ToDate") = rp.ToDate
        args.ParameterValues("direction") = rp.direction

When I was rusing a data method that returned a dataset instead of a list as above the report worked fine.
I changed it to return a list of my data bojects becuase I need to do some formating and the class already
handles everything.

when I run the report now I get the following error:

An error has occured while processing Report 'TransferReport':
An error has occured while resolving ObjectDataSource1 data source: cannot convert to type System.Int32

It must be talking about the parameters, so I modified the methods signature in an attempt to appeaise it,
I changed Interger to Int32, Shoert to Int16, and Date to Datetime, with no effect.
Stef
Telerik team
 answered on 11 Apr 2014
3 answers
136 views
I created a crosstable
Rows contains the projects
columns contains persons.
In the value fields i would like the sum of total spend time
At this the total it is returned like 1.04:00:00 (so 1 day and 4hrs)
however i want it in hours only, in this case 28:00:00
Tried to change it by setting the format on the field, but it doesn't work
any suggestions?
Nasko
Telerik team
 answered on 11 Apr 2014
1 answer
104 views
I have a designed report class which is called into another application using a report viewer.
But the problem here is that on page load i want to fill in the report parameter with a value with the code below

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Telerik.Reporting;
using ReportTestss;
using ReportInstantiate;
 
namespace ReportInstantiate
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                test report = new test();
                report.ReportParameters["StudID"].Value = "SCH10001/2013";
            }
        }
    }
}

This code is not working for me.
What can be the issue.
KS
Top achievements
Rank 1
 answered on 11 Apr 2014
9 answers
812 views
Hi Everyone,
I've been getting  this error "PDF rendering format is not available" when I try to use the Telerik.Reporting.Processing.ReportProcessor.Render() method to create a byte array in PDF format that I can feed to the Response.BinaryWrite() method. Here is the code I'm using:

                Dim objUser As Elements.User = Session("User") 
                Dim report As Report = New GuideExport(objUser.QueryResults.XmlDocument) 
                Dim Buffer As Byte() = Telerik.Reporting.Processing.ReportProcessor.Render("PDF", _ 
                                       report, Nothing, "", "", Nothing) 
 
                Response.ClearContent() 
                Response.AppendHeader("content-length", Buffer.Length.ToString()) 
                Response.ContentType = "application/pdf" 
                Response.BinaryWrite(Buffer) 
                Response.Flush() 
                Response.Close() 

The code throws an error on line 3. Strangely enough though, I noticed that when I stop debugging in Visual Studio, then try to access the page, everything works the way that it should...

If anyone knows what is causing this problem, I would love some help. I've just started using Telerik Reporting, and I'm very impressed so far, but this is giving me a headache :)

Thanks,
Jeremy
Fridli Jacober
Top achievements
Rank 1
 answered on 11 Apr 2014
5 answers
727 views
We are using HtmlTextbox for reporting english and arabic data because exporting to word file doesn't work fine with database column directly .Now porblem in htmltextbox is, if data have wild character like  (&, /,$ , ; ) it gives error "An error has accured while processing HtmlTextBox".Kindly gives us solution as soon as possible thanks.
Stef
Telerik team
 answered on 10 Apr 2014
3 answers
385 views
Hi all, I'd appreciate some help with an error I don't understand.  I'm using Visual Studio.
I have two projects: a web site project and a telerik reports project.  The website project uses the reporting project.  Recently, I upgraded my Telerik reporting tools.

Now, I keep getting this error:
"The project currently contains references to more than one version of Telerik.Reporting, a direct reference to version 7.2.13.1016 and an indirect reference (through <project>.<reportName>) to version 7.2.13.1105. Change the direct reference to use version 7.2.13.1105 (or higher) of Telerik.Reporting."

I can't find version 7.2.13.1105 using either the Telerik Control Panel or Google.  I've used the upgrade wizard on both projects, bringing both to 7.2.13.1016.  As far as I can tell, the string "7.2.13.1105" literally doesn't exist in my solution.

Question 1: Can I use the upgrade wizard to "downgrade" the Telerik version, from 7.2.13.1105 in the case of the reporting project, to 7.2.13.1016?  I've already done this for both, and I was told it was successful, but I could understand how it wouldn't downgrade any existing reports.
Question 2: Where is this reference possibly happening?  It's not in any config files, and even the associated resx files for each report giving me the error has the correct Telerik version listed (7.2.13.1016).
Question 3: How did I get version 7.2.13.1105?  Why can't I find it now?
Question 4: How do I fix the error?

Thank you for your help.
Stef
Telerik team
 answered on 09 Apr 2014
Top users last month
Edmond
Top achievements
Rank 1
Iron
fabrizio
Top achievements
Rank 2
Iron
Veteran
RobMarz
Top achievements
Rank 2
Iron
Fakhrul
Top achievements
Rank 1
Iron
Tejas
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?