Page 1 of 1

Exporting Report Information into Microsoft Excel

Posted: Sat Mar 18, 2017 12:15 am
by admarol
Hi Everyone!

I have a question about Reporting.... Is it possible to have an excel spreadsheet (through a particular formula) pull values from a specific report?

I'd like to pull values from a specific report without having to open up Vision each time. I would like to just click on a button in excel and the values automatically get pulled in from a particular report.

Is something like this possible in Vision?

Thanks in advance,
admarol

Re: Exporting Report Information into Microsoft Excel

Posted: Sat Mar 18, 2017 1:26 am
by aadilnaeem
Hi

It is not possible like this. But we can built something in excel to get required data from database or cubes.

Regards

Re: Exporting Report Information into Microsoft Excel

Posted: Sat Mar 18, 2017 12:11 pm
by admarol
Thank you for your reply.

How would you build something like that? Is it easy to do? Is it something I might be able to do? Are there instructions somewhere on how I could do that?

Re: Exporting Report Information into Microsoft Excel

Posted: Sat Mar 18, 2017 2:37 pm
by aadilnaeem
This is something I provide as part of professional services. It is not provided by Deltek as part of normal deliverable and they charge for this.

If you know where the data is saved and how in the database, then you may be able to extract it from sql server .


Regards

Re: Exporting Report Information into Microsoft Excel

Posted: Sat Mar 18, 2017 9:56 pm
by admarol
How much do you charge? Per hour?