Forum Discussion

Ashok's avatar
Ashok
New Contributor III
2 years ago

Line Items in DataCellDetail - using BR

Hi Experts, i am trying to read the line items from celldetails. I think i get the sytax of BR functions it compiles fine but getting  "Object reference not set to an instance of an object." erro...
Dashboards
  • Ashok's avatar
    Ashok
    2 years ago

    I am able to do it like below in a BR.

    1. Execute the Method query to get the data set
    2. Copy data set into a datable 
    3. use the data table to read the rows 

     

    Example code:

     

    Dim MyDataSet As DataSet
    Using dbConnApp As DbConnInfo = BRApi.Database.CreateApplicationDbConnInfo(si)
    MyDataSet= BRApi.Database.ExecuteMethodCommand(dbConnApp,XFCommandMethodTypeId.DataCellDetail, "{AUM}{E#RevAccComments}{RevAccRecon}{T#"+Year+quarter+"}{}{}{}{}{}{}{}{}{}{}{}{UD4='"+row("Product")+"' and UD6='"+FeeType+"'}", "MyDataCellDetail", Nothing)
    Dim dt As DataTable = MyDataSet.Tables("MyDataCellDetail").Copy

Ashok's avatar
Ashok
New Contributor III

Here is the screenshot: user input cell details using this feature

Below screenshow the lineitems when you select "Celldetail" option. I am trying read this detail and add to the report.

 hopefully this helps understand the requirement. 

amvillaruel's avatar
amvillaruel
New Contributor II
2 years ago

Hi Ashok,

I am trying to do the same thing and I think there is a method type that we can use to pull the cell details in a dashboard.

The method type is called DataCellDetail and it uses this syntax:

So if I am trying to pull these cell details:

 

 

Then I use the DataCellDetail syntax to pull them in a data adapter like this:

 

From there, you can attach this data adapter to compatible dashboard components to further process the retrieved cell details.

Hope this helps.