Telerik Forums
Reporting Forum
2 answers
172 views
Hi Team

I need to hide all the export options from Report viewer except (PDF and XLS). I had done below changes in web.config. It works fine in my local machine. But It does not work in Deployed link.

In one of the thread I understood that we need to deploy Telerik.Reporting.XpsRendering.dll. I have added this dll in bin folder of deployed code. But still I get the exception.

Please help me what's wrong with this code??


    <section
            name="Telerik.Reporting"
            type="Telerik.Reporting.Processing.Config.ReportingConfigurationSection, Telerik.Reporting,  Version=5.1.11.928, Culture=neutral, PublicKeyToken=a9d7983dfcc261be"
            allowLocation="true"
            allowDefinition="Everywhere"/>

<Telerik.Reporting>
    <Extensions>
      <Render>
        <Extension name="IMAGE" visible="false"></Extension>
        <Extension name="XLSX"  visible="false"></Extension>
        <Extension name="RTF"   visible="false"></Extension>
        <Extension name="PPTX"  visible="false"></Extension>
        <Extension name="DOCX"  visible="false"></Extension>
        <Extension name="CSV"   visible="false"></Extension>      
        <Extension name="MHTML" visible="false"></Extension>
        <Extension name="XPS"   visible="false"></Extension>
      </Render>
    </Extensions>
  </Telerik.Reporting> 
Sharan
Top achievements
Rank 1
 answered on 26 Jul 2012
0 answers
167 views

Hi,

I have a user function bound to my report to position the PictureBox.

public static  PointU Location(int _position)

{

    double position = _position;

    return new PointU(new Telerik.Reporting.Drawing.Unit(position, UnitType.Pixel), new Telerik.Reporting.Drawing.Unit(65, UnitType.Pixel));

}

The problem I am continually having is that sometimes this works and sometimes it does not! I get the error in the report that the function ‘Location’ cannot be found in red where the Logo - PictureBox should be.
When I print the report, the first two attempts I get the error but on the third attempt it works correctly!! Could there be a problem when loading the image, the report is trying to display it before it is fully uploaded ?

The picture value I bind to the Uri read out of a database. Sometimes this also does not work and sometimes it does, message cannot find or locate picture.

 

If you can advise me why this is so, so I can correct it that would be grate.

 

Thanks very much

Wayne

Wayne
Top achievements
Rank 1
 asked on 26 Jul 2012
1 answer
217 views
Hi ,

I am trying to pass report parameters to an oracle query.....by using this query in sql data source

select *
from  customer
where
 (CustomerShop=:v_customer_Shop)

When I try to pass in value to the V_customer_shop it does not return any records  even though it has records in the table.

I am passing the v_customer_shop as String type should i change that..Is there a special string type for oracle parameters..Please guide me..
Thank you
 
Ravi
Top achievements
Rank 1
 answered on 25 Jul 2012
3 answers
82 views
Hello,

I am working with the Telerik reporting tool. I have created a page, where are displayed 4 charts (1 RadChart & 3 HTMLChart).
I was wondering if it would be possible to put this entire page inside a report (like it was a printscreen or something like that).

I have created those charts with codebehind. Series are added with LINQ queries, and i would like to allow the user to do PDF export, for example.

Many thanks for your help !
PS : Sorry for the mistake inside the title :p
Steve
Telerik team
 answered on 25 Jul 2012
1 answer
154 views
Hi,

I'm using crosstab to create a report like below:

Inv. No .  Bill Amt.    Receipt No. Receipt Amt.  Balance  Running Balance
Inv 001    2000.00    D001             1000.00       0.00             0
                                 D002              500.00        500.00      500.00
Inv 002    5000.00     D003            2000.00       3000.00     3500.00
Inv 003    100.00      D004                100.00      0.00            3500.00
      Total:7100.00                         3600.00                           3500.00

I cannot find any useful resources.
Please get back to me asap as this is very urgent.

Thanks.  
Steve
Telerik team
 answered on 25 Jul 2012
