Questions on Reporting Forum

9 answers

897 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

127 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

875 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

214 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

176 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

107 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

272 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

1 answer

253 views

Customized Export Items & Hide Items in Telerik Silverlight Report Viewer

Hi,
I have some issue with my telerik silverlight report viewer control:

1) How can I remove some export items in telerik silverlight report viewer toolbar.
(I need to show only PDF, Image, Excel entry don't want other like CSV, RTF, Web Archive etc)
Note : The items are carry report to report like in my report ABC it will show only export items are PDF, Image, Excel. And in report XYZ show only CSV, Excel.

2) How to hide some toolbar items in report viewer.
I want to hide/remove first two items which is never enabled (previous/next button) and "Click to close parameters area" button.

I tried the <configSections> entry in my TestProject.web's web.config file, but no luck.
<configSections>
    <section name="Telerik.Reporting" type="Telerik.Reporting.Processing.Config.ReportingConfigurationSection, Telerik.Reporting,    Version=7.1.13.802, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" allowLocation="true" allowDefinition="Everywhere"/>
</configSections>
<Telerik.Reporting>
    <Extensions>
      <Render>
        <Extension name="IMAGE" visible="true"/>
        <Extension name="PDF" visible="false"/>
        <Extension name="RTF" visible="true"/>
        <Extension name="XPS" visible="true"/>
        <Extension name="XLS" visible="true"/>
      </Render>
    </Extensions>
</Telerik.Reporting>

Thanks
Chandan

General Discussions

answered on 24 Oct 2013

2 answers

190 views

DataPointlabel Overlapped very Badly.

I am working on your standalone tool for making reports.
Its working fine... in fact excellent....But....
When i make this report (Attached image) DataPointlabel Gets Overlapped .
i don't find any property to make them auto ??
is there is any solution for this problem ?
P>S> :- I also attached another image showing the version of the tool i am working on.

Report Designer (standalone)

answered on 24 Oct 2013

5 answers

314 views

Some reports do not display in list when selecting ReportSource Object Instance and browsing for report document

Hi, we are using Q3 2012 Reporting, and have a class library that contains all our reports. We are creating sub reports and in our main report, in the sub-report properties tab, click ReportSource, and then select Object Instance, and finally, select document from the drop down. The resulting list only contains some, but not all of the reports in our report class library. Why is this so?

General Discussions

answered on 23 Oct 2013