MicroStrategy ONE

List Reports statement

List all reports in a selected location in a project.

Copy 
LIST [ALL] REPORTS [IN FOLDERlocation_path] 
 FOR PROJECTproject_name;

where:

  • location_path is the folder where the reports are located, of type string, between double quotes (" ")

  • project_name is the name of the project, of type string, between double quotes (" ")

Examples

Copy 
LIST ALL REPORTS FOR PROJECT "MicroStrategy 
 Tutorial";
Copy 
LIST ALL REPORTS IN FOLDER "\Public Objects\Reports" 
 FOR PROJECT "MicroStrategy Tutorial";

ResultSet Columns

DSS_OBJECT_TYPE: The type of the report, such as "Graph Report". Returned as an integer:

  • 257: Custom Group

  • 512: Template

  • 768: Grid Report

  • 769: Graph Report

  • 770: SQL Report

  • 771: Text Report

  • 772: Data Mart Report

  • 773: Base Report

  • 774: Grid Graph Report

  • 775: Non Interactive Report

  • 776: Intelligent Cube

  • 1024: Metric

  • 1025: Subtotal

  • 1026: Subtotal

  • 1027: Predictive Metric

  • 1028: Training metric

  • 1536: AutoStyle

  • 1792: Base Formula

  • 2048: Folder

  • 2560: Prompt

  • 2561: Boolean prompt

  • 2562: Long number prompt

  • 2563: Text prompt

  • 2564: Numeric prompt

  • 2565: Date prompt

  • 2566: Object prompt

  • 2567: Elements prompt

  • 2568: Expression prompt

  • 2569: Expression draft prompt

  • 2571: Big Decimal Prompt

  • 2816: Function

  • 3072: Attribute

  • 3073: Role Attribute

  • 3074: Transformation Attribute

  • 3075: Abstract Attribute

  • 3328: Fact

  • 3584: System Hierarchy

  • 3585: Hierarchy

  • 3586: Ordered User Hierarchy

  • 3587: Hierarchy03840: Logical Table

  • 3841: Metadata Partition Mapping

  • 3842: Warehouse Partition Mapping

  • 4352: Fact Group

  • 4864: Resolution

  • 5376: Attribute form

  • 5377: Form

  • 5378: Form

  • 5632: Schema

  • 6144: Catalog

  • 6400: Catalog definition

  • 6656: Column

  • 7168: Property Set

  • 7424: Database Instance

  • 7680: Database login

  • 7936: Database connection

  • 8192: Project

  • 8448: Server Definition

  • 8704: User

  • 8705: User Group

  • 9216: Configuration

  • 9472: Request

  • 9984: Search

  • 10240: Search folder

  • 10752: Function Package Definition

  • 11008: Role

  • 11009: Transformation

  • 11264: Security role

  • 12032: Consolidation

  • 12288: Consolidation Element

  • 12544: Event

  • 12800: Schedule

  • 13056: Schedule

  • 13312: Link

  • 13568: Warehouse Table

  • 13569: Partition table

  • 13824: Table source

  • 14080: HTML Document

  • 14081: Document

  • 14336: Drill Map

  • 14592: DBMS

  • 14848: Security Filter

FOLDER: The path to the report, returned as a string.

HIDDEN: Whether or not the report is hidden, returned as a boolean value.

NAME: The name of the report, returned as a string.