0 answers
107 views
Hi all gurus.
I'm tryin'to get a total from a subreport (sr2), which in turn is called from another one (sr1). sr2 is filled with an sql query driven by parameters from sr1. sr2 shows a subreport total for a field(totSrv). I need this total to be, in turn, summarized and shown in sr1 (a subreport that shows infos from a practice for a given customer, whose general infos are shown in the main report (rpt1).
I managed to have totals raised to sr1 via a RaiseEvent, fired from textboxnn_ItemDataBinding in sr2, and summarized in sr1. However, I've not been able to use this total; I tried summarizing the total in the event "sr2_TotUpdated" of sr1, and got a correct value, given the value to a parameter (accessed thru ReportParameters("Tot_Servizi") function), but when this parameter is bound to a field in the report's footer, it shows a value of 0. For sure I don't follow the right track, so pls can Y help me to get the right way? Thanks in advance, have a nice day.

Saverio Tedeschi
Tesis52
Top achievements
Rank 1
 asked on 25 Jul 2012
2 answers
140 views
Hi telerik,

I'm getting the following error when adding the ReportViewer control to a Silverlight Usercontrol. This control lives inside a Silverlight Class Library. I've added the reference to Telerik.ReportViewer.Silverlight.

Am I forgetting something?

Error HRESULT E_FAIL has been returned from a call to a COM component.
   at MS.Internal.XcpImports.MethodEx(IntPtr ptr, String name, CValue[] cvData)
   at MS.Internal.XcpImports.MethodPack(IntPtr objectPtr, String methodName, Object[] rawData)
   at MS.Internal.XcpImports.Collection_Add[T](PresentationFrameworkCollection`1 collection, Object value)
   at System.Windows.PresentationFrameworkCollection`1.AddImpl(Object value)
   at System.Windows.PresentationFrameworkCollection`1.System.Collections.IList.Add(Object value)
   at Microsoft.Expression.DesignModel.InstanceBuilders.ClrObjectInstanceBuilder.InstantiateChildren(IInstanceBuilderContext context, ViewNode viewNode, DocumentCompositeNode compositeNode, Boolean isNewInstance)

Regards,
Daniel
Daniel Plomp
Top achievements
Rank 2
 answered on 25 Jul 2012
1 answer
142 views
For the past few weeks, I've been posting threads that have gotten progress, but  I think I hit a wall that if I can get over, will complete my project. So here it goes:

I have a rowset of data that i want to deflatten.
Example:
gid, gname, uid, uname
I want it to have users(uname) grouped by the group(gname) they belong to.  The problem I'm having is since the 1 rowset i pass to every datasource for each subreport i need, the data duplicates according to the number of rows to that rowset.So if i have group A  with 5 members and group B with 3 members. group A repeats 5 times and B 3 times.

Any help with this would be great!
Gersh
Hadib Ahmabi
Top achievements
Rank 1
 answered on 25 Jul 2012
3 answers
103 views
I have a table with the following data
CODE  |  VALUE
-----------------------
100      | MIKE
100      | JOHN
200      | MIKE
200      | JOHN
200      | FRED

I'd like to be able to show the data in the following form:
CODE | VALUE1 | VALUE2| VALUE3
---------------------------------------------
100     | MIKE      | JOHN    |
200     | MIKE      | JOHN    | FRED

I thought this was what a cross tab could be used for but think I'm mistaken. Does anybody know how I could achieve this?


Hadib Ahmabi
Top achievements
Rank 1
 answered on 25 Jul 2012
3 answers
370 views
HI,

I create a .aspx file and try to open in design mode, my VS 2010 doesn't respond.
Did any one face this kind of problem. Is this because of telerik? It worked fine until yesterday when this happened.

The reason i need design mode is because i need to create a partial view and add telerik report viewer to the partial view in design mode.
If i add the code to add the telerik report viewer in source code it doesn't work.

<%@ Register assembly="Telerik.ReportViewer.WebForms, Version=6.1.12.611, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" namespace="Telerik.ReportViewer.WebForms" tagprefix="telerik" %>




        <script runat="server">
        
            public override void VerifyRenderingInServerForm(Control control)
            {
                // to avoid the server form (<form runat="server">) requirement
            }


            protected override void OnLoad(EventArgs e)
            {
                // bind the report viewer
                base.OnLoad(e);
       
            }


        </script>
   
       <form id="form1" runat="server">
       <telerik:ReportViewer ID="ReportViewer1" runat="server" Width="100%">
<typereportsource 
           typename="WebEnrollment.Public.Web.Reports.ByProductReport, WebEnrollment.Public.Web, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null"></typereportsource>
</telerik:ReportViewer>
</form>

It throws runtime exception

System.Web.HttpCompileException was unhandled by user code

  Message=c:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\webenrollment.public.web\185985ee\24be7516\App_Web_productviewpage.aspx.b76dddab.hrocxo6x.0.cs(245): error CS0234: The type or namespace name 'Reporting' does not exist in the namespace 'Telerik' (are you missing an assembly reference?)

Steve
Telerik team
 answered on 25 Jul 2012
Top users last month
Rob
Top achievements
Rank 3
Bronze
Bronze
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?