Telerik Forums
Reporting Forum
3 answers
116 views
Hi,

I have trouble to export currency value to excel.

in a Table Cell, I data bind a double value to a text box, and set format as {0:C2}

It works OK when it's displayed in report viewer, and it looks OK when it is exported to Excel, but if I check the "cell format" in excel, the format is defined as "Custom", the Type is: [$-1010409]$#,##0.00;($#,##0.00)

Our client wants this cell to be exported to the "Currency" type in excel. 

Could you give me some hint on what I can try?

I appreciated any help from you.

Thank you very much.
Nasko
Telerik team
 answered on 28 Jul 2014
5 answers
632 views
Hello,

I created a basic sample of the Telerik ReportViewer with the following tutorial: http://www.telerik.com/help/reporting/mvc-report-viewer-extension-embedding.html

I get the sample running under Chrome/Firefox/ IE10-11.

When I try to run the sample in IE8 I get errors:

first error: JavaScript critical error at line 2329, column 22 in http://localhost:58165/ReportViewer/js/ReportViewer-8.0.14.225.js\n\nSCRIPT1010: Expected identifier

second error: Unhandled exception at line 76, column 21 in http://localhost:58165/  0x800a01b6 - JavaScript runtime error: Object doesn't support property or method 'telerik_ReportViewer'

Any ideas how to fix this?

I also added screenshots of the errors.

Regards


Stef
Telerik team
 answered on 28 Jul 2014
1 answer
224 views
Hi

I am using the standalone report designer to create a report having an Object Data Source. I am trying to extend the designer to include my own class library. My class library is strongly named (i.e. signed). I installed my class library to the GAC and modified the designer's config file runtime section as follows:

  <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
            
      <dependentAssembly>
        <!-- Required for interoperability with older versions of Telerik Reporting -->
        <assemblyIdentity name="Telerik.Reporting" culture="neutral" publicKeyToken="a9d7983dfcc261be"/>
        <bindingRedirect oldVersion="0.0.0.0-8.1.14.618" newVersion="8.1.14.618"/>   
      </dependentAssembly> 

       <dependentAssembly>
                <assemblyIdentity name="MyCustomClassLibrary" culture="neutral" publicKeyToken="b56355033593b42e"/>
      </dependentAssembly>  

    </assemblyBinding>
  </runtime>

Also added the assembly reference as below:

<Telerik.Reporting>
<AssemblyReferences>
<add name="MyCustomClassLibrary" version="1.0.0.0" />
</AssemblyReferences>
</Telerik.Reporting>

The problem is that the library is not being loaded in the object data source list screen. I only managed to make it work for UNSIGNED class libraries located within the standalone designer's folder.
How can I make my strongly-named library installed in the GAC to load please?
Stef
Telerik team
 answered on 28 Jul 2014
7 answers
402 views
Hi, telerik,

I have 1 parent business object which has 4 child list objects which should be printed in subreport.
So I created 1 report with 4 seperate subreport, but spend quite lot of time how to bind witrh business object.
I've read your document and read multiple threads here and tried as followings showed in another thread
but still have no success. When hitting static method to get reportsource,souce is always null.
 
// i'm using needdatasource event to fetch data with report parms
void RptSaleDailyView_NeedDataSource(object sender, EventArgs e)
     {
         Telerik.Reporting.Processing.Report report = (Telerik.Reporting.Processing.Report)sender;
         .
         .
        // fetch data into business objects.
         var list = MyBizObject.GetReportData();
 
         // i'm sure my bisiness object has records for various child objects.
         this.objectDataSource1.DataSource = list;
 
         report.DataSource = this.objectDataSource1;
 
         //// sub report binding
         this.subMainPart.Bindings.Add(new Telerik.Reporting.Binding("ReportSource", "= GetSaleMainPartReportSource(ReportItem.DataObject.DayReportList)"));
    }
 
     public static ReportSource GetSaleMainPartReportSource(object source)
     {
         var report = new RptDailyMainPartView();
         report.DataSource = source;      
        return new InstanceReportSource { ReportDocument = report };
     }

