How Can I set default from data and to date in a r

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Reporting Services Development

How Can I set default from data and to date in a r

Author

Topic

bob12
Starting Member

8 Posts

Posted - 2009-04-17 : 09:01:56

Hi,
I am new to reporting services can some one help me.

how can I set default from date to 1st day of previous month and Todate to last day of last month in reports so that I can Schedule them.

How can we schedule report to save it to network folder?

Thank you
bob

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-04-17 : 11:35:56

just create two datasets one as

SELECT DATEADD(mm,DATEDIFF(mm,0,GETDATE())-2,0) AS Value

and second as

SELECT DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0)-1 AS Value

then map the fromdate and todate params to each of these datasets in parameter properties tab under default value->from query

bob12
Starting Member

8 Posts

Posted - 2009-04-17 : 23:43:09

What a neat idea. I never though of doing it that way. I will try that.

Is there a way to schedule a report to network folder instead of email?

Thank you
Bob

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-04-18 : 15:37:42

you can.see below
http://www.codeproject.com/KB/reporting-services/reportsthrusubs.aspx

bob12
Starting Member

8 Posts

Posted - 2009-04-18 : 21:26:37

Thank you so much. That is exactly I am looking for. Unfortunately I don't have access to reportserver. I will request that and will try.

Bob

bob12
Starting Member

8 Posts

Posted - 2009-04-19 : 00:32:26

Thank you Visakh. It is working perfect.