Sorting issue when access tabular model...

5 posts, 0 answers
  1. SHANG JYH
    SHANG JYH avatar
    5 posts
    Member since:
    Jan 2011

    Posted 19 Aug 2013 Link to this post

    I try to use RadPivotGrid to access SQL Server 2012 Tabular Model. I found even I set the column sorting logic in model, when I use RadPivotGrid to access the tabular model, the result is still order by DisplayName, not order by key...Is possible to order by key (as I setting in the model, not other columns/row in fieldlist)?
  2. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 22 Aug 2013 Link to this post

    Hi Shang Jyh,

    Unfortunately you are not able to control the sorting - you can only choose between Ascending or Descending. In the future we may add this feature, but I cannot give you exact timeframe.

    Hopefully this helps.

    Regards,
    Rosen Vladimirov
    Telerik
    TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for SILVERLIGHT.
    Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
    Sign up for Free application insights >>
  3. DevCraft banner
  4. SHANG JYH
    SHANG JYH avatar
    5 posts
    Member since:
    Jan 2011

    Posted 23 Aug 2013 Link to this post

    Thanks for your reply...

    I see there is "Sorting by other attribute/ measure" function in pivotfield list(Row/ Column).
    Is this possible to imprement it code-behind?
    If it possible, I can modify my tabular model and generate new measure for sorting ordinal, then I can put it into the pivottable and sorting according to this sorting measure.

    Is this a way to work around?
  5. SHANG JYH
    SHANG JYH avatar
    5 posts
    Member since:
    Jan 2011

    Posted 23 Aug 2013 Link to this post

    I try it. Using sorting measure is work around...
  6. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 26 Aug 2013 Link to this post

    Hello SHANG JYH,

    I'm glad you have found a workaround for your problem. Feel free to contact us in case you have any other problems or concerns.

    Regards,
    Rosen Vladimirov
    Telerik
    TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for SILVERLIGHT.
    Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
    Sign up for Free application insights >>
Back to Top
DevCraft banner