Telerik Forums
Kendo UI for jQuery Forum
0 answers
111 views

How to make Gridview control to group in each column of data?

Hi, I have a web project which uses webform with Gridview to display the SQL server table data,

Data in Gridview Control is as this grid format:

Data 1 | Data 2 | Data 3 Amount1 Amount2 Amount3

Data 1 | Data 2 | Data3 Amount1 Amount2 Amount3

Data 1 | Data 2 | Data 3 Amount1 Amount2 Amount3

Data 1 | Data 2 | Data 3 Amount1 Amount2 Amount3

Ground Total: Gtotal1 Gtotal2 Gtotal3

I expact the data to be shown in the report in this way:

+Data1 Subtotal1 Subtotal2 Subtotal3

Ground total Gtotal1 Gtotal2 Gtotal2

Click +Data1 to expand it, it should be:

-Data1 Subtotal1 Subtotal2 Subtotal3

+Data2 SecondSubtotal1 SecondSubtotal2 SecondSubtotal3

Gtotal1 Gtotal2 Gtotal3

Click +Data2 to expand it, it should be:

-Data1 Subtotal1 Subtotal2 Subtotal3

-Data2 SecondSubtotal1 SecondSubtotal2 SecondSubtotal3

+Data3 ThirdSubtotal1 ThirdSubtotal2 ThirdSubtotal3

Gtotal1 Gtotal2 Gtotal3

Click +Data3 to expand it, it should be:

-Data1 Subtotal1 Subtotal2 Subtotal3

-Data2 SecondSubtotal1 SecondSubtotal2 SecondSubtotal3

-Data3 ThirdSubtotal1 ThirdSubtotal2 ThirdSubtotal3

DetailsAmt1 DetailsAmt2 DetailsAmt3

Ground Total Gtotal1 Gtotal2 Gtotal3

Of cause, the + and - sign in the report will be able to expand and collapse.

After did some search from the internet, somebody mention Jqgrid, or telirik tool, etc. but most of them are only works on first level of group, not more than one group, I appricate anybody can provide any solution to achieve this goal. Some examples will be helpful

Peter
Top achievements
Rank 1
 asked on 21 Nov 2012
0 answers
95 views
is it possible to turn the input fields in the standard filter box to autocompletion fields? I know how to make them dropdowns but i have one column that has about 200 options (to many for a dropdown), can i make tha tinput field an auto-complete? I know how to do it outside the grid but i want this to be done IN the filter dropdown.
Gregory
Top achievements
Rank 1
 asked on 21 Nov 2012
3 answers
307 views
I have created a data source and I need to parse the data that comes in so it is in the appropriate structure for my grid. I normally do this with parse and all is well.

In this scenario, I need to programatically set the data. When I do this by using the DataSource.data member, then parse is never called.

I have an example in this fiddle: http://jsfiddle.net/grippstick/tjmKm/

If you click switch data you will see the grid populate with the new data, but the parse function is never called.
Brian
Top achievements
Rank 1
 answered on 21 Nov 2012
1 answer
314 views
I'm using asp.net mvc4 with kendo ui. I have a simple grid that gets loaded with no values on load (Index()) and then once a search button is clicked data populates the grid(Index(int value)). Here's what I've found so far. I think the problem is how I have my .js files arranged but I'm not positive. I already built one app and it works correctly and I had a problem with how to arrange the .js files. The other issue seems to be with Areas in the MVC application. I have to add a _ViewStart under all my ares under the Views folder or there is no formatting. In my _viewstart file I have @{   Layout = "~/Views/Shared/_Layout.cshtml";}. If I comment that out the page loads correctly but there is no data. If I include it to layout my page it calls the correct method and returns data but it also calls the Index() method and load a blank Model and clears out my results. 

Here's my _Layout:
 @Styles.Render("~/Content/css")
    @Styles.Render("~/Content/kendo")
    @Scripts.Render("~/bundles/jquery")
    @Scripts.Render("~/bundles/kendo")
    @Scripts.Render("/bundles/jqueryval")

