Forum Discussion

JonSwed's avatar
JonSwed
Icon for Advocate II rankAdvocate II
4 years ago

Link one report to another, and include dynamic URL values for filtering

Hi all.

I'm building reports in desktop, publishing to service and then sharing with my colleagues as embedded reports in Sharepoint.

This my scenario:

Report 1. This allows the user to search for an account id. I want to be able to include a link, to report 2, where the account id the user has searched for is used as a filter on report 2.

This is mainly for reasons off efficiency. Due to the nature of the data I cannot aggregate and it is millions of rows. Adding this data to report 1 makes it very large.

Is it possible to create a link from report 1, which contains the account id filter which will then be applied when the user clicks on the link to the report 2?

Many thanks!



Need Help

2 Replies

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi JonSwed 

    Not sure, do you mean you want the users to set account id on Report 1 and get the link to Report 2 filtered by account id? Could you show us your Report 1? 

     

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

    • JonSwed's avatar
      JonSwed
      Icon for Advocate II rankAdvocate II
      4 years ago

      Hi! Yes. The user can enter an account id. 

      I then want to add that accountid to a link which will take the user to another report, which will then be filtered to the account id.

      I cannot share the report, as it contains confidential information, but if it helps I can create a dummy version .