Click to See Complete Forum and Search --> : Crystal and SQL2000 and Access


cga1982
June 6th, 2005, 11:45 AM
I have an Access project front-end and a SQL2000 server back end and would like to use Crystal Reports to generate the reports.
What would be the best way to structure this so that the users can use the Access front end, run Crystal in the background accessing the SQL2000 data and then display the report on the users PC?
Some of the reports would require parameters from the users (entered through the Access front-end) and some would have the same parameters all of the time.
Thanks.