getting a 1 in cell A1 when exporting to excel from report studio 11.06

[JBCLARK20]

Hi All,

Just finished developing a report and all the numbers look right and it goes out to excel nicely and for some reason there is a row on top of the report with a 1 on it.
Not sure if it is an automatic page number or what.
The report does not have headers. It is just a list.

The 1 on the excel out put is in the first row and the cells are merged across the entire row
below it there are 2 title lines with singletons
and the list is below

I'm thinking this may be a default page number?
Is there a property that can be set to remove the 1?

Thank you,
Jim

[MFGF]

Hi All,

Just finished developing a report and all the numbers look right and it goes out to excel nicely and for some reason there is a row on top of the report with a 1 on it.
Not sure if it is an automatic page number or what.
The report does not have headers. It is just a list.

The 1 on the excel out put is in the first row and the cells are merged across the entire row
below it there are 2 title lines with singletons
and the list is below

I'm thinking this may be a default page number?
Is there a property that can be set to remove the 1?

Thank you,
Jim

Hi,

There's only a page number if it exists in the layout of the report - ie there is no automatic numbering per se. I'd be looking closely in the Structure View of your report to see what precedes the list in the report structure. You might find you have an unnoticed page header, perhaps?

MF.

[Kiran P]

There shouldn't be any default behavior like this. Pls go to Page Structure view and see if there are any hidden elements.

Thanks
Kiran

Sent from my ZUK Z2132 using Tapatalk

[JBCLARK20]

Thanks for the feed back.
Cleaning up the report in page structure worked.

[Aish]

hi All,

I am facing the same issue and couldn't find any extra rows apart from Page header (with logo and Report tile) in the Page structure
If I add a table in the page Header, it shows '1' in the first row of Excel output

It's not showing up when I add a layout component reference to display the logo, but I can't use it as the structure of page header is different for this report
It's in 11.0.6. Please suggest

[MFGF]

hi All,

I am facing the same issue and couldn't find any extra rows apart from Page header (with logo and Report tile) in the Page structure
If I add a table in the page Header, it shows '1' in the first row of Excel output

It's not showing up when I add a layout component reference to display the logo, but I can't use it as the structure of page header is different for this report
It's in 11.0.6. Please suggest

Hi,

Is this just when you test-run the report from within the Authoring environment, or do you get the same issue when running the report directly from the portal?

MF.

[pdeprado]

Thanks MFGF!

That was exactly what I needed.  If I run to Excel from the Report list the "1" no longer appears on my A1 cell.
It only appears when running from the edit mode's run report button.