Categories
- All Categories
- 4 Oracle Analytics Videos
- 13.7K Oracle Analytics Forums
- 5.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 56 Oracle Analytics News
- 31 Oracle Analytics Trainings
- 52 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
FUSION Custom BIP Report Output Displaying NULL as in Column , Instead of blank
Summary
FUSION Custom BIP Report Output Displaying NULL as in Column , Instead of blank
Content
Hello
We have to pass null values to few columns ,So in data model we are passing NULL as default and same is showing working when we check the data with in data model but we are seeing this as String in report output instead of blank
Templates .xpt and .rtf
But when I tested myTemplate through Microsoft word add then there its giving blank records in column and its not showing NULL as string.
Did any one too faces this issue ?
Documents uploaded
1) "WSI AR Franchisee Billing Invoices Report_WSI AR Franchisee Billing Invoices Report (3)" ,Output file generated from BIP
2) "Data model Output"
3) "Output generated Through Word ADD" , Output generated through Microsoft word addIn tool
Regards
Najeeb
Code Snippet
Data model column CONCAT(CONCAT('"',rcta.invoice_currency_code),'"') "Invoice-currency", NULL "CompanyAddr", NULL "WsiTaxId", Null "WsiCompAddr", Null "FraPartnerCompName", Null "FraPartnerCompAddr", Null "FraPartnerTaxid", CONCAT(CONCAT('"',rctla.interface_line_attribute14),'"') "CountryId"
Answers
-
Hi Gurus
Any pointer on this issue.
Regards
Najeeb
0