Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Vadivu
Starting Member
31 Posts |
 Posted - 2009-08-05 : 00:18:38
|
| 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 - 2009-08-05 : 18:11:40
|
| I don't think you can. |
 |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-08-05 : 18:47:21
|
| 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. |
|
|
|
Vadivu
Starting Member
31 Posts |
Posted - 2009-08-06 : 07:26:32
|
| 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. |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-08-06 : 08:28:34
|
| 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. |
|
|
|
navya krishna
Starting Member
39 Posts |
Posted - 2013-01-23 : 01:50:32
|
| 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-13Customer 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 |
|
|
|
|
|
|
Text file as datasource to SSRS