I am not sure how to accomplish this.  We want to create a static method, that would be used by multiple reports (ie converting a binary to an image).  Currently, I am having a hard time trying to figure this out.  I know we can use custom methods in the report layout, but only if they exist as a static method of that report layout.  

Also, we are designing reports that inherit from a base or abstract report layout (might only have a header and/or footer band with common controls).  Is there a way to create these methods at the parent level of the class so that all inherited reports see that method? 

Now, I have been messing around with inheritance on the reports and trying to create a method at the parent level and see if the inherited reports can see the method, but they don't.  I have also tried creating a Static Class in the namespace, creating a static method in that class, yes, the reports, when rendered can't see them either.

Any help for this will be greatly appreciated.

Thanks

Mark

We have a table that has 3 independent keys which point to a single second table; each of these keys is independent and represents a separate relationship. An example might be a single order which can relate to multiple salespeople.

Something like this:

Table 1

• Table 1 PK
• FK1 => Table 2 PK
• FK2 => Table 2 PK
• FK3 => Table 2 PK
• Column A
• Column B

Table 2

• Table 2 PK
• Column C
• Column D

I would expect to be able to connect the two tables, automatically adding multiple duplicate columns from the second table in my result set (perhaps with a prefix or suffix derived from the foreign key). So we might see something like this:

Joined table (expected)

• Table 1 PK
• Column A
• Column B
• FK1 Table 2 PK
• FK1 Table 2 Column C
• FK1 Table 2 Column D
• FK2 Table 2 PK
• FK2 Table 2 Column C
• FK2 Table 2 Column D
• FK3 Table 2 PK
• FK3 Table 2 Column C
• FK3 Table 2 Column D

When I try to include both tables in the query builder, the second table only appears once in the resulting columns. Additionally, no matter how I set up the relationships, the query builder attempts to group all 3 relationships together (join on FK1 = T2 PK AND FK2 = T2 PK AND FK3 = T2 PK). This is not reflective of the data model. We also only see one set of table 2's columns in the result, something like this:

Joined table (actual)

•  Table 1 PK
• Column A
• Column B
• Table 2 PK
• Table 2 Column C
• Table 2 Column D

Is there any way to do what I'm trying to do using the query builder? Or will I need to write manual SQL for this? Thanks!

Hi all,

I have a Telerik report that is working as expected.  The report list items in several pages.

The report consist of several columns displaying items' fields.

Once I add a barcode control to the items' columns, the report begin to produce a blank page after every single page.

I am sure that the barcode is behind this issue as once I remove the barcode control things are back to normal.

Even If I add a textbox instead of barcode the report print as expected.

I have tried all the available features to get rid of the added blank page but could not.

Please advise and many thanks

ps. I am using Telerik Reporting Q1 2016

ReportViewer has property of the type ReportSource, which does not have connectionstring property, but has parameters

How can I set connection string in runtime for the report that ReportViewer shows?

C# sample will be much appreciated.

Thanks!

     Hi

This is unrelated to my other question. I have fiddled a bit with the latest example and incorparated it in my solution. But now the icons do not appear to show completely. And i have an extra panel to the left i do not want.

Any idea how to fix the icons and hide panel?

hi

i installed telerik report in the solution, create all i need for creating a report. when i execute, the report does not show up in the viewer and i get the following error in google chrome Console tab :

POST http://localhost/my_project//api/reports/clients 500 (Internal Server Error)

Uncaught (in promise) Invalid cliendID

and in the network tab i get this :

<Error>
<Message>An error has occurred.</Message>
<ExceptionMessage>
The 'ObjectContent`1' type failed to serialize the response body for content type 'application/json; charset=utf-8'.
</ExceptionMessage>
<ExceptionType>System.InvalidOperationException</ExceptionType>
<StackTrace/>
<InnerException>
<Message>An error has occurred.</Message>
<ExceptionMessage>Point d'entrée introuvable.</ExceptionMessage>
<ExceptionType>System.EntryPointNotFoundException</ExceptionType>

I dont know what it means. Can anybody helps please

Hello,

