Geeks With Blogs
faizan ahmad Usually the things which were not a straight Google August 2009 Entries
Hide table column Dynamically in SQL Server Reporting Services (SSRS)
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... ......

Posted On Wednesday, August 19, 2009 4:10 PM

Format Date in SQL Server Reporting Services
compared to FormatDateTime Good old 'Format' function makes the job a lot easier : Format(Fields!ResultDate.Va... Format(Fields!ResultDate.Va... =IIF(Parameters!MonthlyOrYe... ......

Posted On Wednesday, August 19, 2009 4:02 PM

Add new column/field in Oracle DB table - ora - 30649: missing Directory
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 :) ......

Posted On Friday, August 7, 2009 11:21 AM

Copyright © faizanahmad | Powered by: GeeksWithBlogs.net