in reporting services i hve the below expressionFieldspnameValue 34 34 IIfcdateFieldsdtfrmValue3401011900343434cdateFieldsdtfrmValue 34 to 34cdateFieldsdttoValue wht i need is displaying value of pname and then in the next line displaying date if the date is not 19000101

SQL Server Reporting Services: Date Field expression

svibuk

SOLVED CLOSED ACTIVE ANSWERED
User: svibuk
Posted: on Oct 01, 2012 09:16 AM
Forum: SQL Server Reporting Services
Answer: 1
Views: 7314

in reporting services i hve the below expression

=Fields!pname.Value+ "                           " +IIf(cdate(Fields!dtfrm.Value)="01-01-1900","",cdate(Fields!dtfrm.Value)+ " to "+cdate(Fields!dtto.Value) )

wht i need is displaying value of pname and then in the next line displaying date if the date is not 1900-01-01

Mudassar

0 1

Reply
ANSWER
User: Mudassar
Replied: on Oct 02, 2012 12:47 AM
Report

Read here

http://notethat.blogspot.in/2007/10/reporting-services-tips-tricks-and.html

SQL Server Reporting Services: Date Field expression

Company

Explore

Follow us

Contact Us