well...thank you very much for all your reply...it is not straight forward decision for anyone to chose between these two position...

I have worked for one year at different organization and...

Thanks all for your reply. It seems Camstudio is the solution.

I have sorted this. The reason is the parameter name of the report and the field name of the table should be same. It works with the same name. I...

I have passed the report parameter into query before and it worked fine. In the set up window itself it shows that report takes following parameter: cons.....so report knows that...

I tried this.

declare @file as varchar(100)

set @file = '\\server01\wcl\Extracts\Executive\LOS-export' + convert(varchar, datepart(yyyy,getdate())) + '-' + right(('0' + convert(varchar, datepart(mm, getdate()))),2) + '-' + right(('0' + convert(varchar, datepart(dd, getdate()))),2) + '.csv'

print...

i have tried to write data into files and it allows to write data...bt dont run with read data....

It is not access by another process or used by other process. I took copy of the file and put it to different location with different names and tried but...

I tried but it didnt work. thanks for your help.

Please refer the following link.

http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/

regards,

vijay

Hi,

i am trying to use bulk insert first time. I need data from csv to sql table. it gives some error.

annot bulk load because the file "\\\wcl\Extracts\Executive\2008-12-19.csv" could not be...

U can write cursor (might not be the best solution) and concate the note_text into one big string separated by comma. It will have limitation of 8000 character though.

i had problem as u have like returning only first value of the multi value parameter. It is because when you write the parameter value it will select like parameter!value(0)...

thanks for sharing this guys...i was using TSQL and then using that into expression....

As much as i know u need to change the .css file for certain option to appear on your report viewer. But it will affect all of your report. u...

i dont know if other can understand your requirement but at least i dont understand what you trying to achieve?