Creating a report with null's not showing

**brobb56** · 09-23-2011, 02:55 PM

The text box properties for the query or the report?

**brobb56** · 09-23-2011, 03:06 PM

What I need is Mary Jones and report ID to show for every year and form displayed. I did the shrink on all texts and it does not show all info. I am excited that you got me this close. you are great

**brobb56** · 09-26-2011, 12:19 PM

I tried shrinking the text boxes but because I have borrower and report id in the next line they show even if there is no data in year2 or year3. Is there an expression I can use? A different setup on the report? Here is my DB.

**pbaldy** · 09-26-2011, 12:54 PM

This type of thing would work, but you may not like the formatting:

=[Borrower]+" "+[Report ID]+" "+[Form Type1]+" "+[years requested 1]

**brobb56** · 09-26-2011, 12:57 PM

where would I put this to try it

**pbaldy** · 09-26-2011, 01:11 PM

The control source of the first of four textboxes. The others would return the other years.

**brobb56** · 09-26-2011, 01:15 PM

I tried pasting into control source but I got an error in the view

**pbaldy** · 09-26-2011, 01:19 PM

Double check the field names, and make sure no textbox has the same name as one of the fields. Works like the attached.

**brobb56** · 09-26-2011, 01:28 PM

We are really close. The only thing is the report ID still shows

**brobb56** · 09-26-2011, 01:41 PM

When I try it, the formatting stays the same as original but the report ID still shows in empty lines

**pbaldy** · 09-26-2011, 02:16 PM

You would have deleted all the other textboxes, and just have these 4 in the detail section.

**brobb56** · 09-26-2011, 02:17 PM

Oh I see, then yes the formatting is an issue. This is a report that has to be sent to IRS, they are specific in the way the form looks or it will not be accepted. Any ideas

**brobb56** · 09-26-2011, 02:39 PM

So it is said that that I am doing things the hard way. Knowing what I want, what would be the best way to get these results. Would I need to start from scratch

**pbaldy** · 09-26-2011, 03:12 PM

I would, but as I mentioned on your other thread the UNION query is a way to normalize the data which will make it easier to deal with, and will make this report simple, since Null records won't be in the data.

**brobb56** · 09-26-2011, 03:14 PM

This is exciting, how do i do a union as you saw all data that is in question is on the same table.

Creating a report with null's not showing

Thread Tools

Shrinked

Similar Threads

Report Showing ID number and not the name

Report not showing all records

Not showing records with null sum

Showing OpenArgs in a Report.

Null Values not showing up in a Query

Posting Permissions