reporting services - SSRS ignore a field result -
i guys
i'm having slight problem report im writing.
so when run report gives me list of outcomes data source. 1 of results 'closed' want exclude outcome in report. cant exclude in sql code doesn't bring null values. ( when no outcome has been given task yet i.e no 1 has had time yet have set in expression 'no outcome'.)
so want know if can edit expression not bring value of 'closed'
=iif(isnothing(fields!outcomedescription.value),"no outcome",fields!outcomedescription.value)
any on great sorry if iv not explained well. rusty
to this, you'll want add filter either dataset or table object - whichever appropriate needs.
for dataset filter, merely open dataset properties, , filters tab. table, you'll need go tablix properties. setting filter there simple.
filtering @ dataset level drop of filtered records before controls on report access them. filtering @ object level drop filtered records control, still available other controls. if report consists of single table, , no additional objects, i'd recommend filtering on dataset.
Comments
Post a Comment