How to suppress a field if it is null
in [Reports]
|
Prev: Reporting services Provider load failure (System.management)
Next: Using Reporting Services 2000 with Visual Studios 2005
From: GORAMS on 25 Jan 2006 08:02 I have a report where it displays demographic information. The Address2 field is sometimes NULL and I haven't found a way to suppress this field. The only thing I can do is make it invisible/visible with an IIF statement. I know in Crystal Reports you could check a box that said "SUPPRESS IF BLANK" and this would move all the other fields up on the report accordingly. With SQL Reporting services it doesn't adjust the fields underneath it so I have a blank/empty space. Does anyone know of any other things I can try. Thanks
From: MattA on 25 Jan 2006 09:15 Hi GORAMS, Are you using a table control? If so, take a look at the actual detail line for Address2, and make sure that your IIF statement to control visibility is set on the entire tablerow as opposed to just the Address2 textbox. Just setting the visibility property on the Address2 textbox would cause your problem if the table has more than column. Does this help? Matt A Rpeorting Services Newsletter at www.reportarchitex.com
From: Stjepan Puljko on 25 Jan 2006 09:54
RS is shrinking fields if you specify that it is invisible (for example if you put in Hidden property "=Fields!Something.Value is Nothing"). But, as in CR, that depends of other fields in line, so if one is supperesed and other one is not, it will not move fields under supperesed one up... You can play arround little with columns maybe, or lists if you want to do something like that.. Stjepan "GORAMS" <GORAMS(a)discussions.microsoft.com> wrote in message news:A28602C1-D97C-4A19-9ABD-6A06D6A4A9BA(a)microsoft.com... >I have a report where it displays demographic information. The Address2 >field > is sometimes NULL and I haven't found a way to suppress this field. The > only > thing I can do is make it invisible/visible with an IIF statement. I know > in > Crystal Reports you could check a box that said "SUPPRESS IF BLANK" and > this > would move all the other fields up on the report accordingly. With SQL > Reporting services it doesn't adjust the fields underneath it so I have a > blank/empty space. Does anyone know of any other things I can try. > > Thanks |