Hey everyone.



I need some help.

Question 1: I have a Main Report with a sub-report. Everything is ok but one thing. I only want to show the Sub-Report if there is data in the fields of that Sub-Report.

I saw a solution in another website, where the idea was to convert the labels in that sub-report to textbox fields. And then set Can Shrink=No and Can Grow=Yes. The thing is that when there is no data the sub-reports isn't shown but when there is the "labels" are shown with #Error. Is there a solution to fix this or there is another easier solution?

Question 2: In the Main Report, I want to repeat the Report Header on all pages. How can I do this? There isn't a Repeat Section on the Report Header :s

Question 3: The complete report it isn't centered in the same place on all pages. Example: On Page 1 it's a bit higher, on Page 2 a bit lower...and so on...Not much of big deal but strangely it's doing this.

If someone could help me I would be much apprecciated. Sorry for bad english. Thanks in advance.