Thank you very much for replying
The reason I would not be able to use these tools is that the user needs to be able to enter a start date, end date and SSN number to generate the report. The use must be able to access the report any time they want. I don’t think the users have access to these tools.
I spoke to a developer after posting and he said that you would need to change the file to .asp and then place it on a web server that the user can access. He said that the script would need to be modified with the correct connection string and table and field references before it would work.
Aside from the developers creating a program I need a solution that a user can generate a CVS file and the specs for the output are as follows:
Example:
Position 0-9 = SSN
Position 10-22 = First Name
Position 23-35 = Last name
Position 36- … = …
Do you know if report server will do the job. I know I can write the query to extract the data, but the users must be able to generate it and it must be delivered as a CVS
Your help is appreciated.
Jeff