Crystal Report-Excel Subreport issue

[Former Member]

Hi,

I am using CR-2008.

I have a report with 2 sub reports, one of PDF and other for EXCEL.

In PDF i am getting the proper data but when i export it to EXCEL, i get a blank row in the data.

If i suppres the Page footer then EXCEL works fine but i need to display the page footer in PDF.

Is there any way by which i get can the page footer in PDF Subreport but not in Excel Subreport or some way by which i can eliminate the blank row coming in excel.

Thanks,

Tarun

[former_member205840]

Hi Tarun,

Create a static parameter with default values PDF, Excel.

When you refresh the report it will ask for this prompt.  If you say excel then based on this value you can suppress page footer.  So, it will get export without any issue.

Otherwise there is no crystal function which can really eliminate page footer when you export.

-Sastry

[Former Member]

Sastry,

I have done the same thing because of which i am getting an extra row in Excel which is a blank row. Is there any way to eliminate it.

[abhilash_kumar]

So you're saying you get a blank row in the exported excel sheet 'even after suppressing the Page Footer'?

-Abhilash

[Former Member]

No, i am getting the blank row if i don't suppres the Page footer, in Excel subreport.

[abhilash_kumar]

Have you tried using a conditional suppression formula for the Page Footer as Sastry's suggests?

-Abhilash

[former_member205840]

Hi

Can you copy and past the suppress condition which wrote.  There is a default behavior when you insert a sub report and export to excel, it inserts a blank line.

Thanks,

Sastry

[Former Member]

Layering condition is:

if {?@Layering} = "PDF" Then False Else True;