locked
Is it possible to change layout type from column to row and vice versa in code? RRS feed

Answers

All replies

  • I learnt to say "never say never", but I'm close to 100% sure it's NOT possible.

    paul van bladel

    • Proposed as answer by Xpert360 Tuesday, July 30, 2013 2:05 PM
    Tuesday, July 30, 2013 1:58 PM
  • I was hoping that this could be done by rendering a custom control but there is not enough information about if and how this can be done.

    Frank

    Wednesday, July 31, 2013 3:01 PM
  • Frank:

    This may not accomplish what you want to do, but I have an idea for you:

    I have several SQL views that use "PIVOT" to transform the columns and rows.  This will give you a read-only view of the data however.

    CREATE VIEW [dbo].[vw_RatioDataLiquidity] AS
    
    -- used for chart
    
    WITH Ratios AS (
    (SELECT * FROM dbo.RatioData
    PIVOT (SUM(RatioValue) 
    FOR RatioName IN ([Cash Ratio], [Current Ratio], [Acid Test Ratio])) AS RatioName
    ))
    SELECT  RatioDataItem_Client, TranDate,
    
    SUM([Cash Ratio]) AS CashRatio, 
    SUM([Current Ratio]) AS CurrentRatio, 
    SUM([Acid Test Ratio]) AS AcidTestRatio
    
    FROM Ratios
    GROUP BY RatioDataItem_Client, TranDate 

    I was thinking that you could have two grids on the screen, along with some code to hide/show each view.

    If you want to try this, you have to:

    1) Create the view in SQL Server.

    2) Add an external data source (if you don't already have one).

    3) Add the view to the data source.

    4) Add the view to your screen.

    Alternatively, you could probably use a RIA service instead of the view.

    -Mark

    Wednesday, July 31, 2013 6:08 PM
    • Marked as answer by TChiang Wednesday, August 7, 2013 4:23 PM
    Wednesday, July 31, 2013 8:15 PM
  • Good work!


    Frank

    Wednesday, August 7, 2013 4:23 PM