Telerik Forums
Reporting Forum
3 answers
138 views
I'm wondering if anyone else is having this problem. Every attempt I've made at running a report in the new viewers is rendering something similar to this, using just the js version or the MVC helper. If you look at the js, it seems to be parsing out the attributes of elements incorrectly in whatever process generates the html for the actual report. I haven't seen any other complaints, but I'm not getting it to work even with the given project. I really would like to be able to implement this tool for one of our upcoming projects.

EDIT: I just tried it in 2012 and it did work. I guess when I seen the 2013 solution file, I figured it would work the same. Any thoughts on why this is happening in 2013? The rest of our solution has already been migrated to a 2013 project.
Stephen
Top achievements
Rank 1
 answered on 30 Oct 2013
1 answer
62 views
hello , 
how can i export telerik report into Excel 2007 format ? actualy i have Excel 97-2003 . i am using telerik reportin 2013 Q2 . 

best regards
Stef
Telerik team
 answered on 29 Oct 2013
1 answer
126 views
Hello

This is my first question in the community .

See if you can help me.

I have a DataSet with this extrutura :
DsReportModel
-> Noconta
- > Descr
- > Month
- > Value
-> Variation


By creating a simple report to display the data, it looks like this:

noconta----descr --- month ------value --- variation
1.1-----------Account1-----1-----------10.00-------0
1.2-----------Account2-----1-----------12.00-------2
1.3-----------Account3-----1-----------11.00-------1
1.4-----------Account4-----1-----------16.00-------4
2.1-----------Account5-----1-----------12.00-------2
2.2-----------Account7-----1-----------12.00-------6
2.3-----------Account8-----1-----------11.00-------7

1.1-----------Account1-----2------------11.00------3
1.2-----------Account2-----2------------16.00------2
1.3-----------Account3-----2------------17.00------1
1.4-----------Account4-----2------------18.00------7
2.1-----------Account5-----2------------10.00------8
2.2-----------Account7-----2------------11.00------2
2.3-----------Account8-----2------------12.00------1


I would like to create a report to display the information as follows:
noconta----descr --- | $ month1 | variation month1 | - | $ month2 | variation month2 |
1.1-----------Account1-----10.00-------------------0-----------------11.00-------------------3
1.2-----------Account2-----12.00-------------------2-----------------16.00-------------------2
1.3-----------Account3-----11.00-------------------1-----------------17.00-------------------1
1.4-----------Account4-----16.00-------------------4-----------------18.00-------------------7
2.1-----------Account5-----12.00-------------------2-----------------10.00-------------------8
2.2-----------Account7-----12.00-------------------6-----------------11.00-------------------2
2.3-----------Account8-----11.00-------------------7-----------------12.00-------------------1

In the DataSet , it is possible that the information for the month does not always start in one month because the data comes from a selection of the user can choose the report from the month 7 - and month 12 , in which case the DataSet would only information of 7 months until month 12.

I appreciate any help or suggestion .


Note :
I'm using C # .

Thank“s
Nasko
Telerik team
 answered on 29 Oct 2013
1 answer
144 views
Hi everyone

my question.

how to do change telerik report viewer or report (in class library) icons.

print icon,export icon,next previous icon etc..

note : I'm using ASP.NET for Visual studio 2012
Stef
Telerik team
 answered on 28 Oct 2013
1 answer
286 views
Hi everyone

my question.

how to do change telerik report viewer or report (in class library) icons.

print icon,export icon,next previous icon etc..

note : I'm using ASP.NET for Visual studio 2012
Stef
Telerik team
 answered on 28 Oct 2013
1 answer
128 views
   i here to say that i have installed telerik reporting and after installing it  i am not able to explore it.


getting some type of error  as mentioned in the attached screenshot 

Ivan Hristov
Telerik team
 answered on 28 Oct 2013
9 answers
832 views
An error has occured while processing Report '':
Format of the initialization string does not conform to specification starting at index 0.

I get this error message when I disable "report1.DataSource = SqlDataSource1". But there is same SqlDataSource1 in the report file (vwReport2010/test0318) already. And I can see the preview report on report design mode.

When I enable  "report1.DataSource = SqlDataSource1", it works. Does it mean I have to add same SqlDataSource in the web form every time?

Defalult.aspx:

<%

@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>

 

<%

@ Register Assembly="Telerik.ReportViewer.WebForms, Version=4.0.10.310, 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">

 

 

<title></title>

 

 

<style type="text/css">

 

 

form#form1, div#content

 

{

 

height: 100%;

 

}

 

</style>

 

</

 

head>

 

<

 

body>

 

 

<form id="form1" runat="server">

 

 

<script type="text/javascript">

 

 

//Put your Java Script code here.

 

 

</script>

 

 

<div id="content">

 

 

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:VenueWest2007ConnectionString %>"

 

 

SelectCommand="SELECT dbo.vw_promotion_code.*

 

FROM dbo.vw_promotion_code">

 

<SelectParameters>

 

 

</SelectParameters>

 

 

</asp:SqlDataSource>

 

 

<telerik:ReportViewer ID="ReportViewer1" runat="server" Height="100%" Width="100%">

 

 

</telerik:ReportViewer>

 

 

</div>

 

 

</form>

 

</

 

body>

 

</

 

html>

Default.vb:

 

Imports

 

Telerik.Web.UI

 

 

 

Imports

 

vwReport2010

 

 

 

