Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rbohaty
Yak Posting Veteran
71 Posts |
 Posted - 2005-10-06 : 09:28:37
|
| I would like to create a report based on a query that uses a date field as the trigger for the query (if date is not null). The record also has 14 columns (field1, field2, field3, etc) whose values are either 'missing' (the actual text missing) or null. What I want to do is only display the fields for the record if they contain the word missing. So a sample might look like:IDDatefield1 - Missingfield3 - Missingfield7 - missingIDDatefield3 - missingIDDatefield8 - missingfield11 - missingfield14 - missingThanx.... |
|
|
|
|
|
Dynamic report