excel with another reporting tool?

G

Guest

hi,

I have only worked on vba macros where my input and output
is both excel. Using macros most of the time it crashes
and the end-user is then not comfortable with it.

I wanted to go for a better solution. Not sure how go to
about it. I was thinking of generating crystal reports.

If i use crystal reports how is the format generated. I
wanted to its feasibility study. Anyone who has done some
work on this please go suggest. Will the end user have the
authority to still edit the report. WIll it contain the
formulas as we fianlly see in the excel.

Please provide any infomartion that can be of use to me.

thanks in advance.
 
F

Frank Kabel

Hi
this is one of the things that can (IMHO) not be answered in full
detail within a newsgroup. Some points for you to think about :)
- First define your data source:
-> Database (if yes which one)
-> update of your data (regulary, etc.)
As you're currently using Excel I believe you also have stored your
data within Excel. Though AFAIK it should be possible to access it with
Crystal Reports Excel is NOT the ideal application to store a huge
amount of data

- What reports do you require (detailed specification)
- and much more

And as Crystal Reports is not that cheap you really should do this kind
of feasibility study within your company. Should at least take some
days as you also should include the effort to migrate your existing
reports.
 
Top