Skip to main content
Reporting Intelligence Help Center home page
Home Videos Support Sign in
  1. Reporting Intelligence
  2. Reporting Intelligence for BC Cloud
  3. Report Design for Reporting Intelligence for BC Cloud for Excel Desktop
  4. Report Writing Techniques

Report Writing Techniques

  • Excel Date Functions
  • Use Reporting Intelligence Dashboard Mode
  • Group and Subtotal Data
  • Filter Based on Data from Another Table
  • Indicate a Blank Cell
  • Hide Rows, Columns or Sheets Conditionally
  • Sort by Sum with Business Central
  • Sort by Sum for data sources other than NAV
  • Use the Excel IF function with Reporting Intelligence
  • Limit the Number of Records in a Query
  • Use SQL Views
  • Use NL Filter
  • Use Link
  • Use Inclusive Link
  • Using SQL=
  • Use Schema to return specific data
  • SQL= Reference
  • Use a Detail List or a Summary List
  • Add a Date and Time stamp to a Report
  • Table Cache Optimization
  • Evaluate Formulas
  • Load Pictures
Community