CSV file and Crystal

CSV file and Crystal

[ Follow Ups ] [ Post Followup ] [ Message Board ]

Posted by [IP Address: 134.231.254.254] 'Raghu' on June 22, 2001 at 11:23:15 EST:

Can anyone tell me how to create CSV files using SQR so that it can be used as a ODBC data source for a crystal report.Peoplesoft has some reports which uses an sqr to write a csv file and then a crystal picks the data from there. I created a similar sqr but its not working as it should. The PS CSV file when opened in crystal shows the field names(no idea where they came from as the sqr does nothing to write those field names). In my CSV file field names does not show when browsing thru crsyal in select data sources.

Any one who had worked on a similar program can help me

Thanks in Advance

-Raghu

Follow Ups:

Post a Followup

Name:
E-Mail:
Subject:
Message: : Can anyone tell me how to create CSV files using SQR so that it can be used as a ODBC data source for a crystal report.Peoplesoft has some reports which uses an sqr to write a csv file and then a crystal picks the data from there. I created a similar sqr but its not working as it should. The PS CSV file when opened in crystal shows the field names(no idea where they came from as the sqr does nothing to write those field names). In my CSV file field names does not show when browsing thru crsyal in select data sources. : Any one who had worked on a similar program can help me : Thanks in Advance : -Raghu