nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Export to excel issue

sriram4133

Hi, I'm using iHub3. When I ran my report locally and tried to export content to XLSX, a single report column
is being exported to multiple excel columns.
I attached screenshots.
Please let me know if anyone had similar issue and the resolution for it.

Find more posts tagged with

Comments

micajblock

do you have merged cells in the design? What does the table in the design look like?

sriram4133

<blockquote class="ipsBlockquote" data-author="mblock" data-cid="142519" data-time="1456436463">
<div>
do you have merged cells in the design? What does the table in the design look like?
</div>
</blockquote>
 
I'm not able to attach a image again to show you the table and its properties. However, on one of the column expressions, I have a If statement like
if ( dataSetRow["X"] === null || dataSetRow["X"] === "" ) { dataSetRow["Y"] } else { dataSetRow["X"] }

micajblock

That should not matter. Can you try and reproduce using classic models sample database?

sriram4133

<blockquote class="ipsBlockquote" data-author="mblock" data-cid="142523" data-time="1456441919">
<div>
That should not matter. Can you try and reproduce using classic models sample database?
</div>
</blockquote>
I was able to reproduce with sample DB and have the design file with me but I'm not finding attach option to attach the file.
I see 'My Media' but not sure how to save my file in it.

micajblock

When you reply there should be a 'More Reply Options'. You should get a screen like attached.

sriram4133

I see attach file now. Thanks.
I attached rptdesign file.
Below is what I did:
1. Ran report locally
2. Export Content
3. Choose XLXS
4. Uncheck 'Output to multiple sheets' and click 'OK'
5. You will notice columns LASTNAME FIRSTNAME EMAIL REPORTSTO being exported to multiple excel columns.

micajblock

I do not see the attachment.

sriram4133

Sorry I didn't hit attach.

sriram4133

<blockquote class="ipsBlockquote" data-author="mblock" data-cid="142537" data-time="1456503722">
<div>
I do not see the attachment.
</div>
</blockquote>
I attached the file now. Sorry for the confusion.

micajblock

OK, thanks. The extra cells are due to the grid in the master page. If you remove the grid, you will not have extra cells.

sriram4133

Awesome. I removed the grid and it solved my issue. Thanks a lot Mica.
I'm new to BIRT world