So, I read another thread to set subreport's constructor as follows;

    public RptDailyMainPartView()
        {
            //
            // Required for telerik Reporting designer support
            //
            InitializeComponent();

            this.Bindings.Add(new Telerik.Reporting.Binding("DataSource", "=ReportItem.Parent.DataObject.DayReportList"));


But this touches parent so early before fetching data.
I completly lost a way how to do it. Pls advise me.

Thank you in advance.

Kang







Charles
Top achievements
Rank 1
 answered on 27 Jul 2014
2 answers
73 views
So my project is using the HTML5 report viewer to display reports that were created in the standalone report designer. I noticed that when the request is sent to view the report, that it first does a POST to get the report parameters, and than it does another POST with those report parameters to get the instance of the report. I have a report parameter that I'd rather not be exposed like this, and I was wondering if it's possible to stop it from being displayed. I'll give a short example of what ideally I'd like to be able to do and for simplicity sake, I'll just name my parameters X, Y and Z. 

I make a request for the report, and get back the clientId, then a request goes out for the report parameters and only Y and Z are returned since they're the only visible parameters as far as the client is concerned. When the request for the report instances hits the server with the default values of Y and Z, I preform server logic to figure out what the default value of X is and put it with the other parameters inside the pipeline and an instanceId is returned just like normal. Is this possible? 

The only other way I can think of doing this is to make a report that doesn't take X as a parameter and introduce it into the reportResolver that I have.
Randy
Top achievements
Rank 1
 answered on 25 Jul 2014
2 answers
425 views
I have both the Q1 and Q2 version of the report designer and I noticed a change that you guys made that I'm curious about. In the Q1 version, while you're going through the new report wizard there is an option to change the page settings, which allows you to change the page from portrait to landscape. In the Q2 version however, this option seems to have been removed, and there isn't a great way to change a report that has 'Adjust report items to fit available space' enabled to then take up the new space that switching it to landscape provides. I'd really like to see this feature added back in as it made the process much more simple before to take up all available space.

If however you guys aren't going to put that back in, I'd like to know what the simplest way of doing it after the report wizard. I know how to switch it to landscape in the properties, and I know about the increase horizontal spacing button that sometimes can make it easier to take up the aditional space, but it doesn't always work quite right and fixing each box to take up +/- .1 in is really annoying.
Randy
Top achievements
Rank 1
 answered on 25 Jul 2014
1 answer
84 views
Hi

I'm using Visual Studio 2012 and Telerik Reporting Q1 - 2013. I'm using this version because of the support for framework 3.5

Anyway, I created a class library, I added a Telerik report, I added a datasource, I created a table with a couple of columns. Everything worked just fine.
Later, when I added more columns, they are not shown in the preview, or HTMl preview. If I publish the report , they are shown on the production server.

If I restart the computer, the columns are shown in the preview, but if I add new columns, they are not shown in preview. Only if I restart the computer.
It seems there is a cache somewhere .

How can I fix this problem ?

Regards
Hans
Stef
Telerik team
 answered on 25 Jul 2014
1 answer
551 views
I'm adding columns to a report dynamically. When one of the textboxes wraps its text, the other textboxes on the same row are not resizing to match the height. How do I fix this?
Stef
Telerik team
 answered on 25 Jul 2014
1 answer
360 views

Hello,
I have a table in a report where the text of the header of one column must contain an expression. The problem is that the DataSource of the table is set to the table data. So how can I accomplish this?

Detailed information:
1. The table contains a ranking.
2. The table contains one column with amounts (earnings for the team).
3. The currency of the amounts is set at a higher level (tournament). It depends on the place where the tournament is played.
4. I would like the header to display Prize (EUR) or Prize (USD)
Currently this is done by code, but I would like to know if it's possible to do it with an expression.

Patrick

Nasko
Telerik team
 answered on 24 Jul 2014
5 answers
690 views
I support a system that uses a VB.NET Reporting client that attaches to an Oracle 11g database running on a Linux server.  We would like to use the standalone Report Designer as a supplement to our canned reports so that 'Power Users' can query the database to get the data they are after.

All of the support documentation on connection strings refers to SQL server running locally.  None of the documentation mentions Oracle.  I am wondering if the standalone Report Designer can attach to an Oracle database on a Linux server if given the correct connection details.

If so, could you please provide a sample connection string for connecting to Oracle databases.

Thanks in advance.
KS
Top achievements
Rank 1
 answered on 24 Jul 2014
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?