Skip to main content

Notifications

Microsoft Dynamics CRM forum
Answered

Visibilty report switch case

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? 

Categories:
  • Verified answer
    Kipetcoff Profile Picture
    Kipetcoff 1,000 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,000 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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans