Crystal Reports 2008 on the intranet


Ideally, I would publish basic reports on our intranet and allow users to interact with parameters and return results.

I have Crystal Reports 2008.
I have Crystal Reports Distributor on the way.
Would I need anything else?

Note, only a couple of us have Crystal Reports installed, I am really hoping even non users can access these reports.

Is what I am after an option?

Thanks all
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Haris DulicIT ArchitectCommented:
the best option when you don not have crystal report on all machines installed is to use crystal report viewer which is (the best) free download.. basically it just can not create reports... but can work with parameters and refresh the reports...

here is the link for more info...
H0P5Author Commented:

Thanks for that. Its usefull. However, via the viewer I am unable to refresh. I was hoping the viewer would be able to refresh, be prompted for a parameter, and then update.

The source data is in a locked SQL database. Only a few of us have access to it. Would any viewer need to be mapped to retrieve from that database? Or do we have other options?
Haris DulicIT ArchitectCommented:
since your crystal report is conectiong to database, when you save your report file and open it with the viewer it will inherit all options (your username, password, other options) ...

the refresh is based on that if you save your report with undelying data it wont refresh but if you say refresh on open it will ask for any paramater and refresh...

you can download and test it... its free ... ;)

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
H0P5Author Commented:
Perfect. It works like a charm.
Better yet if it was cheap. How much?! Best still...

Thanks ever so much sir :o)
H0P5Author Commented:
Great advice, thanks a bunch
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.