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
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 2:45 PM
Points: 64, Visits: 168
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: Yesterday @ 11:59 AM
Points: 1,079, Visits: 2,305
http://technet.microsoft.com/en-us/library/aa337401(v=SQL.105).aspx
Post #1597245
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse