Hi Christian,
Thank you for your answer, yes it your BR will help me a lot,i have one more question what type of BR is yours? extesibility Rule or Dashboard Extender one?
Regards
Hi hoaphan
Were you able to implement this BR? I'm trying to figure how did you setup the source target?
Something like this, gives you the datatable object:
'Define the SQL Statement
Dim sql As New Text.StringBuilder
sql.Append("Select * ")
sql.Append("From <Your Table> ")
sql.Append("Where <your Restrictions> ")
Dim dt as datatable
Using dbConnApp As DBConnInfo = BRAPi.Database.CreateApplicationDbConnInfo(si)
dt = BRAPi.Database.ExecuteSql(dbConnApp, sql.ToString, False)
End UsingYes, I used it several times. You just need to use the same sql statement that you used for the grid with one of the brapi.database functions.