Eliminating spaces in report when hiding duplicates

[lemieux66c]

Hi guys,

I'm down to my final question in regards to my database. Right now I'm creating a report which simply enough lists all of the "topics" that have been entered in my annotation form. The reason why I want to create this report is because there is another report in which I input a certain "topic" and it outputs all of the annotations that I have done under that topic, and this report gives the user all the of the topic possibilities for the other report. There are probably much easier ways to do that, but I thought this would be simple enough for me to do.

My problem comes into being because a person will submit multiple annotations for a certain topic. The way the report is currently constructed, each time the topic is entered it is listed on the report since I'm searching my annotation table for the topic field. What I want to do is limit the report to listing the topic only one time. I was able to do this by setting "hide duplicates" to yes; however, where the duplicated entries were before, there is now a white space.

I was just wondering if there was a way to do this that would avoid my problem of having the white spaces.

Thanks everyone.

 

[pbaldy]

In your source query:

SELECT DISTINCT Topic FROM TableName

which will only bring each topic in once.

 

[boblarson]

To eliminate the white space for a report that has duplicates, you have to set the CAN SHRINK property of the details section AND the controls involved to "YES."

 

[lemieux66c]

To eliminate the white space for a report that has duplicates, you have to set the CAN SHRINK property of the details section AND the controls involved to "YES."

I forgot to mention in my original post that I tried this as I had read this tip somewhere on this forum on a previous post. It cut down the white space to 1/2 of what I needed, although I might not be changing all that I need to change. I'll try to fool around with it a bit more to see if I can get it to work.

 

[lemieux66c]

In your source query:

SELECT DISTINCT Topic FROM TableName

which will only bring each topic in once.

I think this might be a bit over my head. I didn't think I used any sort of query in the report that I was trying to generate.

 

[boblarson]

I forgot to mention in my original post that I tried this as I had read this tip somewhere on this forum on a previous post. It cut down the white space to 1/2 of what I needed, although I might not be changing all that I need to change. I'll try to fool around with it a bit more to see if I can get it to work.

If you have any labels on the same row as the controls you want to shrink, that will also cause it to not shrink.

 

[pbaldy]

I didn't think I used any sort of query in the report that I was trying to generate.

You should, as IMHO it would be better to eliminate the duplicates to begin with rather than hide them after the fact.