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.

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!

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.

 

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?

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.

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.

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!

Hello, I'd like to know what property should I used to set the color for every series in a Pie report. Thanks

Hi

i have an kendo ui grid and i need to pass selected rows in my grid to report to let me print them from report 

i try to find any thing like that in demo but i faild

so please hope to give me sample code or sample example to let know how can i do that

 thanks a lot ....

 

 

 

I am using MVC Demo for Telerik Reporting. I have few questions which I really want to know before start working with Telerik Reporting.

 1.) I am binding Report Data source dynamically from code behind(on Report's Code page). Initially Report is Loading fine. What I want, when user enter value into report parameter and click on preview button.... Is that possible to handle those parameters and update object data source and update reporting from code side? Actually I don't want get whole data at time.Right now I don't find any event that give me report parameters value on Preview Button click.

 

 2.) Initially if I don't come on Report Page with whole data, Is that possible to update data-source programaticaly later. Like on Preview Button click, or any other button click out side Report  Viewer. Because I want to add one functionality  where I would have one button on Page and on click of that button I would read report Parameters and save into DB. But right now I am not able to read Report Parameters server side once Report Loaded.

 

3.) I have added One Report parameter and trying to just display it on Designer nothing else but It is just render with initial value.Later if I change parameter to any value it doesn't reflect. Is there any problem in setting report viewer. I have checked Telerik Example and Report Parameter value get update there. So that I am sure I m missing some thing but not able to found it.