How to display value from JDBC query in Spreadsheet

 
1
0
-1

Hi,


I got one query which is call from MSSQL (query set in load binder: JDBC binder). 

SELECT TrxRem1 as 'A',TrxRem1 as 'A'
FROM cb.dbo.pp WHERE TNo = 'pp012200040'

How to display this result in spreadsheet drop down?

Had tried follow guide in JDBC Form Binder but, the dropdown not display any value.(sad)

TQ (smile)

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      In your spreadsheet column set up, your column name need to be 'A' since your data set is return the columns as such.

      1. Adib

        In spreadsheet column I did declare the column name and label as A, format type as Dropdown and Format as 'Child'. Im not sure on format, so I follow as guide in JDBC Form Binder..

        But once O preview, the value still not in drop down.

      CommentAdd your comment...