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
 General SQL Server Forums
 New to SQL Server Programming
 parameters

Author  Topic 

bencantello
Starting Member

10 Posts

Posted - 2008-04-24 : 15:49:52
I have a set of date parameters in reporting services which are defaulted to 3/01/08. How can I make them to the current month so that six months from now they are not still reading 3/01/08

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2008-05-06 : 08:06:16
Just set the default value in the report to Now() or Today() instead of a static value.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-05-06 : 08:20:32
You have a default value section parameters tab of report where you need to write the expression

=Now()
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2008-05-06 : 09:34:54
visakh16 - I think I have already answered this. Please do not post the same thing just to up your post count.
Go to Top of Page

elracorey
Starting Member

30 Posts

Posted - 2008-08-15 : 05:15:56
Hi,

I created a Web Services example which consists of an ASP.NET page with a Button to call a Report. Clicking the button calls the SSRS report, but I get the message saying that one of the expected input parameters could not be found in the report.
But it does exist, and works fine when I run directly from Visual Studio. Why is the ASP.NET page having trouble seeing it?

Thanks,
Lee

Just because something doesn't do what you planned it to do doesn't mean it's useless.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-15 : 11:37:42
quote:
Originally posted by RickD

visakh16 - I think I have already answered this. Please do not post the same thing just to up your post count.


i didnt see your post Rick. I'm not trying to just up my post count by repeating what was suggested earlier. What i missed was i didnt refresh page before hitting reply button. I started answering this but had to attend an urgent issue in b/w. Came back and hit submit before refreshing. then realised you'd replied by then. No offences meant.

Go to Top of Page
   

- Advertisement -