Suppress duplicates?!

It's been a long while since I'm here and I've become a bit 'rusty'.

Correct me if I'm wrong. It seems that it's not possible to suppress duplicate labels.

I have a table with sales orders and within that table, I have another table with remarks pertaining to a particular order.
My report will look something like this.. and if there are no remarks, I will hide the remarks table.

Sales Order 12345
1) Clothes
Remarks -- remarks1
(spaceHere)remarks2
2) PCs
3) TVs

remarks1 is from the field rmks in a row in the rmks_table and remarks2 is another row.
I put in the label (Remarks --) and rmks field in the detail section.
But it come out like this

Sales Order 12345
1) Clothes
Remarks -- remarks1
Remarks -- remarks2

2) PCs
3) TVs

I tried to put the label outside the remarks table but to no avail. I'm not able to hide it if rmks_table contains no data.

Any help?
Thanks

Find more posts tagged with

Comments

mwilliams

Hi BIRTz,

I don't believe you can suppress duplicate labels the way your table is set up. Do you have grouping on your table where you could increment and reset a variable inside each group to use the visibility feature to hide the label?

BIRTz

Hi Michael,

Thanks for your reply.
No, I don't have any grouping on my table.
But I sort of thought of something by 'cheating'.
Instead of using label, I used data to put "Remarks --" and it worked.
That will be my temporary solution because I have another issue now.

Let's say remarks2 is so long that it is displayed on, say 5 lines. The first 3 lines are at the bottom of the page and the last 2 are at the beginning of the next page.
I would like to have 'Remarks --' to be on the next page so that if I look at the 2nd page, I will know that it is part of the Remarks field.

mwilliams

BIRTz,

Can you build a report similar to the one you have set up with the sample database or using a flat file dataSource or something that I can run? This way I can test some things to see if they'll work for your issue.

BIRTz

Hi Michael,

This is a roughly similar report that I came up with.
At the top of the 2nd page, I would like 'PRODUCTDESCRIPTION' to appear on the first line next to 'detailed interior, working steering system, and a bifold'

mwilliams

BIRTz,

Well, I tried a couple things, and I don't think we'll be able to get that value to repeat on the next page in that situation. I could be wrong, but I don't see a way. The best solution would be if you could upgrade to 2.5, it makes sure that the "comments" would not get split up in this way, therefore, you wouldn't need to repeat the "header".

BIRTz

Hi Michael,

Thank you for your time in looking into this.

At the moment, I'm not too sure about the upgrade yet.