Integer Data Type Showing Intermittently in Report Created with BIP Layout Editor 11.1.1.6.2
I’m sure I’m missing something simple here, but I just can’t figure it out. I’ve created a SQL Query Data Set in my Data Model in BI Publisher 11.1.1.6.2. I then generate the sample XML data (save to data model) and create the report layout using the BIP layout editor. The sample data appears complete in the layout editor (shows preview as you build the table layout).
I then view the report and the only dollar amounts that appear on the report are amounts that do not have decimals. I’ve set the format on the amount field to include decimals but the amounts will not appear.