Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Need help in Genarating Report Expand / Collapse
Author
Message
Posted Thursday, February 28, 2013 10:55 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 12:02 AM
Points: 29, Visits: 107
Hi All,

Can anyone please help me in the below regard.

I have a report. If the user fetches report now, he should not be able to view for next 10 mins.

When the user clicks report in report, it has to say , Please wait for 10 mins.


Thanks is advance
Post #1425357
Posted Friday, March 01, 2013 2:46 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, April 14, 2014 2:19 AM
Points: 1,101, Visits: 5,271
May I ask why?

You can use cache option to show the same report.
Post #1425404
Posted Friday, March 01, 2013 3:28 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 12:02 AM
Points: 29, Visits: 107
But if i show from cache, the user may ask why the current minute details is not updated .
Report must go to DB only with a time gap of 10 mins. If user tries to view the report within 10 mins, it has to say him/her to wait for _ mins.

Thanks
Post #1425413
Posted Friday, March 01, 2013 6:49 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 9:49 AM
Points: 6,798, Visits: 6,272
Add a dataset to the report that queries the ExecutionLog table on the report server and show/hide parts of the report according to the time difference betwen last time the report was run and the current time.


Far away is close at hand in the images of elsewhere.

Anon.

Post #1425480
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse