Telerik Forums
Reporting Forum
3 answers
85 views
Hi all,

Suppose I want to apply a transformation specific to the output document format. Specifically, I need to format certain cells in the xslx table: say, all cells except the first one in a certain column formatted as dates, all cells in a certain row formatted as having a thick black border at the bottom, and so on. These transformations only apply to the xslx and not to any other output formats.

What would be the recommended way to achieve this?

Thank you!
Nasko
Telerik team
 answered on 07 May 2014
5 answers
450 views
Hello!

I'm learning Telerik Reporting and today i found an example how to get a value from textbox in subreport and set this value to master report textbox. 

When i did this example in silverlight project with wcf ria services i get an error in ItemDataBound event.

My code for textBox1 ItemDataBound event is this
private void textBox3_ItemDataBound(object sender, EventArgs e)
        {
            Telerik.Reporting.Processing.TextBox textBox1_1 = (Telerik.Reporting.Processing.TextBox)sender;
            Telerik.Reporting.Processing.Report oReport = textBox1_1.Report;
            Telerik.Reporting.Processing.DetailSection oDetailSection = (Telerik.Reporting.Processing.DetailSection)oReport.ChildElements.Find("detail", true)[0];
            Telerik.Reporting.Processing.SubReport oSubReport = (Telerik.Reporting.Processing.SubReport)oDetailSection.ChildElements.Find("subReport1", true)[0];
            //Telerik.Reporting.Processing.DetailSection oSubReportDetailSection = (Telerik.Reporting.Processing.DetailSection)oSubReport.ChildElements.Find("detail", true)[0];
            Telerik.Reporting.Processing.TextBox oSubReportTextBox = (Telerik.Reporting.Processing.TextBox)oSubReport.InnerReport.ChildElements.Find("textBox1", true)[0];
            textBox1_1.Value = oSubReportTextBox.Value;
        }
But i get error in this line Telerik.Reporting.Processing.TextBox oSubReportTextBox = (Telerik.Reporting.Processing.TextBox)oSubReport.InnerReport.ChildElements.Find("textBox1"true)[0];
It says that ther is no InnerReport (null) but i set a subreport1.ReportSource to my subreport in design viewer.

I subreport i have only detail section with two textboxes (one with simple text and one with =5*5 calculation). 

What am i doing wrong? 
Stef
Telerik team
 answered on 06 May 2014
2 answers
68 views
In the properties window of a telerik event, I am trying to set detail_ItemDataBinding event and I noticed that Events Tab is missing.  I am using Telerik Reporting Q1 2014 version as an admin. I am using VS 2010 and my OS is 32 bit and I am using Windows 7. I did not find any posts related to this issue. Your response is highly appreciated.
Harika
Top achievements
Rank 1
 answered on 06 May 2014
1 answer
166 views
Hello everyone! I was able to make the HTML5 page report template from this guide http://www.telerik.com/help/reporting/html5-report-viewer-embedding.html and was able to produce this:


Now, what I wanted to do is to deploy .trdx report to this template. Please please someone answer this query. Thank you so much!
Stef
Telerik team
 answered on 06 May 2014
1 answer
184 views
Hello together,

I have an issue - like many other had before - but with recommended solutions... I could not fix it.
I run into "To prevent possible data loss before loading the designer, the following errors
must be resolved" issue.
I was setting up a new laptop - as harddrive crashed on old one. I recovered all files via MS TFS. I can build and run application - without any issues. But when i try to open it in designer... I get the error message.
I used already upgrade wizard, deleted old resx files, closed app, reboot etc. none of them helped.

Attached is the Call Stack.
I use Win 8.1, VS2012 and Telerik Rep Q1/2014. All with latest updates.
The issue happens on all reports - made with Telerik Reporting.

Any ideas how to fix it?
Thanks
Bjoern
Stef
Telerik team
 answered on 06 May 2014
3 answers
74 views
I need to display formatted (bold, italic, color and font) text in a single report field.

I see that in the UI for silverlight suite there is a richtext WYSIWYG editor.  I also see that reports supports an HTML textbox.

I currently have letters in RTF that I need to render in the reports, but there seems to be no RTF textbox for reports.

So I have a delimea, ideally I could use an RTF Textbox for reports, as a second choice I need an HTML WYSIWYG silverlight UI editor,
and thats assuming I can convert my existing RTF to HTML.

There are other 3rd party HTML silverlight editors, but I would rather use RTF, and I'd rather deal with only one vendor.

Is there any way to render RTF in a report?

Do you have an HTML silverlight editor?

Nasko
Telerik team
 answered on 06 May 2014
3 answers
90 views
Hi,

I have a multiple page report that uses RadGridView to organize the data. When I try to export it to excel, it only exports the current page, and not the whole thing. Is there a way to go through each page and export it all to one document? I tried setting the ItemSource for the button to be the entire Results set instead of the CurrentBatchResults but it still only gives me the current page. 

Only the first page is generated at first, and subsequent pages are generated upon clicking to the next page due to performance issues. These reports often look at tens of pages at 100 rows per page, so to generate it all on one page would take too long for our users. Any ideas?
Stef
Telerik team
 answered on 05 May 2014
25 answers
549 views
I have updated to Telerik Reporting Q1 2013 build 7.0.13.220 and can not get WPF Report Viewer to run.

I have created a fresh WPF Application project and the only usercontrol contains a dragged on ReportViewer control.

I have confirm that references also contain Telerik.ReportViewer.WPF Q1 2013 build 7.0.13.220 as well.

At runtime of this simple WPF applicaton I am getting "Set property 'System.Windows.ResourceDictionary.DeferrableContent' threw an exception." thrown.

Any suggestion on how best to overcome this is welcomed.

Thank you,
Mandar
Top achievements
Rank 1
 answered on 03 May 2014
2 answers
344 views
Dear All,

For some days now I am struggling with a problem to export my report to PDF.
using the command  "ReportViewer2.ExportReport("PDF", deviceInfo)" there is no problem but I want to name the report  and the location dynamically.

using this code

    Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
        Dim savepath As String
        Dim reportProcessor As New Telerik.Reporting.Processing.ReportProcessor()

        'set any deviceInfo settings if necessary
        Dim deviceInfo As New System.Collections.Hashtable()

        Dim typeReportSource As New Telerik.Reporting.TypeReportSource()

        ' reportName is the Assembly Qualified Name of the report
        typeReportSource.TypeName = "Factuur3"

        Dim result As Telerik.Reporting.Processing.RenderingResult = reportProcessor.RenderReport("PDF", typeReportSource, deviceInfo)
        Dim fileName As String = result.DocumentName + "." + result.Extension
        Dim path As String = System.IO.Path.GetTempPath()
        Dim filePath As String = System.IO.Path.Combine(path, fileName)

        Using fs As New System.IO.FileStream(filePath, System.IO.FileMode.Create)
            fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length)
        End Using


        savepath = "c\testdir\facturen\"

    End Sub

is giving me an error "Invalid reporttype"

Anyone any suggestions?


Juan
Top achievements
Rank 1
 answered on 02 May 2014
4 answers
213 views
Hi All,
I'm new on using Telerik Reports. I'm just wondering how can I get the ObjectDatasource of my Master to my Subreport.
I have used this code from the documentation and it works fine when I use it directly to a report but when its being used to a master, cant seem to pass the datasource.

​ Dim objectDataSource As New Telerik.Reporting.ObjectDataSource()
    objectDataSource.DataSource = GetMyData() ' GetData returns a SqlDataAdapter object which has a select command with three SELECT statements.
    objectDataSource.DataMember = "Table2" ' Indicating the exact table to bind to. If the DataMember is not specified the first data table will be used.
    objectDataSource.CalculatedFields.Add(New Telerik.Reporting.CalculatedField("FullName", GetType(String), "=Fields.Name + ' ' + Fields.ProductNumber")) ' Adding a sample calculated field.

    'Creating a new report
    Dim report As New Telerik.Reporting.Report()

    ' Assigning the ObjectDataSource component to the DataSource property of the report.
    report.DataSource = objectDataSource

    ' Use the InstanceReportSource to pass the report to the viewer for displaying.
    Dim reportSource As new InstanceReportSource
    reportSource.ReportDocument = report

    ' Assigning the report to the report viewer.
    reportViewer1.ReportSource = reportSource

    ' Calling the RefreshReport method in case this is a WinForms application.
    Me.reportViewer1.RefreshReport()


Please note that using vb code, Report Q3 2013 and I wonder why Subreport.ReportSource.Datasource is not available
Any help would greatly appreciated,
Thanks in advance,
RJ
KS
Top achievements
Rank 1
 answered on 02 May 2014
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?