Link to home
Start Free TrialLog in
Avatar of J.R. Sitman
J.R. SitmanFlag for United States of America

asked on

If a database is designed in SQL can it use Crystal Reports

We have an Access database that I jointly designed.  My boss wants users who have no knowledge of Access or Visual Basic to be able to design their own reports.  I know it's not possible with Access.  Is it possible if the database was SQL?
ASKER CERTIFIED SOLUTION
Avatar of PortletPaul
PortletPaul
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of J.R. Sitman

ASKER

Thanks for the input.  She has me so frustrated with this stupid project.  I do all the reports they need but she wants users to do there own.  
So basically you're saying even with SQL it still won't be simple?
I've never used Crystal Reports so I have no idea how it works.
@mlmcc, I posted before I saw your comments.  I never heard of Universe or WebI so I have no idea what they are.  
In a previous post I made months ago the EE's who responded said Crystal would not work with Access, you're saying it will?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Our database is for the Society for the Prevention of Cruelty to Animals Los Angeles.  

So if I'm a user with no knowledge of the structure of the database and I use Crystal, can I create a report that tells me how many animals were adopted in March from Long Beach?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
OK, this is very helpful.

Thanks
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks to all of you for your input.  It has helped me make my case that the users will not easily be able to create reports.  I'll split the points.