Bundles
 bundles.Add(new ScriptBundle("~/bundles/jquery").Include(
                        "~/Scripts/jquery-1.8.2.js"));
bundles.Add(new ScriptBundle("~/bundles/kendo").Include(
                 "~/Scripts/kendo/2012.3.1114/kendo.all.*"
bundles.Add(new ScriptBundle("~/bundles/jqueryval").Include(
                        "~/Scripts/modernizr-2.5.3.js",
                        "~/Scripts/jquery.validate.min.js",
                         "~/Scripts/jquery.unobtrusive*"));


Thanks
Dennis
Dennis
Top achievements
Rank 1
 answered on 21 Nov 2012
5 answers
188 views
Hi,

Is there a way to provide a custom popup editor for each  CRUD operation or wire in your own editor? A simple sample would be highly appreciated.

Thanks,
Max
Maxim
Top achievements
Rank 1
 answered on 21 Nov 2012
2 answers
52 views

This is the code I used.  It works fine in IE9, but IE8 can't handle it:

   

var data = [{
            "category": "Test",
            "value": 150,
            "percentage": "85%"
        },
        {
            "category": "Test0",
            "value": 5,
            "percentage": "5%"
        },
        {
            "category": "Test1",
            "value": 1,
            "percentage": "0.1%"
        },
        {
            "category": "Test2",
            "value": 1,
            "percentage": "0.1%"
        },
        {
            "category": "Test3",
            "value": 1,
            "percentage": "0.1%"
        },
         {
             "category": "Test4",
             "value": 1,
             "percentage": "0.1%"
         },
          {
              "category": "Test5",
              "value": 1,
              "percentage": "0.1%"
          },
           {
               "category": "Test6",
               "value": 1,
               "percentage": "0.1%"
           },
            {
                "category": "Test7",
                "value": 1,
                "percentage": "0.1%"
            },
         ];
 
        $("#divChartByPublisher").kendoChart({
            theme: "default",
            title: {
                text: "Opportunities by Publisher"
            },
            legend: {
                position: "left",
                labels: {
                    template: "#= dataItem.label # (#= value #) - #= dataItem.percentage #%"
                }
            },
 
            dataSource: {
                data: data
            },
            series: [{
                type: "pie",
                field: "value",
                categoryField: "category"
            }],
 
            seriesColors: chartColors,
 
            tooltip: {
                visible: true,
                template: "#= category # (#= value #)"
            }
        });

Daniel
Top achievements
Rank 1
 answered on 21 Nov 2012
0 answers
252 views
Hi all,

I want to update the labels shown in the category axis in line chart when new data is bound and refresh method is called.
All the values are getting shown in the chart except the labels present in the category axis. FYI the category axis is showing time. So after each minute the category axis should update the time label shown in the chart.

Any help will be very much helpful to me.

Posting my Code for your reference
 @(Html.Kendo().Chart(Model)
        .Name("RPMchart")
        
        .Legend(legend => legend
            .Position(ChartLegendPosition.Bottom)
        )
                //.DataSource(ds => ds.Read(read => read.Action("MonitoringJson", "Application")))
        .Series(series => {
            series.Line(model => model.RequestsPerMinute)
                .Name("Request Per Minute")
                .Labels(labels => labels.Format("{0}").Visible(false));
        })
        .CategoryAxis(axis => axis
            .Categories(model => model.Minute.TimeOfDay)
                            .Labels(labels => labels.Format("{0}").Rotation(-90))
            
        )
        .HtmlAttributes(new { style = "height:400px;width:400px" })
        .ValueAxis(axis => axis.Numeric()
                    .Labels(labels => labels.Format("{0:N0}"))
                    
                ).Tooltip(tooltip => tooltip
                    .Visible(true)
                    .Format("{0:N0}")
                )
    ) 



Thanks
Alam
Mohammed
Top achievements
Rank 1
 asked on 21 Nov 2012
1 answer
279 views
It is unclear to me how to implement panning and zooming in charts. I had hoped that they worked like the stock charts, but there;s no reference to a navigator in the documentation. When I search the documentation for panning I find nothing, and when I search for zoom it refers to zooming with the mouse wheel, but I can't get any zooming to happen when I mode the mouse wheel over a chart, either pressed or unpressed. I am very anxious to find out how to do it because I have implemented my own panning and zooming and would very much prefer to have Kendo do it for me.

Thanks/ANker
T. Tsonev
Telerik team
 answered on 21 Nov 2012
3 answers
470 views
Hi

I have seen lots of examples of how to configure custom validation in grid model to support CRUD.

If you use a popup for editing, but don't specify a template, it works as expected.  The custom rules fire and the popup will not close until errors are fixed.

I cannot find any examples of how to apply custom rules to my model when using a template with a popup.  I need the template to support my CRUD requirements, the default editor doesn't cut it.  I also need some custom validation rules.

It seems as though the custom rules on my schema model are never executed when I specify my template for the popup editing..

I have tried guessing the syntax of using declarative binding for the custom validation, without success.

I have tried hooking into the edit event on the grid and attaching a validator to the popup container.  My custom rules are executed, but not as expected.  They only fire when the values of my controls change, but if you hit the update button again, the popup window closes accepting the invalid data.

I have modified one of the existing CRUD template samples here.  http://jsfiddle.net/yamaan608/Svweg/1/ .

In the example, you can see the template is commented out and the validation works fine.  A custom rule is applied to the age.  If you uncomment the template, you will see no validation takes place.

Any pointers greatly appreciated.

Bryan
Top achievements
Rank 1
 answered on 21 Nov 2012
1 answer
156 views
Hi guys,
i'm trying to show a negative currency value for a numeric text box. Currently when I populate the control with a negative value it shows it within brackets without the negative simbol.
How can I achieve that?
Georgi Krustev
Telerik team
 answered on 21 Nov 2012
Narrow your results
Selected tags
Tags
Grid
General Discussions
Charts
Data Source
Scheduler
DropDownList
TreeView
MVVM
Editor
Window
Date/Time Pickers
Spreadsheet
Upload
ListView (Mobile)
ComboBox
TabStrip
MultiSelect
AutoComplete
ListView
Menu
Templates
Gantt
Validation
TreeList
Diagram
NumericTextBox
Splitter
PanelBar
Application
Map
Drag and Drop
ToolTip
Calendar
PivotGrid
ScrollView (Mobile)
Toolbar
TabStrip (Mobile)
Slider
Button (Mobile)
SPA
Filter
Drawing API
Drawer (Mobile)
Globalization
Gauges
Sortable
ModalView
Hierarchical Data Source
Button
FileManager
MaskedTextBox
View
Form
NavBar
Notification
Switch (Mobile)
SplitView
ListBox
DropDownTree
PDFViewer
Sparkline
ActionSheet
TileLayout
PopOver (Mobile)
TreeMap
ButtonGroup
ColorPicker
Pager
Styling
MultiColumnComboBox
Chat
DateRangePicker
Dialog
Checkbox
Timeline
Drawer
DateInput
ProgressBar
MediaPlayer
ImageEditor
OrgChart
TextBox
Effects
Accessibility
ScrollView
PivotGridV2
BulletChart
Licensing
QRCode
ResponsivePanel
Switch
Wizard
CheckBoxGroup
TextArea
Barcode
Collapsible
Localization
MultiViewCalendar
Touch
Breadcrumb
RadioButton
Stepper
Card
ExpansionPanel
Rating
RadioGroup
Badge
Captcha
Heatmap
AppBar
Loader
Security
Popover
DockManager
FloatingActionButton
TaskBoard
CircularGauge
ColorGradient
ColorPalette
DropDownButton
TimeDurationPicker
ToggleButton
BottomNavigation
Ripple
SkeletonContainer
Avatar
Circular ProgressBar
FlatColorPicker
SplitButton
Signature
Chip
ChipList
VS Code Extension
AIPrompt
PropertyGrid
Sankey
Chart Wizard
OTP Input
SpeechToTextButton
InlineAIPrompt
+? more
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?