Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Getting started

  • Installing OfficeWriter SQL Server Reporting Services Integration
  • Differences between the original OfficeWriter Designer and the OfficeWriter Designer .NET
  • Image Added

    What is SSRS Integration?

    OfficeWriter Reporting Services Integration enhances Microsoft SQL Server Reporting Services by allowing users to design and deliver their reports in native Word and Excel.

    Reporting Service Integration consists of two components:

    Sectionpanel
    Column
    width48%
    Section
     
    Section
    Column
    width
    50%
    title
    35
    Panel
    bgColor
    whitetitleBGColor#EEE
    #f6fbfc

    The OfficeWriter Renderer

    borderColor#AAAtitleColor#666

    The OfficeWriter renderer runs on the Reporting Services server.

    The renderer takes a template RDL file that was designed using the OfficeWriter Designer, and populates it with data supplied by Reporting Services.

    Column
    width
    50%titleBGColor#EEEtitle
    35
    Panel
    bgColor
    white
    #f6fbfc

     The OfficeWriter Designer

    borderColor#AAAtitleColor#666

    The OfficeWriter Designer is a toolbar add-in for Microsoft Excel and Word.

    With the OfficeWriter Designer, you design a report in Word or Excel. Any formula, charts, or other advanced Office functionality will be present in the output file when the report is run.

     


     

    52%
    Panel
    borderStylenone

    Getting started with SSRS Integration

    Column
    width
    33
    Panel
    borderStylenone

    Topics


    Children Display
    pageTopics

    Column
    width33
    Panel
    bgColorwhite
    titleBGColor#EEE
    titleSSRS Integration Documentation Sections
    borderStylenone
    borderColor#BBB
    titleColor#444

    Creating Your First Report


    Children Display
    pageCreating Your First Report

    Column
    width33
    Panel
    bgColorwhite
    titleBGColor#EEE
    borderStylenone
    borderColor#BBB
    titleColor#444

    Server Side Renderer Configuration


    Children Display
    pageServer Side Renderer Configuration

    Column
    width49
    h4
    Panel
    borderStylenone

    SSRS Integration for Excel


    Column
    Panel
    borderStylenone

    How to Create Excel Reports


    Children Display
    pageHow to Create Excel Reports
    depth1

    Column
    Panel
    bgColorwhite
    titleBGColor#EEE
    borderStylenone
    borderColor#BBB
    titleColor#444

    The OfficeWriter Designer .NET for Excel


    Children Display

    style

    pageThe OfficeWriter Designer .NET for Excel
    depth

    2

     

     

    1

    Panel
    bgColorwhite
    titleBGColor#EEE
    borderStylenone
    borderColor#BBB
    titleColor#444

    The OfficeWriter Designer for Excel


    Children Display
    pageThe OfficeWriter Designer for Excel
    depth1

     

     

    Column
    width50
    Panel
    borderStylenone

     SSRS Integration for Word


    Column
    Panel
    borderStylenone

    How to Create Word Reports


    Children Display
    pageHow to Create Word Reports
    depth1

    Column
    Panel
    bgColorwhite
    titleBGColor#EEE
    borderStylenone
    borderColor#BBB
    titleColor#444

    The OfficeWriter Designer .NET for Word


    • Coming soon!
    Panel
    bgColorwhite
    titleBGColor#EEE
    borderStylenone
    borderColor#BBB
    titleColor#444

    The OfficeWriter Designer for Word


    Children Display
    pageThe OfficeWriter Designer for Word
    depth1