March 3, 2014 at 9:00 am
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
March 3, 2014 at 4:46 pm
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);March 3, 2014 at 4:57 pm
Thanks!
March 31, 2014 at 12:14 pm
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
March 31, 2014 at 12:44 pm
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
March 31, 2014 at 5:12 pm
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);March 31, 2014 at 5:14 pm
PSB (3/31/2014)
AlsoAS 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);March 31, 2014 at 5:19 pm
I can not use report viewer control as I am not using a web page.
March 31, 2014 at 5:21 pm
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);March 31, 2014 at 5:26 pm
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.
March 31, 2014 at 5:28 pm
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);March 31, 2014 at 5:37 pm
Your example works perfectly .
Thank You!
June 18, 2014 at 8:53 am
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