CounselLink Answer Center for Clients

Creating Pixel-Perfect Reports in Dashboards & Analytics

  • Updated

⚠️ Check Your Version.

The steps in this article are for Dashboards & Analytics (Amazon Q) users only. If you use Reports (Microstrategy), proceed to these articles instead.

This article covers the following:

About Pixel-Perfect reports

Pixel-Perfect reports are highly formatted, print-ready reports built from an analysis. This sheet type allows more control over the final report layout, including creating internal reports with a company logo, formatting headers and footers, creating fixed page layouts, or creating reports intended for PDF export.

When to Use a Pixel-Perfect Report

Use a Pixel-Perfect report when the final report layout is important. It is designed for reports that need to be printed, exported, distributed, or reviewed as a formal document.

Pixel-Perfect reports are useful for:

  • Internal reports that include a company logo or standard branding
  • Executive summaries prepared for leadership review
  • Monthly or quarterly legal spend reports
  • Reports that need headers, footers, page numbers, or report dates
  • Formal reports that should look consistent each time they are shared
  • Reports that need tables, charts, text, and images arranged in specific locations
  • Reports that are intended to be saved or distributed as a PDF

Use an Interactive sheet when dashboard users need to explore the data, apply filters, or drill into visuals. 

Example Use Case

Your organization needs a monthly legal spend report for internal leadership review. The report should include the company logo, report month, total spend, top vendors, spend by matter type, and a detailed table of invoice activity.

A Pixel-Perfect report can help create a consistent layout each month and may be exported as a formal document.

The report could include:

  • Header with company logo and report title
  • Summary KPIs for total spend, invoice count, and average invoice amount
  • Chart showing spend by vendor
  • Chart showing spend by matter type
  • Detailed invoice or matter table
  • Footer with report date and page number

This structure allows leadership to review high-level trends first, then reference supporting details later in the report.

Creating a Pixel-Perfect Report Sheet

Back to top

  1. Click Analyses from the left navigation panel.
  2. Open the analysis you want to update.

  3. Click the plus icon next to an existing sheet.

  4. Choose Pixel-Perfect report as the sheet type.

  5. Optional: Select Landscape to orient your report horizontally.
  6. Click Add.

The new Pixel-Perfect report sheet opens in the analysis. You can now add visuals, text, images, headers, footers, and other report content.

Adding Content to the Report

Back to top

After creating the Pixel-Perfect report sheet, add the content that will appear in the final report.

Common content includes:

  • Charts
  • Tables
  • Pivot tables
  • KPIs
  • Text boxes
  • Images, such as a company logo
  • Report titles or section headings
  • Summary notes or explanations

To add content:

  1. Open the Pixel-Perfect report sheet.
  2. Use the visual or insert options to add report content.
  3. Select the fields, measures, or dimensions needed for each visual. See this topic for more information.
  4. Place the content on the report page.

  5. Resize or reposition each item as needed.

Adding a Logo or Image

Back to top

You can use images to brand a report or make it easier to identify.

Common image uses include:

  • Company logo
  • Department logo
  • Branded header image

To add an image:

  1. Open the Pixel-perfect report sheet.

  2. Select the Add Image option.

  3. Upload or select the image. The image is added to the report.
  4. Place the image in the desired location.

  5. Resize or move the image as needed.

Working with Headers and Footers

Back to top

Headers and footers help make reports easier to read and distribute. They are commonly used for repeated information that should appear on each page.

Examples include:

  • Report name
  • Company name or logo
  • Report date
  • Page number
  • Confidentiality notice
  • Department or business unit name

To update a header or footer:

  1. Open the Pixel-perfect report sheet.

  2. Select the header or footer area.

  3. Add text, images, or other supported content.

  4. Format and position the content as needed.

Use headers and footers for information that should remain consistent across the report. Avoid placing large visuals in these areas unless they need to appear on each page.

Formatting the Report Layout

Back to top

Pixel-Perfect reports are intended for structured, repeatable layouts. Use formatting options to control how the report appears when viewed, printed, or exported.

Formatting options may include:

  • Page size
  • Page orientation
  • Margins
  • Section spacing
  • Visual placement
  • Text formatting
  • Image size
  • Header and footer content

To format the report:

  1. Select the report sheet or report section.

  2. Click Format visual. The Properties panel slides out.

  3. Adjust the page and layout settings.
  4. Select individual visuals or objects to format them.

Keep the layout simple and consistent. Use spacing, headings, and sections to guide the reader through the report.