Removing '?' or null value from the WebReport/LiveReport

Hi,

I have gone through the below link to remove the "?" from the report,

https://knowledge.opentext.com/knowledge/cs.dll/fetch/2001/744073/6848762/19905386/Removing_Question_Marks_from_Reported_Null_Data_in_LiveReports.pdf?nodeid=10980720&vernum=2

Adding the NVL(Column, ' ') insert a blank space or any other value which is placed between the inverted commas. But the issue here is instead of null value now we will get the blank space into that field. Now what we need is,

We don't need null or "?" in the report output.
We also don't need the Blank space in the report output which can be achieved by NVL Command.
We just need the empty field having no value. Blank space also has ASCI value while the empty space does not.

Can anyone please help and let me know if this is something achievable?

Thanks,
Nikhil Sanghvi

Find more posts tagged with

Comments

Jim Hewitt

Hello,

Looking at what you are replacing it seems that there is a space between your single quotes. If you take this out does it still cause you issues?

NVL(Column, '')

nikhil.sanghvi

Hi Jim,

Even if I remove the blank space between the single quotes, I am still getting the "?" mark in the output. I believe this is a bug which wil get fixed with the patch?

Thanks,

Colin_Schmidt

It's not a bug. If you were to copy-n-paste the report into Excel, the "?" would not show.

Colin J.

On Thu, Jan 14, 2016 at 2:11 AM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

Removing '?' or null value from the WebReport/LiveReport Posted bySanghvi, Nikhil DOn 01/14/2016 02:09 AM

Hi Jim,Even if I remove the blank space between the single quotes, I am still getting the "?" mark in the output. I believe this is a bug which wil get fixed with the patch?Thanks,
[To post a comment, use the normal reply function]
Topic: Removing '?' or null value from the WebReport/LiveReport
Forum: Content Server LiveReports Forum
Content Server: Knowledge Center

This electronic message contains information from WestRockCompany (www.westrock.com) or itssubsidiaries, which may be confidential, privileged or otherwise protected fromdisclosure. The information is intended to be disclosed to and used by only thenamed recipient(s). If you are not the intendedrecipient, then your review, use, disclosure, printing, copying, ordistribution of this message or its contents is prohibited. If you havereceived this message in error, please notify WestRock immediately at postmaster@westrock.com, and delete themessage from your system. Unless previously authorized in writing, thismessage does not constitute an offer, acceptance, or agreement of any kind.Sender is not liable for damage, errors or omissions related to or caused bytransmission of this message. © WestRock Company.

nikhil.sanghvi

Hi,

I have WebReport having source as this Livereport. WebReport has the destination set to Excel sheeet. Now when I am running the webreport, the excel does contains the "?" mark in the excel sheet.

I have the SQL command for the column as NVL(Columnname, '').

So it is not working for me.

Thanks

nikhil.sanghvi

Hi All,

I have found the workaround and wanted to paste here, so if anyone has this issue can look over this workaround,

We also have WebReport, so in the webreport I have used Replace command to replace blank space with the Null value. And now when we run the webreport, the results are showing up empty in the excel sheet whcih is been exported.

That is strange that null value represent as "?" mark in LR while it shows as empty space in the WR. Maybe both the component has its own way. But it did fixed my issue using the WR.

THanks,
Nikhil Sanghvi

Greg_Griffiths

Nikhil,

I would be wary of your approach as if the user does enter a ? as a value then you will lose it, I suspect what you should be using is the DEF SubTag to apply a default value e.g. :

[LL_REPTAG_&Title DEF:"No Title" /]