March 26, 2019 at 10:52 am
Is there anyway to implement a message on the run of all reports? The powers that be - want some sort of GDPR disclaimer.
Any ideas welcome.
Thanks
March 26, 2019 at 11:32 am
We use extended properties, and store the report styles in our database, a la Michael Coles: http://sqlblog.com/blogs/michael_coles/archive/2010/01/12/t-sql-tuesday-easy-extended-properties.aspx
use it for our confidentiality notice which is in the footer, which sounds like what you need for the GDPR.
Jjust set a text box in the footer and populate by using FIRST() on that reportstyle dataset and pull out the confidentiality notice value
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
March 27, 2019 at 3:47 am
Thanks Jonathan - I cant open that link I just get a login page and nowhere to actually register?
Thanks
March 29, 2019 at 6:46 am
you know what, that's the wrong link. I meant to point you to Barry King - https://www.red-gate.com/simple-talk/sql/reporting-services/reporting-services-with-style/
that one is still up, I checked.
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply