Post reply

Export report to Execel

  • August 6, 2010 at 2:49 pm

    #236313

    Hi to all

    I have report it show Yes/No for fileds Mail list and Email list

    When I export the report to Excel, the Mail List and Email List fields display "Y1900s" instead of "Yes".

    What can I do?

    Please help

    Thanks in advance

  • August 6, 2010 at 2:59 pm

    #1203799

    Check the field type of these columns in excel and change to text type and try again .

    HTH ...

  • August 6, 2010 at 3:06 pm

    #1203801

    I can' t do that report created in SSRS and I am exporting from there

  • August 6, 2010 at 3:19 pm

    #1203803

    Can you check in excel i think the column in Excel was formatted as date. For boolean, Yes or True is 1 and No or False is 0. My guess is to alter your expression in RS that showing this Yes or No value to be like:

    =iif(Fields!YourBooleanField.Value, "Yes", "No")

    HTH....

  • August 7, 2010 at 5:49 am

    #1203851

    THANKS I try

  • August 9, 2010 at 9:00 am

    #1204218

    thank you for your help it is working

Viewing 6 posts - 1 through 5 (of 5 total)

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