or
5 answers
594 views
Hi Team,
I have a hierarchical grid in which I wan to show sum of values in columns for Groups as well as for total column also.
It was working fine before, but don't know what happened, it is not showing the Footer Text now..
This is my Grid :
Any help appreciated.
Thanks,
Lok..
I have a hierarchical grid in which I wan to show sum of values in columns for Groups as well as for total column also.
It was working fine before, but don't know what happened, it is not showing the Footer Text now..
This is my Grid :
<telerik:RadGrid ID="rgProjectBudget" OnNeedDataSource="rgProjectBudget_NeedDataSource" runat="server" GridLines="None" ShowGroupPanel="false" AllowMultiRowSelection="true" OnDeleteCommand="rgProjectBudget_DeleteCommand" AutoGenerateColumns="False" AllowSorting="True" AllowPaging="false" ShowFooter="true"> <MasterTableView Width="100%" GroupsDefaultExpanded="false" ExpandCollapseColumn-Groupable="true" CommandItemSettings-ShowAddNewRecordButton="false" GroupLoadMode="Client" ShowGroupFooter="true"> <GroupByExpressions> <telerik:GridGroupByExpression> <SelectFields> <telerik:GridGroupByField FieldAlias="ChartOfAccountSetDetailDescription" FieldName="ChartOfAccountSetDetailDescription" HeaderText="GL Account" HeaderValueSeparator=" : "></telerik:GridGroupByField> </SelectFields> <GroupByFields> <telerik:GridGroupByField FieldName="ChartOfAccountSetDetailDescription" SortOrder="Descending"></telerik:GridGroupByField> </GroupByFields> </telerik:GridGroupByExpression> </GroupByExpressions> <Columns> <telerik:GridBoundColumn DataField="ChartOfAccountSetDetailValueCode" DataType="System.String" HeaderText="Project Heads" AllowFiltering="true" AutoPostBackOnFilter="true" FilterControlWidth="30%" CurrentFilterFunction="Contains" UniqueName="ChartOfAccountSetDetailValueCode"> <HeaderStyle HorizontalAlign="Left" /><ItemStyle HorizontalAlign="Left" Width="10%" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="ChartOfAccountSetDetailDescription" DataType="System.String" HeaderText="Description" AllowFiltering="true" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" UniqueName="ChartOfAccountSetDetailDescription" FilterControlWidth="60%"> <HeaderStyle HorizontalAlign="Left" /><ItemStyle HorizontalAlign="Left" Width="10%" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="PurchaseOrderNo" DataType="System.String" HeaderText="PO No" AllowFiltering="true" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" UniqueName="PurchaseOrderNo" FilterControlWidth="60%"> <HeaderStyle HorizontalAlign="Left" /><ItemStyle HorizontalAlign="Left" Width="10%" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="GR_Number" DataType="System.String" HeaderText="GR No" AllowFiltering="true" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" UniqueName="GR_Number" FilterControlWidth="60%"> <HeaderStyle HorizontalAlign="Left" /><ItemStyle HorizontalAlign="Left" Width="10%" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn UniqueName="QuotedValue" HeaderText="Quoted Amount" DataField="QuotedValue" CurrentFilterFunction="EqualTo" AllowFiltering="true" DataType="System.Double" DataFormatString="{0:N}" FilterControlWidth="30%" AutoPostBackOnFilter="true" Aggregate="Sum" FooterText="Quoted Value: "> <HeaderStyle HorizontalAlign="Left" /><ItemStyle HorizontalAlign="Right" Width="10%" /><FooterStyle HorizontalAlign="Right" /> <FooterStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn UniqueName="SecondaryEntityBudget" HeaderText="PV1" DataField="SecondaryEntityBudget" DataFormatString="{0:N}" CurrentFilterFunction="EqualTo" AllowFiltering="true" DataType="System.Double" Aggregate="Sum" FooterText="PV1: " FilterControlWidth="30%" AutoPostBackOnFilter="true"> <HeaderStyle HorizontalAlign="Left" /><ItemStyle HorizontalAlign="Right" Width="10%" /><FooterStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn UniqueName="SupplementaryBudget1" HeaderText="PV0" DataField="SupplementaryBudget1" DataFormatString="{0:N}" CurrentFilterFunction="EqualTo" AllowFiltering="true" DataType="System.Double" Aggregate="Sum" FooterText="PV0: " FilterControlWidth="30%" AutoPostBackOnFilter="true"> <HeaderStyle HorizontalAlign="Left" /><ItemStyle HorizontalAlign="Right" Width="10%" /><FooterStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn UniqueName="COARequisitionAmount" HeaderText="Commited" DataField="COARequisitionAmount" FooterText="Commited: " CurrentFilterFunction="Contains" AllowFiltering="true" DataFormatString="{0:N}" AutoPostBackOnFilter="true" Aggregate="Sum"> <HeaderStyle HorizontalAlign="Left" /><ItemStyle HorizontalAlign="Right" Width="10%" /><FooterStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn UniqueName="COAActualAmount" HeaderText="Actual Amount" Aggregate="Sum" FooterText="Actual Amount: " DataField="COAActualAmount" CurrentFilterFunction="EqualTo" AllowFiltering="true" DataFormatString="{0:N}" DataType="System.Double" FilterControlWidth="30%" AutoPostBackOnFilter="true"> <HeaderStyle HorizontalAlign="Left" /><ItemStyle HorizontalAlign="Right" Width="10%" /><FooterStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> <telerik:GridCalculatedColumn HeaderText="Balance" UniqueName="Balance" DataType="System.Double" DataFormatString="{0:N}" DataFields="SecondaryEntityBudget,COARequisitionAmount,COAActualAmount" Expression="{0}-({1}+{2})" FooterText="Balance: " Aggregate="Sum"> <HeaderStyle HorizontalAlign="Left" /><ItemStyle HorizontalAlign="Right" Width="10%" /><FooterStyle HorizontalAlign="Right" /> </telerik:GridCalculatedColumn> <telerik:GridBoundColumn DataField="StatusID" DataType="System.Int32" HeaderText="StatusID" UniqueName="StatusID" Display="false"></telerik:GridBoundColumn> <telerik:GridHyperLinkColumn DataTextField="StatusName" DataType="System.String" ItemStyle-HorizontalAlign="Center" HeaderText="Status" UniqueName="StatusName" CurrentFilterFunction="Contains" AutoPostBackOnFilter="true" DataNavigateUrlFields="COABudgetDetailID,SecondaryEntityBudget,SupplementaryBudget1,SupplementaryBudget2" DataNavigateUrlFormatString="javascript:CheckBudgetAmount({0},{1},{2},{3});" Visible="false"></telerik:GridHyperLinkColumn> <telerik:GridBoundColumn DataField="SecondaryEntityBudgetApproved" DataType="System.Double" Display="false" HeaderText="SecondaryEntityBudgetApproved" UniqueName="SecondaryEntityBudgetApproved"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="SupplementaryBudget1Approved" DataType="System.Double" Display="false" HeaderText="SupplementaryBudget1Approved" UniqueName="SupplementaryBudget1Approved"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="SupplementaryBudget2Approved" DataType="System.Double" Display="false" HeaderText="SupplementaryBudget2Approved" UniqueName="SupplementaryBudget2Approved"> </telerik:GridBoundColumn> <telerik:GridTemplateColumn HeaderText="Not Applicable" UniqueName="IsBudgetNotApplicable" FilterControlWidth="20%" CurrentFilterFunction="Contains" AllowFiltering="true" AutoPostBackOnFilter="true" Display="false"> <ItemTemplate> <asp:CheckBox ID="chkApplicable" runat="server" Checked='<%# DataBinder.Eval(Container,"DataItem.IsBudgetNotApplicable") %>' Visible="false" /> </ItemTemplate> <HeaderStyle HorizontalAlign="Left" /><ItemStyle HorizontalAlign="Left" Width="10%" /> </telerik:GridTemplateColumn> <telerik:GridCheckBoxColumn DataField="IsParent" UniqueName="IsParent" HeaderText="IsParent" Display="false"></telerik:GridCheckBoxColumn> <telerik:GridBoundColumn DataField="IsParent" UniqueName="IsParent1" HeaderText="IsParent1" Display="false"></telerik:GridBoundColumn> <telerik:GridClientSelectColumn HeaderText="Select" UniqueName="Select" Display="false"></telerik:GridClientSelectColumn> <telerik:GridButtonColumn CommandName="Delete" HeaderText="Delete?" Text="Delete" Display="false" UniqueName="DeleteCommandColumn" ButtonType="ImageButton" ConfirmText="Are you sure you want to delete ?"> </telerik:GridButtonColumn> </Columns> </MasterTableView> <ClientSettings ReorderColumnsOnClient="True" AllowDragToGroup="false" AllowColumnsReorder="True"> <Selecting AllowRowSelect="True"></Selecting> <Resizing AllowRowResize="True" AllowColumnResize="True" EnableRealTimeResize="True" ResizeGridOnColumnResize="False"></Resizing> </ClientSettings> <GroupingSettings ShowUnGroupButton="true" RetainGroupFootersVisibility="true" /> </telerik:RadGrid>Any help appreciated.
Thanks,
Lok..
3 answers
181 views
Hi All
I have a drop down with check box. user can select the more then one value select in check box and this value can save in the session variable after that redirect to the next page when user come back again in this page all selected check box value those are saved in the session can set the all the check box value checked in that drop down.
for example user can select 2 value then session["selectedvalue"]="1,2";
then how to set this selected value set in the check box of that combo box.
thanks
Sushobhit Raman
I have a drop down with check box. user can select the more then one value select in check box and this value can save in the session variable after that redirect to the next page when user come back again in this page all selected check box value those are saved in the session can set the all the check box value checked in that drop down.
for example user can select 2 value then session["selectedvalue"]="1,2";
then how to set this selected value set in the check box of that combo box.
thanks
Sushobhit Raman
Sushobhit
Top achievements
Rank 2
Rank 2
answered
on
24 Jul 2012
2 answers
102 views
I have an ASP.Net page that has about 8 tabs that are created from a RadTabStrip control.
On the 1st tab I have a RadToolBar with one button that when clicked opens a modal popup.
On the 5th tab I have an ASP Button that opens a modal popup that contains an ASP FileUpload control.
After I select my file to upload and I click the OK button on that modal popup, it uploads the file and then closes the modal popup.
The problem I'm having is after the modal popup closes and I click on the 1st tab again, the default skin of the RadToolBar buttons are completely gone and it only shows the button text and icon image.
Any ideas why this is happening?
Two images are attached of what it should and shouldn't look like.
On the 1st tab I have a RadToolBar with one button that when clicked opens a modal popup.
On the 5th tab I have an ASP Button that opens a modal popup that contains an ASP FileUpload control.
After I select my file to upload and I click the OK button on that modal popup, it uploads the file and then closes the modal popup.
The problem I'm having is after the modal popup closes and I click on the 1st tab again, the default skin of the RadToolBar buttons are completely gone and it only shows the button text and icon image.
Any ideas why this is happening?
Two images are attached of what it should and shouldn't look like.
1 answer
124 views
I am using telerik.web.ui v2011.3.1305.35. When you set the checked property for a radCombobox to "true", each item you check creates a concatenated, comma separated list in the display box. This uses the item text of the combo box. How can you do the same thing except display the item "value" in a comma separated list? BTW, this is way cool and made life a lot easier coding wise.
Nencho
Telerik team
answered
on
24 Jul 2012
3 answers
242 views
So I have noticed some minor rendering issues with the RadGrid's we have been using in our current project, and was hoping I could get some help.
1. Currently when dragging columns to do grouping if the text inside a header has not wrapped but others have there is large white space around the "dragging" window. Please see the two attachments smalldrag and fulldrag. Even with the one that has had text wrapped inside of it some white space appears. Is there a way to eliminate this white space whenever dragging any column header?
2. Currently when the grid first initializes it will have horizontal scrolling and content will NOT be clipped/hidden in any of the table cells. This is how we want the grids to behave. However when we do the grouping operation columns become fixed, content in the cells gets heavily cropped, and the horizontal scrollbar goes away (very bad). Please see the two attachments pregroup and postgroup.
Thank you in advance for any assistance.
1. Currently when dragging columns to do grouping if the text inside a header has not wrapped but others have there is large white space around the "dragging" window. Please see the two attachments smalldrag and fulldrag. Even with the one that has had text wrapped inside of it some white space appears. Is there a way to eliminate this white space whenever dragging any column header?
2. Currently when the grid first initializes it will have horizontal scrolling and content will NOT be clipped/hidden in any of the table cells. This is how we want the grids to behave. However when we do the grouping operation columns become fixed, content in the cells gets heavily cropped, and the horizontal scrollbar goes away (very bad). Please see the two attachments pregroup and postgroup.
Thank you in advance for any assistance.
Galin
Telerik team
answered
on
24 Jul 2012
10 answers
743 views
Hello ,
I have an issue when I change a cell value from java script.
My case is:
I have a Radgrid and a user can select a row.
When the user selects the row, I get the row key and allow him to add a new action, by opening a new Radwindow.
When the window closes, I return the id of the action added.
On closeEvent, I call a javascript function where the value returned goes to a cell at the initial grid (this cell has no value from DB).
The code I use to change the value is the following:
Everything works until now. I can see the new value at the grid.
When the returned value is not null, I perform an Ajax request, and the I check the value at the cell if changed.
My problem is, that when I loop through the items of the grid, I get a " " value.
The code I use to loop through the items is the following
Is there something I am missing here?
I would really appreciate your help!
Thank you in advance,
Peny
I have an issue when I change a cell value from java script.
My case is:
I have a Radgrid and a user can select a row.
When the user selects the row, I get the row key and allow him to add a new action, by opening a new Radwindow.
When the window closes, I return the id of the action added.
On closeEvent, I call a javascript function where the value returned goes to a cell at the initial grid (this cell has no value from DB).
The code I use to change the value is the following:
function refreshDataActions(oWnd, args) {
var arg = args.get_argument();
if (arg) {
if (arg.actionId) {
var HiddenField_contract_value = document.getElementById("HiddenField_contract").value;
var grid = $find("<%=contractsGrid.ClientID %>");
var MasterTable = grid.get_masterTableView();
var rows = MasterTable.get_dataItems();
for (var i = 0; i < rows.length; i++) {
var row = rows[i];
var activeCell = MasterTable.getCellByColumnUniqueName(row, "actionRESULT");
var contractRow = row.getDataKeyValue("CONTR_ID");
if (contractRow == HiddenField_contract_value) {
activeCell.innerHTML = arg.actionId;
}
}
$find("<%= RadAjaxManager1.ClientID %>").ajaxRequest("actionAdded");
}
}
}Everything works until now. I can see the new value at the grid.
When the returned value is not null, I perform an Ajax request, and the I check the value at the cell if changed.
My problem is, that when I loop through the items of the grid, I get a " " value.
The code I use to loop through the items is the following
For Each item In contractsGrid.Items
If item("actionRESULT").text <> " " Then
counterActions = counterActions + 1
End If
NextIs there something I am missing here?
I would really appreciate your help!
Thank you in advance,
Peny
3 answers
87 views
Hi,
I'm using RadSchedular advance form to insert/update appointments. It works fine when I assign resources at the time of databinding.
Now what I'm trying to achieve it to dynamically add new resources by giving a add button besides the dropdowns in the appointment form.
For exmaple:
Initially there are 3 users, user1, user2,user3. Now I want to give user ability to choose from exisitng users or add a new user (user4) there only.
Is that possible? If yes how can this be achieved please share if any samples are avaiable.
Thanks,
Piyush
I'm using RadSchedular advance form to insert/update appointments. It works fine when I assign resources at the time of databinding.
Now what I'm trying to achieve it to dynamically add new resources by giving a add button besides the dropdowns in the appointment form.
For exmaple:
Initially there are 3 users, user1, user2,user3. Now I want to give user ability to choose from exisitng users or add a new user (user4) there only.
Is that possible? If yes how can this be achieved please share if any samples are avaiable.
Thanks,
Piyush
2 answers
184 views
I am having an issue with the following. I have a general RadGrid with two specific Grid Template columns (RadComboBox/RadTextBox). The Combo box is formatted for Load on demand. When a value is found/selected from the combo box (OnIndexChanged) I want to populate the RadTextBox with the combo box DataValueField value.
I have access to the combo box in the onindexchanged event, but am not sure how to gain access to the RadTextBox in it's own template. Have tried a number of solutions over several days without success.
Thank you,
SteveO
I have access to the combo box in the onindexchanged event, but am not sure how to gain access to the RadTextBox in it's own template. Have tried a number of solutions over several days without success.
Thank you,
SteveO
3 answers
195 views
We have your 2012 AJAX Controls. We are using a RadGrid for a finical application. What the customer was doing before was cutting parts of an Excel spreadsheet into the clip board and pasting the content into another Excel spread sheet. I don't see any way to do this directly with the RadGird it self; however, can you give us an idea how we can provide a solution to allow the user to cut a range of cells and paste them into some type of textbox control then import the data into a RadGrid?
Thanks,
Steve Holdorf
Thanks,
Steve Holdorf
Pavlina
Telerik team
answered
on
24 Jul 2012
3 answers
638 views
Hello
Can anyone send how to create a header template in GridTemplateColumn programmatically in RadGrid, inorder to set the header context filter menu.
Thanks in advance.
