I am not sure a view is the answer. I need to show all records but there is no consistency to the empty fields within them.
Nocton wrote:I am not sure a view is the answer. I need to show all records but there is no consistency to the empty fields within them.
You just need to make a Query, select the fields you want in your report, and then set the Criterion for the fields that may be empty/null as 'IS NOT EMPTY'. If it is a fairly simple query then the report can read it directly without the need to create a View from the Query. You could also use a Conditional Print Expression in the report, but I think that is a more complicated option.
then the query leaves those records out entirely, so out of say 100 records I may only get 10...
NOT(ISBLANK([FieldName])
NOT(ISBLANK([Three]))
Nocton wrote:A Solution!
The Conditional Print does work as expected for Headers and Footers. So if you make a group you can do what you want. In the attached example I have made Field 'Three' into a group and put the field in the Footer, with the Conditional Print Expression as
- Code: Select all Expand viewCollapse view
NOT(ISBLANK([Three]))
All then works as you want. Of course, if you have several fields that may be blank you will need to set up several groups - a bit tedious, but does what you want.
Users browsing this forum: No registered users and 1 guest