Questions on Reporting Forum

1 answer

137 views

how to do change report viewer icon (print,export etc.)

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

Report Designer (standalone)

answered on 28 Oct 2013

1 answer

273 views

how to do change report viewer icon (print,export etc.)

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

General Discussions

answered on 28 Oct 2013

1 answer

123 views

telerik reporting is not accessable

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

General Discussions

answered on 28 Oct 2013

9 answers

806 views

Format of the initialization string does not conform to specification starting at index 0.

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">

form#form1, div#content

{

height: 100%;

}

</style>

</

head>

<

body>

//Put your Java Script code here.

</script>

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

SelectCommand="SELECT dbo.vw_promotion_code.*

FROM dbo.vw_promotion_code">

</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

General Discussions

answered on 27 Oct 2013

2 answers

101 views

Controlling reportviewer height in usercontrol

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

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

General Discussions

answered on 25 Oct 2013

5 answers

760 views

Best practice for adding dynamic PictureBox

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?

General Discussions

answered on 25 Oct 2013

2 answers

179 views

conditional watermark crash during runtime

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>

General Discussions

answered on 25 Oct 2013

6 answers

146 views

External parameters

How can i send in additional external parameters based on other factors into teh report.

Lets say user can log in only as one group and the report has to set up so it will give only the right parameters to filter the data on.

Thanks

General Discussions

answered on 25 Oct 2013

1 answer

77 views

Can i give rotaion angle DataPointlabel in chart ?

I want to give rotaion angle DataPointlabel in chart .
According to http://www.telerik.com/help/reporting/graphformatseries.html it can be done by setting DataPointLabelAngle Property.but i couldn't fin the property .

Report Designer (standalone)

answered on 25 Oct 2013

3 answers

228 views

Cube Data Source Component

By using the Cube Data Source Component (SSAS) how to retrive the data in order to bind the Crosstab wizard in Telerik Reporting Q2 2011 using Vb code. I need the Explation in detail.

General Discussions

answered on 24 Oct 2013