Hi there;

I’m tryring to create a radGrid with data from database

What I want to do that I already convert some rows to columns in the database query:

SELECT  Z.id , WR. NAME,

 NVL(MAX(DECODE (Z.ZONE , 'A', Z.n )),0) A,

 NVL(MAX(DECODE ( Z.ZONE , 'B', Z.n )),0)B,

 NVL(MAX(DECODE ( Z.ZONE , 'M', Z.n )),0) M

 FROM  ………………

And I need to publish this data in a radgrid

What is the problem?

That this columns actually change over time, so I can’t keep them static

My idea is to loop through this values(A,B,M,….) in c# code-behind  and  convert them to columns in a command string ? Is it possible to do so?

From your documentation and also some posts here I noticed that "binding to IQueryable" can be use enhance performance.

Here for an example http://www.telerik.com/forums/enablecaching-=-true-causing-pivotgrid-to-remain-empty#lN8o0P-F3UKixSLep-_wbw you link

to this documentation entry

http://docs.telerik.com/devtools/aspnet-ajax/controls/pivotgrid/data-binding/advanced-via-needdatasource

What I see there is that it all ends up with a "select everything from a table" - "SELECT * FROM Transportation"

What I EXPECT is a select statement which "fits my needs".

I know sometimes there is a need to select all data.
But (for an example) if I filter for Transportation Items which happend in the year 2010 and have a value bigger than 10.000 I would expect a query like
"SELECT * FROM Transportation WHERE TPYear = 2010 AND TPValue>10.000"

Did I miss something?

By the way - I also tried to use an "EntityDatasource" (using EF6) - which does the same - SELECT * FROM....
No filtering on the query occures.

On last thing - in the first linked post the question contains: .... We are running on a decently large initial result set (about 3000 records) ....

This is not (in our case) what I'd call "large" - consider the query product of (only) 1000 sales per day with articels, regions,.. for (only) 3 years.
Which also makes the star in the select questionable - why select * if I only want to know ID and quantity (for an example).

Am I thinking totaly wrong - or is there something I've overseen?

Manfred

When the RadGrid control does not have its Pager, Footer, etc. elements enabled, you can come across this issue using the following method:

resizeToFit

 
This issue should be fixed with the Latest Internal Build 2016.3.927. 

We are aware of a filtering problem using the 2016.3.914 version of Telerik controls related to the AutoPostBackOnFilter property.

I am working in a asp.net webforms project extending functionalities in an application that makes use of Telerik AJAX controls. The issue is that when I run the code in my laptop (win10Pro) the forms with RadComboBoxes fail. The control is rendered but there is an error in the load (in chrome is reported with the message: "Failed to load resource: the server responded with a status of 500 (Internal Server Error)" and later complains about "Telerik is not defined". If I run the same code in a windows server it works perfectly. I have several forms with telerik controls (grid) that works perfectly in my laptop, so I guess the problem is not related to web.config issues.

The resource request that fail is:

http://localhost/Synergy/Telerik.Web.UI.WebResource.axd?_TSM_HiddenField_=RadScriptManager1_TSM&compress=1&_TSM_CombinedScripts_=%3b%3bSystem.Web.Extensions%2c+Version%3d4.0.0.0%2c+Culture%3dneutral%2c+PublicKeyToken%3d31bf3856ad364e35%3aes-ES%3af9ecfe64-7d94-4875-a470-9996e4d00a9f%3aea597d4b%3ab25378d2%3bTelerik.Web.UI%2c+Version%3d2015.1.401.45%2c+Culture%3dneutral%2c+PublicKeyToken%3d121fae78165ba3d4%3aes-ES%3a4f93cdea-660e-49e9-b57d-168c603f1b46%3a16e4e7cd%3af7645509%3a24ee1bba%3af46195d3%3a2003d0b8%3ac128760b%3a88144a7a%3a1e771326%3aaa288e2d%3a258f1c72%3a6d43f6d9%3aed16cbdc%3a4c8be21a%3a874f8ea2%3a650fdad%3aa960fda2%3aca44ff11%3a29e4ab07%3ab68dcd79%3ae330518b%3ac8618e41%3ae4f8f289%3a1a73651d%3a333f8d94%3a19620875%3acda80b3%3a383e4ce8

In the event viewer there is a recorded event:

Error HTTP 500.21 - Internal Server Error

Handler "TelerikResource" has a bad module "ManagedPipelineHandler" in its module list.

The error code is 0x8007000d

Any help with this issue?

Hi, I'm trying to use the RadPivotGrid control.

I'm using this version of Telerik DLL : 2012.2.607.40

Others controls work fine, for example RadGrid or RadScheduler.

My page has this code:

<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <telerik:RadPivotGrid runat="server"></telerik:RadPivotGrid>
    <telerik:RadGrid ID="RadGrid1" runat="server"></telerik:RadGrid>
</asp:Content>

The RadGrid control is recognized but the RadPivoGrid doesn't.

I have to add some code for use the RadPivoGrid control? I need to add some lines in the web.config?

I already have a calendar setup with Resource Grouping and now would like to setup permissions so that some users can only admin certain resources but see all. I would handle the determination of right so that each resource would have a flag set as something like adminAllowed and when that is true the resource can be booked.  Is this possible, I'm fairly sure that it is possible via the client API but want to check before I waste any time on it.

Regards

Jon

Hi All
For those who use your Telerik Controls with a the rest of you framework in Bootstrap, like me, you would know that there is a lot finer css tweaks to be performed so that everything is pixel perfect the same (like mixing and matching telerik controls, with asp.net controls, with plain html controls). I usually end up with an overide.css (hack-fix-telerik's-bootstrap-to-match-bootstrap), taking me the bulk of my GUI design time.

Recently, I decided to use the password strength checker which is part of the RadTextBox control, but I did not like how the indicator is just a piece of text next to the inputbox. It anyhow is has bugs, e.g. there is a padding-right of 100px (to allow for the indicator, but if you set the indicator to be i.e. 75px wide, this padding stays 100px, causing the whole control to be 25px narrower than it should be. This is just to mention 1 issue.

In bootstrap we have input-groups:

This created a lovely area next to the input box as if its part of the input box (rounded corner removed where the 2 controls side touches, etc). 

If you want perfect looking BS GUI, then this is how the password strength indicator should be display.
So here is some CSS for you to start with (I'm not saying its perfect, but at least it will save you 2 hour of reverse engineering and testing css to get it to look like a bootstap input group add-on.

You matching html will be something like this:

If you followed Bootstrap patterns, then this form-group should be inside a

For the re-type-your-password, use the client side code as per Telerik examples (demo page) and use an actual Bootstrap input group. Like this:

NOW, both look exactly the same, and like bootstrap input group add-ons.

PS: from my code pasted above, there are some tweaks still to do, or which you can ignore.

1. I have a style in there called mandatory. You can ignore this. I style mandatory input boxes with a 3px red left border and then adjust the input box's left padding with -3px, so that it all still left align.
2. The hard-coded style of 75px, should go to my css classes.
3. I made the text inside the password strength indicator 12px, so that it is smaller than the rest of the input fonts and that the indicator does not eat up so much horizontal width on my form.
4. Important: .riPassIndicator > display: table; and .riStrengthBar > display: table-cell; is the main css tricks that help you create less css. Without that, you will have to set paddings, margins, and other conditions till you crazy :-)

Enjoy