SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Text file as datasource to SSRS
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Vadivu
Starting Member

India
31 Posts

Posted - 08/05/2009 :  00:18:38  Show Profile  Reply with Quote
we have text files with fixed layout separated by commas. Is it possible to give the text file as datasource to SSRS?

shah429
Yak Posting Veteran

52 Posts

Posted - 08/05/2009 :  18:11:40  Show Profile  Reply with Quote
I don't think you can.
Go to Top of Page

JCirocco
Constraint Violating Yak Guru

USA
392 Posts

Posted - 08/05/2009 :  18:47:21  Show Profile  Visit JCirocco's Homepage  Click to see JCirocco's MSN Messenger address  Reply with Quote
Actually you can. I am repeating from memory and have no access to my work computer from here.

Create an ODBC data source. Control Panel, Admin Tools, Data Sources (ODBC). Add new data source. Select Microsoft Text Driver. Give it a name and select the directory you will be storing the *.csv files. When in the reporting services development tool Create a new data source and change the default from SQL Server database to ODBC. Select the ODBC data source you just created. I think it then prompts you to select the actual *.csv file. There are certain functions you cannot do but worked great for most things I tried.

Hope this helps.
Go to Top of Page

Vadivu
Starting Member

India
31 Posts

Posted - 08/06/2009 :  07:26:32  Show Profile  Reply with Quote
Hi JCirocco i didnt try your approach. thanks for ur suggestion.
but this can be done... use ole db type datasource for the report and give the connection string as follows:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\RxTools;Extended Properties="text;HDR=No;FMT=Delimited"

and then in the query, just specify 'select * from sample.txt'
Its listing all the data.
Go to Top of Page

JCirocco
Constraint Violating Yak Guru

USA
392 Posts

Posted - 08/06/2009 :  08:28:34  Show Profile  Visit JCirocco's Homepage  Click to see JCirocco's MSN Messenger address  Reply with Quote
I'll try that for future.

The reason I know the ODBC setup is in a past job we deployed objects that used ODBC from text as the source data. Because it was directed to the users mapped drives AND each department had a different drive letter for this specific data (not my fault) we deployed the ODBC Datasource through Policies and based upon your group, you received the "proper" version of the ODBC DSN.
Go to Top of Page

navya krishna
Starting Member

India
39 Posts

Posted - 01/23/2013 :  01:50:32  Show Profile  Reply with Quote
Dear all,

i have one problem in ssrs.i need to display sales report customer wise [sales and budget and variance and variance percentage] from different databases but in single server.it will be there detailes in multiple databases.i need to display detailes in single report.could you please anyone help me.for example we are maintaining 2010,2011 databases so i need to display customer no,sales,budget,variance,variance percentage in single report ...

year from 2012 year to 2013 date filter 01-01-12..31-12-13

Customer No. Sales -2012 Budget-2012 Variance-2012 Variance %-2012 Sales -2013 Budget-2013 Variance-2013 Variance %-2013

i need details like this in one report using multiple databases.please anyone help me.


navya krishna katta
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000