I have a header that will not suppress conditionally

[Former Member]

I have a header that will not suppress conditionally. The report consist of 2 reports a main report and a subreport. The main report will not show context if the subreport has information for that user. I got that to work but the main reports header is still appearing. I used the suppress if blank with a formula with out success. How can I do this?

[Former Member]

Which header are you talking about? Report Header, page header, or group header??

[Former Member]

I having problems with the Page Header not suppressing. I tried to find my way around the problem by moving all the information that is in the Page Header to the Detail section it would display the information conditionally but it still gives me blank pages even if I do "Suppress Blank Section" with or without a formula.

[abhilash_kumar]

Hi,

Are you trying to conditionally suppress the section that holds the subreport?

Do you want to suppress the section when the subreport returns no records?

If yes, then right click the subreport > Format Subreport > Subreport tab and check 'Suppress Blank Subreport'

And then, right click the section on the main report and use Suppress Blank Section

-Abhilash

[Former Member]

No I am not trying to conditionally suppress the section that holds the subreport. It is the header in the main report.

I was successful in suppressing the main section/body if the subreport returns has records but the header still displays (main report has user and patients info) Subreport(patient appointment) is there is a patient appointment I do not want to show the user's active on the patient in the main report [that works]

However, because the report is group by patient the header for each patient is still displaying in the main report. I tried to suppress the header with Suppress Blank Section [if the main report's body is blank] but that did not work. How can I suppress the header if the main report is blank{which is when I have informationfor that patient in the subreport}

[Former Member]

Hi ,

I think it is better not to use Page Header and Report Header. You could use Group Header instead.

If needed group headers could be suppressed as you wish.

Regards

Vivek

[Former Member]

Hi

Drag and drop any field which returns data in your main report to page header. Go in section expart and check if that field does not contains data then suppres the section else show the section.

Example if your Main report contains Patient id place this on your main report page header and based on the value of this field suppress the section.

Thanks,

Sastry

[Former Member]

I moved all the header information to the Group section and tried the suppress if blank. That did not work so I just moved the header information to the detail section to get it to suppress with the rest main report that works but is not an ideal solution. Is there anything else I can try?

Thanks,

Suzette

Edited by: Trinisunset on Aug 22, 2011 8:41 PM

[Former Member]

I moved the fields into the group section and tried to do the conditional suppress without any luck.

[Former Member]

I have done this before to isolate. Take the formula you are using for suppresion, copy it, create a new formula and paste into it.

something like if = condition then true else false

Now unsupress everything in the report and add the formula to all your sections, groups, etc.

You should then be able to see True, or false, in each of your sections, by reviewing this, you can verify that your conditional formula is actually doing what you think it should be. If it is not, you may want to reverse the logic in the formula, or adjust it untill it meets your criteria.

You can also refer to the new formula to supress a section, or group.

Supression occurs when the formula, or condition returns a true.