SSRS - show reports like slideshow

  • Hi,

    I have a requirement to show reports (two reports)one after the other like a slide show. The first one already is set like a dashboard with auto refresh property on for 120 seconds. How do I include the other report here ?

    Report A - Refreshes every 120 seconds

    After that I want Report B to be displayed for 120 seconds

    Then Report A should be displayed..

    Thanks,

    PSB

  • The way I would do this is probably via a customer web page with a ReportViewer control that handled switching reports...

    But, you can do it with a parent report as well.

    Attached are three sample reports - no data connections, just text boxes - to demonstrate the method.

    You simply create a parent report and place both reports on as subreports, with an expression for their visibility:

    Report 1:

    = Iif((minute(Now) mod 4)<2,True,False)

    Report 2:

    = Iif((minute(Now) mod 4)>=2,True,False)

    And set the parent report to refresh every 120 seconds.

    MM



    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
  • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • [/url]
  • How to Post Performance Problems - by Gail Shaw
  • [/url]

  • Thanks!

  • Can you explain what is done with :

    = Iif((minute(Now) mod 4)<2,True,False)

    Report 2:

    = Iif((minute(Now) mod 4)>=2,True,False)

    Thanks,

    PSB

  • Also

    AS mentioned before, the requirement is to show reports (two reports)one after the other like a slide show as two different reports (not in the main report).

    Report A - Refreshes every 120 seconds

    After that I want Report B to be displayed for 120 seconds. Report A should not be displayed at this time.

    Then Report A should be displayed and Report B should not be displayed at this time..

    Thanks,

    PSB

  • PSB (3/31/2014)


    Can you explain what is done with :

    = Iif((minute(Now) mod 4)<2,True,False)

    Report 2:

    = Iif((minute(Now) mod 4)>=2,True,False)

    Thanks,

    PSB

    Those expressions decide whether to show Report 1 or Report 2 by checking the current minute.

    MM



    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
  • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • [/url]
  • How to Post Performance Problems - by Gail Shaw
  • [/url]

  • PSB (3/31/2014)


    Also

    AS mentioned before, the requirement is to show reports (two reports)one after the other like a slide show as two different reports (not in the main report).

    Report A - Refreshes every 120 seconds

    After that I want Report B to be displayed for 120 seconds. Report A should not be displayed at this time.

    Then Report A should be displayed and Report B should not be displayed at this time..

    Thanks,

    PSB

    AS I said in my answer, a custom web page with the report viewer control is the way to do this without a parent report.

    MM



    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
  • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • [/url]
  • How to Post Performance Problems - by Gail Shaw
  • [/url]

  • I can not use report viewer control as I am not using a web page.

  • You have set yourself some unreasonable conditions.

    The parent report will do what you want, displaying one and only one report at a time.

    Is there a good reason why you are ruling that out?

    MM



    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
  • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • [/url]
  • How to Post Performance Problems - by Gail Shaw
  • [/url]

  • The parent report in SSRS is Dashboard1. After around 2 minutes we need to display Dashboard2 then after 2 minutes display Dashboard1 again..

    As all our reports are viewed in report manager, and we have not yet moved to SharePoint or web, it is the only way to make this work.

  • You need a parent report, you cannot do it just with report 1 and report 2.

    The sample I gave works just like that - did you try it?

    MM



    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
  • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • [/url]
  • How to Post Performance Problems - by Gail Shaw
  • [/url]

  • Your example works perfectly .

    Thank You!

  • Hello,

    I have the 2 reports working. What would I change in the mod and less then greater then for 3-5 sub reports?

    Thanks

    Report 1:

    = Iif((minute(Now) mod 4)<2,True,False)

    Report 2:

    = Iif((minute(Now) mod 4)>=2,True,False)

    Report 3:

    Report 4:

  • Viewing 13 posts - 1 through 12 (of 12 total)

    You must be logged in to reply to this topic. Login to reply