Imports

 

System.IO

 

 

 

Partial

 

Class _Default

 

 

Inherits System.Web.UI.Page

 

 

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

 

 

If Not Page.IsPostBack Then

 

 

 

 

 

Dim report1 As New test0318

 

 

'report1.DataSource = SqlDataSource1

 

 

 

 

ReportViewer1.Report = report1

 

End If

 

 

 

 

 

End Sub

 

End

 

Class

 

Mark
Top achievements
Rank 1
 answered on 27 Oct 2013
2 answers
109 views
Hello,

I've got a reportviewer in a usercontrol and each page that displays the user control sets a flag to change the height/width to show the correct size for portrait or landscape, depending on the report being shown.  Up until now, this has worked fine.

Since moving to IE10 and also setting the masterpage to use <!DOCTYPE html> instead of the usual transitional, etc, I've had to add specific style into each page to force the size accordingly, eg for protrait

<style type="text/css">

div#MainContent_repView1_ReportViewer, #MainContent_repView1_ReportViewer_ReportArea_ReportArea, #MainContent_repView1_ReportViewer_ReportTable, #MainContent_repView1_ReportViewerReportFrame

{

height: 1200px;

}

</style>


Obviously this is not ideal as it is no longer controlled simply by my portrait/landscape flag.

Any suggestions on how this could be easily controlled by the usercontrol so I don't have to keep putting this onto each page?
The only way I can think of is to have two report viewers on the one usecontrol and use whichever one is appropriate.

Thanks

Cheryl
KS
Top achievements
Rank 1
 answered on 25 Oct 2013
5 answers
797 views
I have a report that has a PictureBox on it which I am using for an employee signature. I store the signature in the SQL server as a varbinary(max). The employee signature will be different for every report and is returned in the SqlDataSource for the report. I recently started getting a ""Parameter Not Valid" exception when rendering the report as a pdf and had to reboot the IIS server to get the report to render again. I must either be doing something wrong or not using the best practice for this scenario.  Here is how I am importing the bmp signature to the table in SQL server:

UPDATE [HR_Employees]
SET  EmployeeSignature = (SELECT BulkColumn FROM OPENROWSET(
            Bulk 'C:\Signatures\Justin.bmp', SINGLE_BLOB)AS BLOB)
            WHERE EmployeeNumber = '99999'

Here is how I am rendering the report to pdf:
public ActionResult PrintPoReport(string id)
       {
           var irs = new InstanceReportSource();
           irs.ReportDocument = new LogisticsReports.PoHeader();
           irs.Parameters.Add(new Parameter("PoID", id));
           Telerik.Reporting.Processing.ReportProcessor rp = new Telerik.Reporting.Processing.ReportProcessor();
           Telerik.Reporting.Processing.RenderingResult result = rp.RenderReport("PDF", irs, null);
           byte[] contents = result.DocumentBytes;
           return File(contents, "application/pdf", "P0 #" + id + ".pdf");
 
       }

I think it is the signature block causing the issue but I could be wrong. Any suggestions as to how to properly add a bmp file to a report dynamically?
IvanY
Telerik team
 answered on 25 Oct 2013
2 answers
186 views
The watermark shows fine in the designer using Print Preview.
During runtime there is a crash.

<
Watermarks>
        <TextWatermark Text="= Elixir.App.Reports.DataSources.LoadIsPreliminary(Parameters.site.Value, Parameters.load_key.Value).ToString()" Color="Red" Orientation="Diagonal" Position="Front" Opacity="0.1" PrintOnFirstPage="True" PrintOnLastPage="True">
          <Font Name="helvetica" Size="60pt" />
        </TextWatermark>
      </Watermarks>



using Telerik.Reporting.Expressions;

namespace Elixir.App.Reports.DataSources
{
    class BolFunctions: Telerik.Reporting.Report
    {
        /// <summary>
        /// Is this load preliminary?
        /// 
        /// User function for Telerik reports
        /// </summary>
        /// <param name="site"></param>
        /// <param name="loadKey"></param>
        /// <returns></returns>
        [Function(IsVisible = true, Category = "WatermarkTest", Description = "Testing", Namespace = "Elixir.App.Reports.DataSources", Name="LoadIsPreliminary")]
        public static string LoadIsPreliminary(string site, string loadKey)
        {
            // Would actually prefer that this function  return a bool
            // and let the report output a non-blank watermark if true, otherwise no watermark.

            // Would like to have another boolean function as well, LoadIsSpecialCase2, etc.

            return "This is another test";
           
        }
    }

}
preferred watermark:
<Watermarks>
        <TextWatermark Text="= IIf(Elixir.App.Reports.DataSources.BolReportInfo.LoadIsPreliminary(Parameters.site.Value, Parameters.load_key.Value), &quot;PRELIMINARY&quot;&#xD;&#xA;    IIf(Elixir.App.Reports.DataSources.BolReportInfo.LoadIsCancelled(Parameters.site.Value, Parameters.load_key.Value), &quot;CANCELLED&quot;&quot;&quot;))" Orientation="Diagonal" Position="Front" Opacity="0.1" PrintOnFirstPage="True" PrintOnLastPage="True">
          <Font Name="helvetica" Size="60pt" />
        </TextWatermark>
      </Watermarks>

Stef
Telerik team
 answered on 25 Oct 2013
Top users last month
Rob
Top achievements
Rank 3
Bronze
Iron
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?