i have created my class library and got my first report to work. i am using a sqldataadapter and parameters with a stored procedure. when i go to create a second report, i drag the sqladapter onto the report and use the connection that already existed for the first report. i have tried this numerous times, and every time i go to preview the report i get: login failed for user xxxxxx.

i believe i have done everything the exact same way. once i create and configure the dataadapter, i set the datasource. i can see my fields in the data explorer. the only difference i see is that in the first report, there is a sqlselectcommand1 at the bottom with the dataadapter and the connection objects on the reports that work but on the one that does not, that sqlselectcommand object is not present. i don't know if this is the problem, but i cannot get that object on the report.

thanks and let me know if you need any more information.

thanks,
susan

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).

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!

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

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.