NULL value with odbc data source (excel file)

  • Hi,

    i created a report that uses an excel file as data source (ODBC Driver).

    The problem is that some value are returned as null even if they are not null in the excel origin.

    I'm quite sure this is due to the column values : some of them are treated as number, some others as text and this confusion bring the nulls. The excel file is originated by an export procedure on which i have no control, and there are about 2k rows in it (so i can't edit values to force them as number).

    How could i olve this?

    Another question : if i decide to deploy the report to a remote server i should deploy the excel files (data source) on that server in the same path as i use them on the development server, right?

    thanks.

  • Hi,

    The values in SSRS are only returned as NULL if source field is null or is empty....

    In either case you can use the derived column data flow task to manipluate the NULL field to suit your application needs...i.e. in derived column task use the ISNULL inbuilt function

    Raunak J

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

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