Min value seperated from dataset

• Raj Deep Alapati

  Ten Centuries

  Points: 1118

  More actions

  May 17, 2006 at 6:02 am

  #172568

  Hi all

  I do have Dataset which follows graph related to that dataset.

  In that dataset. there is a column date which contain null values also.what i need is to display message seperately in the graph saying the "the earliest application is 09/03/2005"

  As this message Date is minimum date of the column date(which i have to take care of minimum values).i mean i want to display the least date but not null.i placed a textbox and given the value as

  Min(Fields!date.value) which is showing null and when i give

  max(Fields!date.value) it is showing the correct maximum date

  =Min(Reportitems!Date.value) as i tried this also.No Use

  I want this to be printed apart from the Dataset which is showing all values of dates.

  any suggestions would be appreciated

  Thank you

  Raj Deep.A

• Jason Selburg

  SSC-Insane

  Points: 24641

  More actions

  May 17, 2006 at 4:31 pm

  #638602

  In your query convert the nulls to a date that you won't hit...

  I.E.

  select

  field1,

  field2,

  IsNull( Date, '12/31/2999' ) as Date

  from

  your_table_name

  if that will not work, I'm sure there is an equivilant to IsNull in the RS designer, I just don't know it.

  ______________________________________________________________________

  Personal Motto: Why push the envelope when you can just open it?

  If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

  Jason L. Selburg