Build Dashboard from a Data Table query
Hi ! I have a SQL table available where I wanted to show a radar graph based on its data. It turns out that BI Viewer is not providing radar or spider graphs, so I wanted to know how to have such g...
Forum Discussion
You can use the below code snippet to create one
Dim sql As New Text.StringBuilder
sql.AppendLine("Select * from Table1")
Using dbConnFW As DbConnInfo = BRAPi.Database.CreateApplicationDbConnInfo(si)
Using dt As DataTable = BRApi.Database.ExecuteSql(dbConnFW, sql.ToString, False)
'Use System.Data.DataTable objects to play with column and rows.
End Using
End Using