I've set aside SQL commands for now and have created the Crystal report using a VIEW as the data source, which utilizes the (exact same) SQL query (as the original MS Access report) in it's native environment. And it works!!!
It even brings across the parameter for selection of the report date...
I'm a business analyst that has to perform some report development or modifications to existing reports. We have no report developers on staff, so must contract out this work.
I've been working with MS Access reports for the past 5 years and have become pretty familiar with Access SQL. Since my...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.