[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 563
  • Last Modified:

How can I build a glossary on SSRS reports?

I have implemented a new SSRS report based on new terminology, unfamiliar to the masses.

What I would like to do:

1. Place ? icons on the main report page and then on each column

2. When either icon is clicked:
a. Main Report Page - To Provide overall purpose of the report
b. On Each Column  - To Provide a definition of the terminology used or definition of the formulas used.

I do not want to utilize tool tips but rather through a glossary database.
0
rhservan
Asked:
rhservan
  • 2
1 Solution
 
ValentinoVBI ConsultantCommented:
If you don't want tool tips then I think the only remaining built-in option is drill through in which the ? image gets clicked and you use the Action > Go To Report functionality to display the description.

The report to which you're navigating should have one parameter to indicate what description it needs to display, some code or identifier.  And this code gets passed in from the image's Action.
0
 
rhservanAuthor Commented:
V V, I know what your saying and I also need to build the database structure to hold the glossary.
0
 
ValentinoVBI ConsultantCommented:
Your table can be relatively simple, something like:

      GlossaryID int NOT NULL IDENTITY (1, 1),
      Code varchar(10) NOT NULL,
      Description varchar(1000) NOT NULL
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now