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; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

BIPUblisher (11.1.1) removes extra spaces, I need the extra spaces...

Carlos Diazzamora

Summary

BIPUblisher (11.1.1) removes extra spaces, I need the extra spaces...

Content

Hello, we have this report that runs a store procedure that returns one single column with extra spaces in between in order to make it fixed size but the BIPublisher removes all the extra spaces. Is there a way correct this behavior?

Examples

Data in SQL developer:

ELEMTN1 ELEMENT 2

ELEMT2 ELEMENT 2

ELEM3 ELEMENT 2

Reading that table in BIpublisher:

ELEMTN1 ELEMENT 2

ELEMT2 ELEMENT 2

ELEM3 ELEMENT 2

Thanks,

Find more posts tagged with

Accepted answers

All comments

Thomas Dodds

What template are you using? RTF, Excel, Interactive?

Sherry George

Try putting the element inside a table.

Gladys Calvozamora

Thanks Sherry George, it did worked. I had my RTF template wrong before.

Gladys Calvozamora

I'm using a BIP layout.

But the issue started in the data model. I create a new data model with a simple SQL Query: Select 'hello world' from dual

In the data model, when I go to the View tab, and try to see the resulting data, BIP has already delete the blank spaces.

Thanks,

Gladys

Sherry George

Did you try what I suggested? I was able to see the spaces in my test.

RTF output

Sherry George

What is your template type? try using an rtf template and see if it resolves the issue.

Gladys Calvozamora

Sherry George, I have this same issue.

Everything starts in the data model. I'm using a SQL Query, is very simple. Then the column type is String and it automatically deletes the blank spaces.

For example:

In the SQL Query I put: Select 'hello world' from dual

When I see the data it looks like this: 'hello world'

What I need is that BIP do not delete the blank spaces.

If you have any suggestions, I will really appreciate it.

Thanks,

Gladys