• State Verified Answer
  • Replies 3 replies
  • Subscribers 93 subscribers
  • Views 2260 views
  • Users 0 members are here
Options
Related

Simple List Report

Aadvik17
over 3 years ago

HI,

I have created a simple list report which will show the status of a Attestation policy on a particular run version 7.1.5.

I have two user prompt fields where user can select the Attestation Policy and Attestation Run.

My requirement is how to restrict showing all the Attestation Run  instead of that show run's which is mapped to a policy. Am not sure how to give a filter.

Thanks,

AAD

Parents Reply Children
  • 0 over 3 years ago in reply to Markus Weiss-Ehlers

    Hi Markus,

    I tried with the condition with @Ident_AttestationPolicy. and getting the below error.

    Then I added Declare @Ident_AttestationPolicy varchar(max), still no luck.

    Please advice. 

  • +1 over 3 years ago in reply to Aadvik17

    If you look at the thread or the documentation, you will find that you need to use $PC(Ident_AttestationPolicy)$ in your query.

    Condition (query)

    (Only for data source Table) Limiting condition (WHERE clause) for selecting the value through a table column. You can select a value from the result set. You can select several values from this set if the report parameter is multi-value, as well.

    You can reference other report parameters in the condition using the following syntax:

    $PC(<Parametername>)$

    Example:

    UID_Database = $PC(UID)$

    where UID is the name of the referenced report parameter.