We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Grid related questions

Thread ID:

Created:

Updated:

Platform:

Replies:

130145 Apr 24,2017 03:46 PM UTC Jul 26,2017 06:53 AM UTC Dashboard Platform 5
loading
Tags: Dashboard Widgets
Vishal Patel
Asked On April 24, 2017 03:46 PM UTC

I'm new to Designer and i have few questions regarding Grid,
Pulling data from sql server and using Syncfusion dashboard designer. 
Q:
1. When pull data some fields like qty, amount, price etc comes as measures and when add those column, it display as sum. how can i add those column as regular column.
2. i have more line which can fit on page, how can i do auto scroll vertically so row can be display without user interaction.

Thanks,
-Vishal

Ranjani Ramalingam [Syncfusion]
Replied On April 25, 2017 01:11 PM UTC

Hi Vishal, 

Thanks for your interest in Syncfusion product.  

Please find the response for your query. 

Query 
Answer 
When pull data some fields like qty, amount, price etc comes as measures and when add those column, it display as sum. how can i add those column as regular column. 
Currently we don’t have this support. We have always shows the summarize data for widget. 
i have more line which can fit on page, how can i do auto scroll vertically so row can be display without user interaction. 
Please provide us more details on the below queries. 
  1. You can’t fit all the line in single page?
  2. Are you using Grid widget?
  3. Do you wish the grid to scroll automatically?
  4. What should happen if the scroll reaches the end?
Provide us  more details on your exact requirement. Pictorial and video representations are much appreciated. 

Please let us know if you have any queries. 

Regards, 
Ranjani R. 


Vishal Patel
Replied On April 25, 2017 03:23 PM UTC

Hi, Ranjani

here is your queries reply, 
  1. You can’t fit all the line in single page?

          sometime I'm expecting more lines that it can fit on same page.

  1. Are you using Grid widget?

          yes,

  1. Do you wish the grid to scroll automatically?

          yes

  1. What should happen if the scroll reaches the end?

          goes on top and scroll down. also I have auto refresh set on page to pull new data every 5 min.

i'm planning to use sdk on dedicated machine to display this data on big screen. 

-Vishal



Ranjani Ramalingam [Syncfusion]
Replied On April 28, 2017 09:17 AM UTC

Hi Vishal, 

We have logged an feature report for Auto scroller for grid widget requirement. This feature will be available in any of our upcoming release. 

Please let us know if you have any queries

Regards, 
Ranjani R. 


Barrett Wainscott
Replied On July 25, 2017 09:33 PM UTC

I am having the same problem.  I just want to show a list of customers with customerid but it keeps calling my customer id a "measure" and tries to Sum it.  So you are saying there is no way to do this in a dashboard?  


Renuka N [Syncfusion]
Replied On July 26, 2017 06:53 AM UTC

Hi Barrett, 

We can achieve your requirement of displaying a measure value (customer id) as a dimension using “Change Column Type” support in Dashboard Application. For example, we have “EmployeeID” as measure and “FirstName” as dimension. we want to list “FirstName” with its corresponding “EmployeeID” without showing Sum of EmployeeID. Please refer “Transforming Data” section in the following UG link to achieve your requirement. 

Changing the column type to “Text” from “Default(Number)” 
 

Display “FirstName” with its corresponding “EmployeeID” 
 
 
After changing to “Text” type, EmployeeID shows with decimal points, this issue will be fixed and available in our upcoming release. But we can achieve to display EmployeeID without decimal places by creating expression field with following expression as a work around. 
 
IF(CONTAINS([EmployeeID],'.0') ='true', LEFT([EmployeeID],LEN([EmployeeID]) - 2),[EmployeeID]) 

Refer the UG link to create Expression field 
 
Bind Expression field to Grid 
 
 
 
Regards, 
Renuka N 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;