June 24, 2008 at 9:28 am
This report is running from a stored procedure. Problem is (I guess)
If the first field in particular column is Blank or Null, it does not display any value for the column.
When I run stored procedure in Query Analyzer, everything is looking fine. But in report, if first filed of any column is blank or null, that column is blank for all records.
What am I doing wrong?
June 25, 2008 at 4:12 am
I am guessing here that you have somehow added your fields into the table at a group level, and if so, perhaps what you are printing is First(Fields!Column.Value).
If this is the case then probably you should remove the First() part of the expression, however, this is a very generalised guess on the information you've provided. If the above doesn't help then perhaps you could give some more info, sample data, how the report is formatted (table, text boxes, list box).
Nigel West
UK
June 25, 2008 at 7:08 am
Yep...
Nigel may be right.
But if you are not using the First(Fields!Name.Value) Then probably you can handle the NULL value in your stored procedure like ISNULL(FieldName,'')
June 25, 2008 at 7:41 am
I am not using FIRST() in any of the fields. I am displaying records in Table, which has only three rows.
1) Header (Contains Headings)
2) Detail (Contains Fields!Column.Value
3) Footer (nothing in it)
Thanks
June 25, 2008 at 7:43 am
Hi,
Then you need to alter your Stored Procedure.
probably you can handle the NULL value in your stored procedure like:
ISNULL(FieldName,'') AS FieldName
or
ISNULL(FieldName,0) AS FieldName
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply