Data blobs are used to return data to a report in a "blob" of raw data.  Data blobs do not define data types or output formats. In order to properly output the blob data in the desired format on the Excel sheet, we need to define the column properties in the Data View Manager.


Our template defines 7 columns of data:


The data contains a mix of string and numbers with different formats and justification. Since the data blob does not define column properties, we need to define them in the Data View Manager for the blob file TMP.  Data View TMP.VIEW defines the 7 columns data types and format.  The column width is ignored because it's defined nby the template.


In the Report Builder we select the 7 columns and order them as defined by the template 



When the data in the blob is applied to the template, it will be formated using the definitions in the Data View.