May 7, 2012 at 7:19 am
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
Hi,
Using Split function we can do it
May 9, 2012 at 12:39 am
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
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...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply