Display first non NULL value from my dataset?

Hello,

I would like to display the first non null value from my dataset, is this possible? I am aware of first() and last() but what are my options for displaying the aforementioned? Thanks much!

John

I'm not sure if you want to exclude the row completely or for a particular textbox just get the first non-Null value, but you may want to look into using dataset or data region filtering. With filtering you can filter the dataset to remove any rows with the Null value, and then use the First Aggregate function.

Ian|||Thanks for the reply, I am trying to get the first non-null value from a field in my dataset and place it in a textbox. I am aware of the filtering techniques, however, the entire dataset is required for a graph I have above the textbox that I would like to put that value in--I'm gona keep digging, perhaps I need to write my own function for this?|||What you may be able to do is create a Matrix that has a Data Region level filter, which filters out the unneeded rows. The Matrix should contain just a data cell, with no added Rows or Columns. (In the Report Designer, it should contain a default dynamic row and column with groups containing no group expressions and empty textboxes.) And the data cell is the textbox with the expression using the First Aggregate function.

Ian