Text file as Datasource 1

[SR24]

Hi all,

I have a text (.txt) file that contains the data that I need for a report. The db administrators for my client have asked if I could use the text file as the datasource so they don't have to set up a procedure to import the file into the database. I understand it's possible to use a text (.txt) file as a datasource. My question is what type of datasource connection would I use in the Standard Report Creation Wizard to set this up? I tried using ODBC but I see all of the data in one field. Is this a problem with the connection or the text file? Any ideas would be helpful.

I am using CR XI Standard. Thanks for the help!

SR24

 

[fsreport]

Hi
Try ttx data source in you selection select other datasource

fsreport

 

[fsreport]

hi
here are the step involve

http://technicalsupport.businessobj...sliceId=&dialogID=2232048&stateId=1 0 2228839

good luck

fsreport

 

[SR24]

Thanks for the reply. I tried setting up the ODBC connection. I followed the instructions in the link you provided. Everything works fine until I try to click ok to complete the setup. I am getting an error message that states "Failed to save table attributes of (null) into (null)". Any ideas?

SR24

 

[fsreport]

hi
do a lookup on this link

http://technicalsupport.businessobjects.com/KanisaSupportSite/search.do

cheers

fsreport

 

[senamuna]

Hi,


Can a list of values in a .txt or.xls file be used as parameters for a report ?

I need to lookup hundreds of order numbers to check order status. Currently, IT staff has to run a query for the customer service team.

I use CRXI with Oracle & DB2 databases.

Thank You

SenaMuna

 

[lbass]

You can create a parameter in CR and then import a .txt file to populate the list of values. Is that what you mean?

-LB

 

[senamuna]

Thanks lbass,
That should do it. Do I need Crystal Enterprise ?

Regards,

SenaMuna

 

[lbass]

No, not to do this.

-LB

 

[dgillz]

Just make your parameter a dynamic parameter on the order # field if you are using XI.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry