How to generate report in Text format (NOT CSV)

Does anybody know? how to create a report in text format or any other custom format from Reporting Services?????I couldn't find any way doing this!!!!Please respond.thanks,-RP

Hi, RP.

I have an idea to solve your problem.
You can first make report with RAQ Report, and then export the report to text format, or any else format you need. RAQ Report can export report to Word, PDF, Excel, Html,XML format.
You can get the free reporting tool at http://www.raqsoft.com/.

I wish this can help. Good luck.

Nope, It will not help, not going to use any custom tool as long as possible. If I won't be able to generate using SSRS then, other developer is ready to go with V.Foxpro. So this option will not help me. thanks for your reply any way...-RP

Not easy, but not impossible.
Declare @file INT, @fs INT, @ole INT, @pdf VARCHAR(100), @trenutniRed NVARCHAR(200),

SELECT @pdf = 'C:' + @filename + '.pdf'

EXECUTE @ole = sp_OACreate 'Scripting.FileSystemObject', @fs OUT

EXECUTE @ole = sp_OAMethod @fs, 'OpenTextFile', @file OUT, @pdf, 8, 1

DECLARE SysKursor INSENSITIVE SCROLL CURSOR
FOR SELECT code FROM #temp ORDER BY idnumber -- the rows you want to write out to the text file
FOR READ ONLY
OPEN SysKursor
FETCH NEXT FROM SysKursor INTO @trenutniRed
WHILE @@Fetch_Status = 0
BEGIN
EXECUTE @ole = sp_OAMethod @file, 'WriteLine', Null, @trenutniRed
FETCH NEXT FROM SysKursor INTO @trenutniRed
END
CLOSE SysKursor
DEALLOCATE SysKursor
EXECUTE @ole = sp_OADestroy @file
EXECUTE @ole = sp_OADestroy @fs

Please note, the above code contains all bad practices I can thinkl of! [:O]
Dave