Blank Line

[Senseial]

Hello All

I have a view that feeds my report
This is waht it look like

F1 F2
-------------
AAAAA 1234
1236
BBBBB 3444
1212

I compress on F1 if it is dup so it look like that.

My problem now is how to have a space when F1 changes.

This is a view.

Thanks

 

[MColeman]

Do you have any groups in your report?

You could add another section that prints at the end of the
F1 section, that is conditionally suppressed based on F1.

whileprintingrecords;
if F1 <> previous F1 then true

 

[Senseial]

No I don't have any groups. Just one view.
I will try this. Still have a problem.
Thanks

 

[Turkbear]

Hi,
What is the code used to create the view?

 

[Senseial]

Ok here is just a small ex.

SELECT sm.SKU,
oh.order_number,
FROM OUTBOUND_HEADER oh,
SKU_MASTER sm,
WHERE sm.sku_master_id = oh.sku_master_id

I can't group by since they want to see each line just not the SKU (dups) since I am doing few calculations at the end. They only want to see blank line after SKU.
THanks

 

[lbass]

You could group on {table.F1}, but suppress the group header. The group footer would provide the space you're looking for. You can leave {table.F1} in the detail section as you have it now. This shouldn't affect any calculations.

-LB

 

[Senseial]

Thanks all.