Telerik Forums
Reporting Forum
5 answers
928 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
239 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
6 answers
195 views
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
 
Chavdar
Telerik team
 answered on 25 Oct 2013
1 answer
116 views
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  .
Gaurav
Top achievements
Rank 1
 answered on 25 Oct 2013
3 answers
279 views
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.
KS
Top achievements
Rank 1
 answered on 24 Oct 2013
1 answer
269 views
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
Stef
Telerik team
 answered on 24 Oct 2013
2 answers
197 views
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.
Gaurav
Top achievements
Rank 1
 answered on 24 Oct 2013
5 answers
343 views
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?
Stef
Telerik team
 answered on 23 Oct 2013
3 answers
781 views
Hello,

I need to place image in the html control in the Telerik Report. Please help me to find it.

Thanks
Siva
Nasko
Telerik team
 answered on 23 Oct 2013
1 answer
127 views
Is there any movement on getting the documentation for the Reporting product in MSHelp3 format?
Stef
Telerik team
 answered on 23 Oct 2013
Top users last month
Simon
Top achievements
Rank 2
Iron
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Grant
Top achievements
Rank 3
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?