August 2009 Entries
Quite Straight forward: Select the Column , Right Click -> Propoerties OR hit F4 Visibility -> Hidden -> Expression i.e. Click on Hidden under Visibility and select Expression from Drop Down Write the expression e,g. =IIF(Parameters!MonthlyOrYe... ......
compared to FormatDateTime Good old 'Format' function makes the job a lot easier : Format(Fields!ResultDate.Va... Format(Fields!ResultDate.Va... =IIF(Parameters!MonthlyOrYe... ......
I was trying to add a new field in an Oracle DB table using this script: alter table TABLENAME add FIELDNAME char(1) not null default '0' ; it was throwing an error: 'ORA-30649:missing directory keyword' it drove me nutts for a while and after some googling, I was able to figure it out, its the Order: 'not null' should come after default value. right script is: alter table TABLENAME add FIELDNAME char(1) default '0' not null; order does matter :) ......