Showing posts with label current. Show all posts
Showing posts with label current. Show all posts

Friday, March 30, 2012

If in current month

I need to do this but can't find the syntax:

IIf(Fields!EnteredDate.Value is in current month , Cint(Fields!PC.Value), CInt(0))

I think theres a month, day and date function that you can use for this.|||

Failing that something like:

IIF(DateAdd("m",0,Fields!EnteredDate.Value) = DateAdd("m",0,now()), Cint(Fields!PC.Value), CInt(0))

DateAdd(<level to extract>, <Point in time>, <set>)

I'm not sure about the current date function. Isn't there a Global parameter which gets the system current date!?

|||

=iif(Month(Fields!EnteredDate.Value) = Month(Today), CInt(Fields!PC.Value), CInt(0))

See also: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vafctmonth.asp

Similar to the Month() function, there are also other functions available in the VB Runtime Library - such as Year(), Day(), etc.

-- Robert

|||How can I restrict dates that are in this month and year. For example if today is 2/20/2006, I do not want that EnteredDate included. 2/20/2005 is acceptable though...|||

solved my second question:

=IIF(Month(Fields!EnteredDate.Value) & Year(Fields!EnteredDate.Value) <> Month(Today) & Year(Today),Cint(Fields!PDC.Value),0)

Friday, March 23, 2012

IE browser not printing multiple page reports

Hi,
We are currently running RS 2000, sp2. When the user prints a multiple paged
report from the IE browser, it is printing the current page only. Is this an
issue or is it just a setting of some sort?
Thanks for your help!It sounds to me like you are using the printing functionality from IE, not
the new print icon on the toolbar of Report Manager.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"clutch" <clutch@.discussions.microsoft.com> wrote in message
news:8C8E0E0A-FCF1-4803-B360-B3B95267B118@.microsoft.com...
> Hi,
> We are currently running RS 2000, sp2. When the user prints a multiple
> paged
> report from the IE browser, it is printing the current page only. Is this
> an
> issue or is it just a setting of some sort?
> Thanks for your help!

Monday, March 19, 2012

Identity Seed

Hi guys,
Please is it possible in SQL SERVER any version (Prefferably 2005) to set my Identity seed to the current year so that when we are in 2008 it continues from 2008 ?

Best Regards

I'm not too sure why you want to use current year as the seed. Anyways, AFAIK this is not possible.

Can you explain your problem so that we can help you better ?

|||

websyd:

set my Identity seed to the current year so that when we are in 2008 it continues from 2008

This defeats the purpose of an identiy column, Identiy columns are "dataless", they have no intrinsic meaning other than to uniquely identify the row within a table. And you can't do it, anyway.

What are you trying to do?