Home > IT Answers > SQL Server > Supression by date and field data
KMarie
15 pts.
 Supression by date and field data
SQL 2005, SQL 2005 Database
I am trying to suppress a text field within a section by both field parameters being null and also by specific time frame. The formulas work independently just fine, but not when placed together. (isnull({DBA.POST})= false or isnull ({DBA.ANNUAL}) = false) and {DBA_DATE.Report_DATE} < DateTime (2012,11,04,00,00,00)

Software/Hardware used:
CRW developer 11.0 - SQL Server
ASKED: November 15, 2012  3:44 PM
UPDATED: November 15, 2012  4:44 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question. Michael Tidmarsh   11,405 pts. , KMarie   15 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

I think you want isnull or isnull OR date

BigKat
 7,185 pts.
 

I need this text box to suppres if the date < than certain date.  only show starting from specific date forward.  but also after it meets the date requirements, if either of these other two fields within the database are not null, I need it to suppress this text box.  :-)

KMarie
 15 pts.