Skip to Content
author's profile photo Former Member
0
Former Member

Export To Excel from Precalculated Web Template

Posted on Feb 01, 2005 at 05:32 AM 17 Views

we have a web report that is being precalculated. The report works fine, and runs quickly due to the precalculated data. The problem I have is that the users wish to export the details to Excel (as I do on other web reports for them, by adding in the export to excel button that is on the standard web template). When this button is clicked, it doesn't access the stored data, it goes and reruns the query.

Does anyone know of a way to force it to use the precalculated data, and not rerun the query?

Thanks in advance

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Feb 01, 2005 at 10:32 AM
    0

    When creating the pre-calculation package, you have the option to already store it as an excell sheet during the pre-calc run...

    IS this not an option?

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Feb 01, 2005 at 09:38 PM

      Hi Tom, Thanks for your response.

      You can store an excel sheet, but how do you link to that from the web report?

      If you were to use this method, I believe that users would have to look at the report on the web, and then go to the download scheduler, choose the same report, and then download it and open it from there??? Please correct me if there is an easier way for them to do this.

      The corporate strategy is to use the web, and this is suitable for most users, but sometimes it is necessary to export reports to excel.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.