Post reply

Displaying 0s instead of blank field while exporting to Excel

  • February 22, 2010 at 8:34 am

    #220868

    Hi,

    I have ssrs 2008 report developed in which some of the fields are blank (while running in BIDS) but when I export the same report to Excel 2007 then it is displaying "zeroes" instead of blank fields.

    Ideally, I want it to be blank only in Excel also. Does anyone have any idea what corrections do I need?

    Thanks,

  • February 22, 2010 at 10:03 pm

    #1123413

    Few questions:

    Is the data set returing NULLs? Is there logic for the fields in the report after the data set is returned? The fields that are blank what data type are they?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply