Showing posts with label feature. Show all posts
Showing posts with label feature. Show all posts

Monday, March 12, 2012

Problems with Hidden visibility feature

I'm pretty new to Reporting Services so Im sure this is just something that I am messing up out of nievite! I need help hiding columns in a tab report when the column date is greater than the as of date parameter( they have a choice of chosing today, and as far back as the lasy day of last month) ...this is the formula that I am using:

IIf(FormatDateTime(DateAdd("D", 0, FormatDateTime(Cstr(Month(Parameters!b_001_AsOfData.Label)) + "/01/" + Cstr(Year(Parameters!b_001_AsOfData.label)),1)), 1)<(Parameters!b_001_AsOfData.Value),true,false)

I have tried using it per column in the visibility as well as in the tables visibility function....what the heck am I doing wrong? Any insight would be GREATLY appriciated!

thnks!

Sheidee

The type of Parameters!b_001_AsOfData.Label is a string, not DateTime. Have you tried using Parameters!b_001_AsOfData.Value instead?|||AAAhhh ~ Thanks! :)

Saturday, February 25, 2012

Problems with Autogrowth feature

I cannot via SSMS change the autogrowth setting for a database. It is currently set to restricted and I want it set to unrestricted. I make the change, click ok and no error appears but when I open it again the change is not there.

I also tried creating a new database and noticed that the autogrowth setting of unrestricted is not copied from the model db to the new one.

This happens only with the log file. I have SQL 2005 SP1. Any help is appreciated.

What recovery model are you using, Simple or Full?|||I'm using Full recovery mode.|||

Hi Heather,

The maximum size for a log file in 2005 is 2TB. I'm betting that although filesize is displaying as "restricted", the MAXSIZE is indeed 2TB (2,097,152MB). So, within the confines of capacity limitations, it is unlimited so to speak

Cheers,
Rob

Problems with Autogrowth feature

I cannot via SSMS change the autogrowth setting for a database. It is currently set to restricted and I want it set to unrestricted. I make the change, click ok and no error appears but when I open it again the change is not there.

I also tried creating a new database and noticed that the autogrowth setting of unrestricted is not copied from the model db to the new one.

This happens only with the log file. I have SQL 2005 SP1. Any help is appreciated.

What recovery model are you using, Simple or Full?|||I'm using Full recovery mode.|||

Hi Heather,

The maximum size for a log file in 2005 is 2TB. I'm betting that although filesize is displaying as "restricted", the MAXSIZE is indeed 2TB (2,097,152MB). So, within the confines of capacity limitations, it is unlimited so to speak

Cheers,
Rob