Post reply

CSV Incorrect Data

  • May 7, 2012 at 7:19 am

    #255459

    Hi,

    I have a parameter(Integer) in my report which accepts multiple values. I want to display all the multiselected values seperated by a comma. When I open this report in BIDS,its showing the data correctly but when i export to CSV file the data is incorrect with respect to the parameter

    For Eg,

    If i select 100 200 300 400 500 600 700 values Only the CSV export is showing it as

    100,200,300,400,500,000,000. zeros are getting added after displaying some values.

    Please suggest how to overcome this problem.

    Thanks,

    Chandrika

  • May 8, 2012 at 9:58 pm

    #1484849

    Hi,

    Using Split function we can do it

  • May 9, 2012 at 12:39 am

    #1484891

    I have done it in the report. In the report its showing the data correctly. The problem is only when I am exporting to CSV file.

    Other Exports are working fine.

  • May 9, 2012 at 1:15 am

    #1484905

    Hi chandrika.r 91171 ..

    May be I understand ur requirement Clearly or not..!

    But as of i Understand i was suggests the Below shown solution.

    CREATE TABLE test_1 (NAME VARCHAR(20))

    INSERT test_1 VALUES ('100'),('200'),('300'),('400')

    SELECT * FROM test_1

    SELECT SUBSTRING((SELECT ',' + s.NAME FROM test_1 s ORDER BY s.NAME FOR XML PATH('')),2,200000) AS CSV

    GO

    In this way u can Get the solution the way u want...

    Pavan Kumar. Pala[font="Verdana"][/font]

Viewing 4 posts - 1 through 3 (of 3 total)

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