Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Answered

Visibilty report switch case

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello, I have some subreports and I would like them to appear only with switch case. How can I do this? 

  • Verified answer
    Kipetcoff Profile Picture
    Kipetcoff 1,002 on at
    RE: Visibilty report switch case

    Hi,

    I have only one idea

    1. Create one subreport with input parameter

    2. Switch you content inside subreport based on the parameter. Show one table to parameter 1 and another for 2.

    3. Add subreport on main report with passing parameters

    2022_2D00_09_2D00_22_5F00_23_2D00_30_2D00_20.png

    2022_2D00_09_2D00_22_5F00_23_2D00_31_2D00_42.png

    2022_2D00_09_2D00_22_5F00_23_2D00_29_2D00_13.png

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Visibilty report switch case

    Something like this

    switch showsubreport

       Sub-Reports must be presented according to field id in the database
    If field = "1
    Show SubReport > SubReport1
    If Field = "2
    Show Sub Report > SubReport2

    [quote user="Andrey Paltusov"]

    Hello,

    What do you mean "switch case"?

    [/quote]
  • Kipetcoff Profile Picture
    Kipetcoff 1,002 on at
    RE: Visibilty report switch case

    Hello,

    What do you mean "switch case"?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans