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

One report Multiple Subscription Daily & Weekly Expand / Collapse
Author
Message
Posted Monday, July 28, 2014 8:34 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 1:31 PM
Points: 83, Visits: 197
What is the best way to deliver this report, I have in the past just created another report for weekly, and a report for daily. Is there a better way of using only one report. I am sure others have come across this and have had the same issues, I would like just one report and different date values. if anyone could give some advice, I have thought of using a parameter for daily and weekly, if daily then use daily values as default else if weekly then use daily values as the default. Would this be the way to go or is there a more efficient way?
Post #1596890
Posted Tuesday, July 29, 2014 6:23 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 4:58 AM
Points: 1,110, Visits: 2,377
http://technet.microsoft.com/en-us/library/aa337401(v=SQL.105).aspx
Post #1597245
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse