Telerik Forums
Reporting Forum
1 answer
74 views

If the Report Name contains German umlauts, it is impossible to export the report as e.g. PDF.

The problem just occurs when using Internet Explorer (I use IE 11).

Nasko
Telerik team
 answered on 15 May 2015
1 answer
852 views
Report designer: I need to set a table's visibility to TRUE when it has no rows.........the problema I have is that the titles of the table did not appear when it has no rows...please help. Thanks!
Stef
Telerik team
 answered on 15 May 2015
13 answers
960 views
Hi, I have a setup a multi-value UI parameter in a report and would like to show the comma seperated value list the user has selected in a textbox in the page header.

just using "=Parameters.myParam" as the textbox expression renders as "System.Collections.ArrayList"

Could you please advise me of the correct expression I should use?

Many thanks
Stef
Telerik team
 answered on 15 May 2015
2 answers
119 views

Hi guys,

 

Just wondering if there is a way to use a different table prefix to the standard tr_xxx when using your implementation of IStorage as the caching mechanism for reports?

 

Cheers.

Guga
Top achievements
Rank 1
 answered on 15 May 2015
3 answers
339 views

Hello together.

There are two possibilities to accomplish ordering, sorting, filtering and grouping of data when using Telerik Reporting.

First approach is very obvious because probably you have to / had to work like this anyway: Use WHERE, ORDER BY, GROUP BY directly in SQL clause but it's some kind of "hidden".
Second approach is the ".NET way" which means that you apply those conditions on a "data adapter class" like you can do it in the report designer for example which is very handy since you don't need to code anything manually but have handy GUIs and can see it instantly in the designer's view.

Now my question: Which one is better / faster and (dis-) advantages over the other?
Are those "programmatically applied" conditions configured through the GUI evaluated by the application code after the original sql query is executed code or are they "translated" to native sql commands and applied before exuting the query?

First one would have noticeable impact on performance I guess whilest the second one is very handy as described above and you can see on the "top level" and don't have to search for anything "back" in the sql commands.

Thanks and regards!

Nasko
Telerik team
 answered on 14 May 2015
2 answers
148 views

Hello,

I have added a pie-chart to my report.  For each "pie-slice", I have added a label that appears just outside the slice. 
I am facing problem  for "connecting-line" from the pie-slice to its label.  The connecting-line overlaps the labels?

I have used following code snippet to place the labels and connecting-line properly in Pie-chart.

 

chart.AutoLayout = true;
chart.IntelligentLabelsEnabled = true;

chartSeries3.Appearance.ShowLabels = true;

chartSeries3.Appearance.ShowLabelConnectors = true;

chartSeries3.Appearance.LabelAppearance.Visible = true;

chartSeries3.Appearance.LabelAppearance.Distance = 10;
chartSeries3.Appearance.StartAngle = 30;
chartSeries3.Appearance.ShowLabelConnectors = true;

 

But Still i am facing the issue of connect line overlapping labels.

 

Nasko
Telerik team
 answered on 14 May 2015
1 answer
102 views
How to generate telerik report using web service? As I have converted web service as list. Now I dont know how to bind in telerik report?
Stef
Telerik team
 answered on 14 May 2015
7 answers
1.9K+ views
Hi there

We have a simple report that works fine when tested in the development environment but when we publish it we get a red error box on every databound field saying....

'The expression contains object <field_name> that is not defined in the current context'

What is strange is we have dozens of other reports in the same library that all work fine.

Can anybody point me at what we are doing wrong as I am struggling to understand why this report fails when it is published.

We are using Q1 20111.

Any help greatly appreciated.


Stef
Telerik team
 answered on 14 May 2015
6 answers
868 views
I have a report that I've created that is consumed by a Windows Form application that displays the report, and then exports the report to PDF and Microsoft Word.  

In one section of the report, I am using the PictureBox control to load the thumbnail image, and this works fine.  I also want the users to be able to drill down or click on the image and have it launch the actual image. 

My directory structure looks like this

C:\Reports                                               ---Main Report Directory
C:\Reports\0001                                      ---Client Directory
C:\Reports\0001\0002                             ---Project Directory
C:\Reports\0001\0002\Report                 ---Actual directory where the PDF / Word document versions of the reports are exported too.
C:\Reports\0001\0002\Report\Thumbs   ---Directory where the thumbnail sized images are stored.
C:\Reports\0001\0002\Report\Images    ---Directory where the full sized images are stored.

So, my code exports the PDF / Word documents to the directory named C:\Reports\0001\0002\Report

If I code my Action up like this, using a physical path, everything works fine:

            Dim strDrillDownURL As String = "file:///C:/Reports/0001/0002/Report/Images/12345.jpg"

            Dim UrlAction1 As New Telerik.Reporting.NavigateToUrlAction()
            UrlAction1.Target = UrlTarget.NewWindow
            UrlAction1.Url = strDrillDownURL

            Me.imgThumbNail.Value = "C:\Reports\0001\0002\Report/Thumbs\12345.jpg"
            Me.imgThumbNail.Action = UrlAction1

When the user opens the PDF or the Word Document and clicks on the thumbnail image associated with the picture, a new window pops open with the full sized image.

However, in my situation, I will need to copy this report directory to a thumb drive and send it to my client.  With this in mind, I want to be able to change the drill down action to use a relative path so that if this thumbnail drive becomes their E: drive, they will still be able to click through to the full sized images.

With this in mind, I've tried many variations of the file:/// relative path implementation, but have yet to find one that works.  My current rendition looks something like this:

            Dim strDrillDownURL As String = "file:///./Images/12345.jpg"

            Dim UrlAction1 As New Telerik.Reporting.NavigateToUrlAction()
            UrlAction1.Target = UrlTarget.NewWindow
            UrlAction1.Url = strDrillDownURL

            Me.imgThumbNail.Value = "C:\Reports\0001\0002\Report/Thumbs\12345.jpg"
            Me.imgThumbNail.Action = UrlAction1

I've spent many hours on Google to try to determine what the proper syntax to use for my drill down URL.  I've come close, in many cases, but I must I am at a loss here.

Does anyone have any suggestions?

Thanks.
Nasko
Telerik team
 answered on 14 May 2015
5 answers
346 views

Hello

Today I started designing my first report in the standalone report designer for the HTML 5 report viewer. Up to now, all reports were type definitions in a class library.

We have some elements that need to be adjusted through bindings in respect of size or position according to the user's settings in the data base. This is done through global functions defined in the same reports class library. So I added the reports library as assembly reference for binding in XML reports for being able to use the same function bindings in the XML report as used in the report type definitions.
So long so good. After having added this reference, binding works. For example assigning a value through such a bound function works as expected. Also the binding of functions for size and position doesn't throw an error. It just does nothing! the picture box stays where it's positioned in the report and keeps the size defined in the report. It drives me crazy!

Function binding looks as follows:
<Binding Path="Size" Expression="=ReportingLib.GlobalFunctions.setPictureSize(ReportingLib.GlobalFunctions.tryPath(Fields.Organisation_ID,&quot;ListHeaderPortrait&quot;))" />
                <Binding Path="Location" Expression="=ReportingLib.GlobalFunctions.setLocation(Fields.Organisation_ListHeaderX, Fields.Organisation_ListHeaderY)" />
                <Binding Path="Value" Expression="=ReportingLib.GlobalFunctions.tryPath(Fields.Organisation_ID,&quot;ListHeaderPortrait&quot;)" />

As mentioned above, the Value binding works as expected but both Size and Location binding does nothing. The functions return Telerik drawing units:
        Return New Telerik.Reporting.Drawing.SizeU(New Telerik.Reporting.Drawing.Unit(width, Telerik.Reporting.Drawing.UnitType.Pixel), New Telerik.Reporting.Drawing.Unit(height, Telerik.Reporting.Drawing.UnitType.Pixel))
        Return New Telerik.Reporting.Drawing.PointU(New Telerik.Reporting.Drawing.Unit(x, Telerik.Reporting.Drawing.UnitType.Cm), New Telerik.Reporting.Drawing.Unit(y, Telerik.Reporting.Drawing.UnitType.Cm))

Thanks for any help!


Nasko
Telerik team
 answered on 14 May 2015
Top users last month
Anislav
Top achievements
Rank 6
Silver
Bronze
Bronze
Jianxian
Top achievements
Rank 1
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Jim
Top achievements
Rank 2
Iron
Iron
Nurik
Top achievements
Rank 2
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?