Jump to content

Leaderboard

Popular Content

Showing content with the highest reputation on 01/29/2020 in all areas

  1. Thank you @kpcollier !! :) Worked like a charm. Greatly appreciate your help!
    1 point
  2. BaySunshine

    Select Distinct Records

    Hi @bbeshlian, The solution for this issue is to use a table which has ID field marked as unique field in the table. Use this field as the data source of your report DataPage. To show the rest of the fields in the report, use calculated fields with SQL queries to query the view based on the same ID value. Be sure to include a Where condition which will help only pull a certain record for the respective ID value. When using a view in the calculated field, add '_v_' to the name of the table like shown below: select field_name1 from _v_viewname where field_name2='..........'
    1 point
×
×
  • Create New...