web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Visibilty report switc...
Customer experience | Sales, Customer Insights,...
Answered

Visibilty report switch case

(0) ShareShare
ReportReport
Posted on by Community Member

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

  • Kipetcoff Profile Picture
    Kipetcoff 1,037 on at

    Hello,

    What do you mean "switch case"?

  • Community Member Profile Picture
    Community Member on at

    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]
  • Verified answer
    Kipetcoff Profile Picture
    Kipetcoff 1,037 on at

    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

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

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
11manish Profile Picture

11manish 109 Super User 2026 Season 2

#2
Syed Aqib Raza Profile Picture

Syed Aqib Raza 88

#3
ParthPatel249 Profile Picture

ParthPatel249 84

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans