Hide Blak Rows

[Joanna_gr]

Hi again! That should be simple and but I can't find out what is wrong. I'm trying to create a labels report. Only some fields are blank and and I want to hide the blank rows from the report when printing. I used a trick : I set the field hight at 0 and "can grow" to yes and worked fine. For some reason I had to change the source to another query and after that it stoped working and I see again blank rows. Can anyone propose me something ?

 

[Andrew Fergus]

Have you tried excluding the blank rows in your query?
Andrew

 

[Joanna_gr]

i'm not quite sure what you mean. I tried "not is null" to fields that supposed to have blanks but this excludes all record, instead of hide row "title" for example.

 

[Andrew Fergus]

Can you post an example of the data you are working with (where you want to show or not show a record)? Can you also post the SQL for the query? You can get to the SQL under View -> SQL view.
Andrew

 

[Joanna_gr]

This is the sql code: SELECT [maintable query].[Xmas Card], [maintable query].COMID, [maintable query].PRFXA_GR, [maintable query].PRFXF_GR, [maintable query].COMP_GR, [maintable query].L_NAME_GR, [maintable query].F_NAME_GR, [maintable query].TITLE_GR, [maintable query].ADDR_GR, [maintable query].FLR_GR, [maintable query].CITY_GR, [maintable query].COUNTRY, [maintable query].POSTCOD
FROM [maintable query]
ORDER BY [maintable query].COMP_GR;

I'll try to explain what I want to do. I'm trying to creat postal labels. In some cases field title is emply. If this happens I want the next field to shown exactly after the previous and not show a blank row in the place of "title"

 

[Andrew Fergus]

By 'title' do you mean '[maintable query].TITLE_GR'? If so, try putting 'Is Not Null' into the criteria of just this one field. Does that return what you want?
HTH, Andrew
Late edit : use Is Not Null without the little speech marks.

 

[Joanna_gr]

I believe that this is more complicated than this. I have found a code where I'm asked to choose the fields of a main query add criteria and create the report.

The report source is the query with the following sql code: SELECT qselLabels_English.COMID, qselLabels_English.COMP_EN, qselLabels_English.COUNTRY, qselLabels_English.F_NAME_EN, qselLabels_English.FLR_EN, qselLabels_English.L_NAME_EN, *
FROM qselLabels_English
WHERE (((qselLabels_English.COMP_EN)="ALPHA BANK"));

Does this helps you or makes the things worse??

 

[Andrew Fergus]

Now I'm confused. Ok, ignoring the underlying query (or queries) for the moment, have you tried using the filter on the report instead? In your report design, click Edit -> Select Report, View -> Properties -> Data -> Filter : [your field name on the report] Is Not Null, Filter On : Yes. Where I have put [your field name on the report] use your actual field name (title perhaps?) inside the square brackets that you wish to test. Does this give you what you want?
Andrew

 

[Joanna_gr]

I put this: [TITLE_GR] Is Not Null. Is that correct? Unfortunately I had no luck.

 

[Andrew Fergus]

Yes that is correct. Did you change the property below that titled "Filter On" to 'Yes'?