Telerik Forums
Reporting Forum
1 answer
144 views
Hey there,

just a quick Question:
Is it possible to programmatically change a report that is being generated by the Telerik Reporting REST Service?
The ItemDataBinding or needDatasource events to which I can subscribe when resolving the report are unfortunately not fired.

To be more specific, I would need to alter a datasource of a report depending on the passed report parameter values.

I have a DataSource which takes multivalue parameters but it is possible that those Lists are empty. Currently the DataSource will be empty in that case so I'd like to be able to change the SQL and remove the parameters which are empty.

Thank you for your help!

Regards,
Kris
Peter
Telerik team
 answered on 30 Oct 2013
3 answers
145 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
73 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
134 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
149 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
297 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
130 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
848 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
116 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
838 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
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?