Validity period for SSRS reports
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
We have ssrs 2008 r2 rdls. I open an SSRS report and keep it open in my browser for more than 30 mins. If I now click any drill downs either through an action or goto report. I don't want the report get me that info. It should state that the report is expired.
Is there a solution already available . Do future version SQL server have a solution for this.
sql-server reporting-services ssrs-2008 edited Nov 16 '18 at 22:37
Rahul Neekhra
5991627
asked Nov 16 '18 at 17:45
Moses GnanamanickamMoses Gnanamanickam
62
add a comment |
We have ssrs 2008 r2 rdls. I open an SSRS report and keep it open in my browser for more than 30 mins. If I now click any drill downs either through an action or goto report. I don't want the report get me that info. It should state that the report is expired.
Is there a solution already available . Do future version SQL server have a solution for this.
sql-server reporting-services ssrs-2008 edited Nov 16 '18 at 22:37
Rahul Neekhra
5991627
asked Nov 16 '18 at 17:45
Moses GnanamanickamMoses Gnanamanickam
62
1
It is unclear from your use of acronyms and this brief explanation what you are trying to do, what you have tried, and what results you get. Take the time to explain your problem and results as clearly as possible, formatting the text to make it clear what you are doing. If you cannot provide a Minimal, Complete, and Verifiable example perhaps you need to research over on dba.stackexchange.com.
– user1531971
Nov 16 '18 at 17:53
Clarification of questions should be in the question itself. Edit the question and make it clear in the text what you want to do, what you have tried with your Minimal, Complete, and Verifiable example and what results you got, including any error messages. From your comments, this looks like it isn't about coding, so it is probably off-topic for Stack Overflow.
– user1531971
Nov 16 '18 at 18:15
@jdv - the OP wants the SSRS report links to not work if the report has been opened for more than 30 minutes. If you don't know the product, maybe you shouldn't comment. Most devs know the MCVE is lame - most stackoverflow questions don't have it.
– Hannover Fist
Nov 16 '18 at 18:46
@HannoverFist you seem to be an expert so why are you putting a potential answer in a comment? Or, maybe, you could edit the question to make it more clear what is actually being asked here. Either way, comments are not for answers or complaining; they are for clarifying and improving Q&A.
– user1531971
Nov 16 '18 at 19:24
add a comment |
We have ssrs 2008 r2 rdls. I open an SSRS report and keep it open in my browser for more than 30 mins. If I now click any drill downs either through an action or goto report. I don't want the report get me that info. It should state that the report is expired.
Is there a solution already available . Do future version SQL server have a solution for this.
sql-server reporting-services ssrs-2008 edited Nov 16 '18 at 22:37
Rahul Neekhra
5991627
asked Nov 16 '18 at 17:45
Moses GnanamanickamMoses Gnanamanickam
62
We have ssrs 2008 r2 rdls. I open an SSRS report and keep it open in my browser for more than 30 mins. If I now click any drill downs either through an action or goto report. I don't want the report get me that info. It should state that the report is expired.
Is there a solution already available . Do future version SQL server have a solution for this.
sql-server reporting-services ssrs-2008 sql-server reporting-services ssrs-2008 edited Nov 16 '18 at 22:37
Rahul Neekhra
5991627
asked Nov 16 '18 at 17:45
Moses GnanamanickamMoses Gnanamanickam
62
edited Nov 16 '18 at 22:37
Rahul Neekhra
5991627
asked Nov 16 '18 at 17:45
Moses GnanamanickamMoses Gnanamanickam
62
edited Nov 16 '18 at 22:37
Rahul Neekhra
5991627
edited Nov 16 '18 at 22:37
Rahul Neekhra
5991627
edited Nov 16 '18 at 22:37
Rahul Neekhra
5991627
5991627
asked Nov 16 '18 at 17:45
Moses GnanamanickamMoses Gnanamanickam
62
asked Nov 16 '18 at 17:45
Moses GnanamanickamMoses Gnanamanickam
62
asked Nov 16 '18 at 17:45
Moses GnanamanickamMoses Gnanamanickam
62
62
1
It is unclear from your use of acronyms and this brief explanation what you are trying to do, what you have tried, and what results you get. Take the time to explain your problem and results as clearly as possible, formatting the text to make it clear what you are doing. If you cannot provide a Minimal, Complete, and Verifiable example perhaps you need to research over on dba.stackexchange.com.
– user1531971
Nov 16 '18 at 17:53
Clarification of questions should be in the question itself. Edit the question and make it clear in the text what you want to do, what you have tried with your Minimal, Complete, and Verifiable example and what results you got, including any error messages. From your comments, this looks like it isn't about coding, so it is probably off-topic for Stack Overflow.
– user1531971
Nov 16 '18 at 18:15
@jdv - the OP wants the SSRS report links to not work if the report has been opened for more than 30 minutes. If you don't know the product, maybe you shouldn't comment. Most devs know the MCVE is lame - most stackoverflow questions don't have it.
– Hannover Fist
Nov 16 '18 at 18:46
@HannoverFist you seem to be an expert so why are you putting a potential answer in a comment? Or, maybe, you could edit the question to make it more clear what is actually being asked here. Either way, comments are not for answers or complaining; they are for clarifying and improving Q&A.
– user1531971
Nov 16 '18 at 19:24
add a comment |
1
It is unclear from your use of acronyms and this brief explanation what you are trying to do, what you have tried, and what results you get. Take the time to explain your problem and results as clearly as possible, formatting the text to make it clear what you are doing. If you cannot provide a Minimal, Complete, and Verifiable example perhaps you need to research over on dba.stackexchange.com.
– user1531971
Nov 16 '18 at 17:53
Clarification of questions should be in the question itself. Edit the question and make it clear in the text what you want to do, what you have tried with your Minimal, Complete, and Verifiable example and what results you got, including any error messages. From your comments, this looks like it isn't about coding, so it is probably off-topic for Stack Overflow.
– user1531971
Nov 16 '18 at 18:15
@jdv - the OP wants the SSRS report links to not work if the report has been opened for more than 30 minutes. If you don't know the product, maybe you shouldn't comment. Most devs know the MCVE is lame - most stackoverflow questions don't have it.
– Hannover Fist
Nov 16 '18 at 18:46
@HannoverFist you seem to be an expert so why are you putting a potential answer in a comment? Or, maybe, you could edit the question to make it more clear what is actually being asked here. Either way, comments are not for answers or complaining; they are for clarifying and improving Q&A.
– user1531971
Nov 16 '18 at 19:24
1
1
It is unclear from your use of acronyms and this brief explanation what you are trying to do, what you have tried, and what results you get. Take the time to explain your problem and results as clearly as possible, formatting the text to make it clear what you are doing. If you cannot provide a Minimal, Complete, and Verifiable example perhaps you need to research over on dba.stackexchange.com.
– user1531971
Nov 16 '18 at 17:53
It is unclear from your use of acronyms and this brief explanation what you are trying to do, what you have tried, and what results you get. Take the time to explain your problem and results as clearly as possible, formatting the text to make it clear what you are doing. If you cannot provide a Minimal, Complete, and Verifiable example perhaps you need to research over on dba.stackexchange.com.
– user1531971
Nov 16 '18 at 17:53
Clarification of questions should be in the question itself. Edit the question and make it clear in the text what you want to do, what you have tried with your Minimal, Complete, and Verifiable example and what results you got, including any error messages. From your comments, this looks like it isn't about coding, so it is probably off-topic for Stack Overflow.
– user1531971
Nov 16 '18 at 18:15
Clarification of questions should be in the question itself. Edit the question and make it clear in the text what you want to do, what you have tried with your Minimal, Complete, and Verifiable example and what results you got, including any error messages. From your comments, this looks like it isn't about coding, so it is probably off-topic for Stack Overflow.
– user1531971
Nov 16 '18 at 18:15
@jdv - the OP wants the SSRS report links to not work if the report has been opened for more than 30 minutes. If you don't know the product, maybe you shouldn't comment. Most devs know the MCVE is lame - most stackoverflow questions don't have it.
– Hannover Fist
Nov 16 '18 at 18:46
@jdv - the OP wants the SSRS report links to not work if the report has been opened for more than 30 minutes. If you don't know the product, maybe you shouldn't comment. Most devs know the MCVE is lame - most stackoverflow questions don't have it.
– Hannover Fist
Nov 16 '18 at 18:46
@HannoverFist you seem to be an expert so why are you putting a potential answer in a comment? Or, maybe, you could edit the question to make it more clear what is actually being asked here. Either way, comments are not for answers or complaining; they are for clarifying and improving Q&A.
– user1531971
Nov 16 '18 at 19:24
@HannoverFist you seem to be an expert so why are you putting a potential answer in a comment? Or, maybe, you could edit the question to make it more clear what is actually being asked here. Either way, comments are not for answers or complaining; they are for clarifying and improving Q&A.
– user1531971
Nov 16 '18 at 19:24
add a comment |
2 Answers
2
active
oldest
votes
There not a built in way to do this natively in SSRS.
I haven't heard of anyone asking about a requirement like this before so I doubt that there's something already in the works to add it.
I don't know JavaScript enough to know whether or not you can add logic to the JavaScript URL to where it would create a blank link or link to a Page Expired page.
="javascript:void(window.open('https://na5.salesforce.com/','_blank'))"
answered Nov 17 '18 at 0:50
Hannover FistHannover Fist
5,9951825
add a comment |
You could create a hidden datetime parameter on the main report and set its default value to the current time: =Now(). Let's call this parameter @MainReportRuntime.
Make this same hidden parameter on your subreports and pass @MainReportRuntime through to the subreports.
Modify the SQL of the subreport to only return data when the date is within half an hour of the main report runtime and add the report expiry message when it is greater than half an hour old:
SELECT SomeField
FROM SomeTable
WHERE @MainReportRuntime >= DateAdd(mi, -30, Current_Timestamp)
UNION ALL
SELECT 'Report has expired - please rerun report to get current data'
WHERE @MainReportRuntime < DateAdd(mi, -30, Current_Timestamp)
answered Nov 18 '18 at 23:31
Chris LattaChris Latta
17.5k45063
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53342935%2fvalidity-period-for-ssrs-reports%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
There not a built in way to do this natively in SSRS.
I haven't heard of anyone asking about a requirement like this before so I doubt that there's something already in the works to add it.
I don't know JavaScript enough to know whether or not you can add logic to the JavaScript URL to where it would create a blank link or link to a Page Expired page.
="javascript:void(window.open('https://na5.salesforce.com/','_blank'))"
answered Nov 17 '18 at 0:50
Hannover FistHannover Fist
5,9951825
add a comment |
There not a built in way to do this natively in SSRS.
I haven't heard of anyone asking about a requirement like this before so I doubt that there's something already in the works to add it.
I don't know JavaScript enough to know whether or not you can add logic to the JavaScript URL to where it would create a blank link or link to a Page Expired page.
="javascript:void(window.open('https://na5.salesforce.com/','_blank'))"
answered Nov 17 '18 at 0:50
Hannover FistHannover Fist
5,9951825
add a comment |
There not a built in way to do this natively in SSRS.
I haven't heard of anyone asking about a requirement like this before so I doubt that there's something already in the works to add it.
I don't know JavaScript enough to know whether or not you can add logic to the JavaScript URL to where it would create a blank link or link to a Page Expired page.
="javascript:void(window.open('https://na5.salesforce.com/','_blank'))"
answered Nov 17 '18 at 0:50
Hannover FistHannover Fist
5,9951825
There not a built in way to do this natively in SSRS.
I haven't heard of anyone asking about a requirement like this before so I doubt that there's something already in the works to add it.
I don't know JavaScript enough to know whether or not you can add logic to the JavaScript URL to where it would create a blank link or link to a Page Expired page.
="javascript:void(window.open('https://na5.salesforce.com/','_blank'))"
answered Nov 17 '18 at 0:50
Hannover FistHannover Fist
5,9951825
answered Nov 17 '18 at 0:50
Hannover FistHannover Fist
5,9951825
answered Nov 17 '18 at 0:50
Hannover FistHannover Fist
5,9951825
answered Nov 17 '18 at 0:50
Hannover FistHannover Fist
5,9951825
5,9951825
add a comment |
add a comment |
You could create a hidden datetime parameter on the main report and set its default value to the current time: =Now(). Let's call this parameter @MainReportRuntime.
Make this same hidden parameter on your subreports and pass @MainReportRuntime through to the subreports.
Modify the SQL of the subreport to only return data when the date is within half an hour of the main report runtime and add the report expiry message when it is greater than half an hour old:
SELECT SomeField
FROM SomeTable
WHERE @MainReportRuntime >= DateAdd(mi, -30, Current_Timestamp)
UNION ALL
SELECT 'Report has expired - please rerun report to get current data'
WHERE @MainReportRuntime < DateAdd(mi, -30, Current_Timestamp)
answered Nov 18 '18 at 23:31
Chris LattaChris Latta
17.5k45063
add a comment |
You could create a hidden datetime parameter on the main report and set its default value to the current time: =Now(). Let's call this parameter @MainReportRuntime.
Make this same hidden parameter on your subreports and pass @MainReportRuntime through to the subreports.
Modify the SQL of the subreport to only return data when the date is within half an hour of the main report runtime and add the report expiry message when it is greater than half an hour old:
SELECT SomeField
FROM SomeTable
WHERE @MainReportRuntime >= DateAdd(mi, -30, Current_Timestamp)
UNION ALL
SELECT 'Report has expired - please rerun report to get current data'
WHERE @MainReportRuntime < DateAdd(mi, -30, Current_Timestamp)
answered Nov 18 '18 at 23:31
Chris LattaChris Latta
17.5k45063
add a comment |
You could create a hidden datetime parameter on the main report and set its default value to the current time: =Now(). Let's call this parameter @MainReportRuntime.
Make this same hidden parameter on your subreports and pass @MainReportRuntime through to the subreports.
Modify the SQL of the subreport to only return data when the date is within half an hour of the main report runtime and add the report expiry message when it is greater than half an hour old:
SELECT SomeField
FROM SomeTable
WHERE @MainReportRuntime >= DateAdd(mi, -30, Current_Timestamp)
UNION ALL
SELECT 'Report has expired - please rerun report to get current data'
WHERE @MainReportRuntime < DateAdd(mi, -30, Current_Timestamp)
answered Nov 18 '18 at 23:31
Chris LattaChris Latta
17.5k45063
You could create a hidden datetime parameter on the main report and set its default value to the current time: =Now(). Let's call this parameter @MainReportRuntime.
Make this same hidden parameter on your subreports and pass @MainReportRuntime through to the subreports.
Modify the SQL of the subreport to only return data when the date is within half an hour of the main report runtime and add the report expiry message when it is greater than half an hour old:
SELECT SomeField
FROM SomeTable
WHERE @MainReportRuntime >= DateAdd(mi, -30, Current_Timestamp)
UNION ALL
SELECT 'Report has expired - please rerun report to get current data'
WHERE @MainReportRuntime < DateAdd(mi, -30, Current_Timestamp)
answered Nov 18 '18 at 23:31
Chris LattaChris Latta
17.5k45063
answered Nov 18 '18 at 23:31
Chris LattaChris Latta
17.5k45063
answered Nov 18 '18 at 23:31
Chris LattaChris Latta
17.5k45063
answered Nov 18 '18 at 23:31
Chris LattaChris Latta
17.5k45063
17.5k45063
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53342935%2fvalidity-period-for-ssrs-reports%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
It is unclear from your use of acronyms and this brief explanation what you are trying to do, what you have tried, and what results you get. Take the time to explain your problem and results as clearly as possible, formatting the text to make it clear what you are doing. If you cannot provide a Minimal, Complete, and Verifiable example perhaps you need to research over on dba.stackexchange.com.
– user1531971
Nov 16 '18 at 17:53
Clarification of questions should be in the question itself. Edit the question and make it clear in the text what you want to do, what you have tried with your Minimal, Complete, and Verifiable example and what results you got, including any error messages. From your comments, this looks like it isn't about coding, so it is probably off-topic for Stack Overflow.
– user1531971
Nov 16 '18 at 18:15
@jdv - the OP wants the SSRS report links to not work if the report has been opened for more than 30 minutes. If you don't know the product, maybe you shouldn't comment. Most devs know the MCVE is lame - most stackoverflow questions don't have it.
– Hannover Fist
Nov 16 '18 at 18:46
@HannoverFist you seem to be an expert so why are you putting a potential answer in a comment? Or, maybe, you could edit the question to make it more clear what is actually being asked here. Either way, comments are not for answers or complaining; they are for clarifying and improving Q&A.
– user1531971
Nov 16 '18 at 19:24