I searched the forums but was unable to find the issues that are similar to mine.  Recently  we updated to a newer version of Telerik Reporting(12.2.18.1017).  Either way when loading one of our old reports into the viewer or first loading it within the design which updates it to the new trdx model and saving. Then loading in the HTML 5 viewer. There seems to be a bug with HTML 5 Viewer when using parameters that are AllowNull and MultiValue together. In my case the lists are bound to a data source.  Upon clicking an option in one of my lists.  An API call is triggered for "parameters".  Any list that where AllowNull and MultiValue by default will have a value of null. So if you look at the ajax call to parameters(via developer tools in Chrome) you will see the following in the JSON request object. 

MyList: [null]

It is correctly passing that over as an array.  However, because null is the value selected .  This causes an error on the response such as

InnerException":{"Message":"An error has occurred.","ExceptionMessage":"No corresponding available value for value , parameter MyList","ExceptionType":"System.Exception","StackTrace":"   at Telerik.Reporting.Processing.Parameter.GetSingleLabel(Object value)\r\n   at Telerik.Reporting.Processing.Parameter.get_Label()\r\n   at GetLabel(Object )\r\n   at Newtonsoft.Json.Serialization.DynamicValueProvider.GetValue(Object target)"}}}

However, if before I click on a value in my first list that causes the call to the API.  If I choose a value within the AllowNull/MultiValue list and unselect it again.  This time when I click on the first list that triggers the API call the parameter is omitted from the JSON which basically means nothing is selected and there is no exception.  I tried many solutions without luck.  I tried using jQuery to find the elements after load and trigger click on all first elements twice to select/unselect them but this does not work. Triggering click does nothing.  Is there anyway via the report viewer data object($('#report-viewer').data("telerik_ReportViewer")) to force these lists to clear their values so that [null] is not passed?  This did not happen in our old version(~2016) in the WinForms viewer.  There the list would show as a disabled drop down with a checkbox to the right of it named "Null" that was checked.

In the report designer, I have an HtmlTextBox

In the textbox, I have an ordered list.

I need to change the numbering of the list to start at a value other than 1.
Looking on line, this can be done either by setting the "start" attribute on the OL tag, or the "value" attribute on the LI tag.

    <ol start="10">

    <li value="10">

I've tried both of those, but it doesn't work. It shows my new starting number in the HTML Value designer, but when I click OK and go back to the report designer, it still starts at 1.

     Hi

I have recently upgraded to the new version of telerik 2018 R3. Now the parameterarea is not visible anymore. 

1. I have reports with parameters visible

2. I added .ParametersAreaVisible(true) to the reportviewer just to be sure

3. Locally is works fine

4. When i look at the reportviewer where it doesn't work the button in the toolbar is disabled.

5. When i try to manually toggle the parameterarea it does nothing.

Any idea on how to fix this?

Thanks

Ronald

I am currently experiencing the missing toolbox in Visual Studio 2017 Professional.

I have followed the instructions, pinned to to top of the reporting forum, found here: https://www.telerik.com/forums/missing-telerik-menu-in-vs2017.

I have

(1) Closed all visual studio instances

(2) Downloaded the Duplicate Extension finder

(3) Opened the command prompt as Admin

(4) Ran the Duplicate Extension Finder tool with the -delete option

(5) Started Visual Studio 2017 again, as Admin

(6) Opened the Tools-> Extensions and Updates

(7) Disables all Telerik and Kendo extension entries

(8) Restarted Visual Studio 2017 as Admin

(9) Opened the Tools->Extensions and Updates

(10) Enabled all Telerik and Kendo extension entries

(11) Exited and restarted Visual Studio 2017.

And the problem still exists. The toolbox is not present when I open the report page.

I have since uninstalled the Reporting component using the Tools -> Extensions and Updates, and also used the Progress Control Panel to uninstall the Telerik Reporting component, demos and Visual Studio 2015 and 2017 extensions, and reinstalled them. I have run theDuplicate Extension Finder to remove and duplicate extensions (there weren't any this time around.)

But still...nothing. It still isn't showing.

I can see the ReportingToolbox.12.2.18.1129.pkgdef file under C:\Program Files (x86)\Microsoft Visual Studio\2017\Professional\Common7\IDE\Extensions\Telerik

I have attached an image from that file. The file references the D drive as that is where I have Telerik Reporting installed (corporate environment, no space on C). The file Telerik.Reporting.dll does exist in that location.

Is there something I can do to manually force the install of the Telerik Reporting toolbox?