SSRS preview report refreshing

Posted on 2012-09-06
Last Modified: 2012-09-11
i have a SSRS report. when i preview the report it takes a few minutes to generate the preview. is there a way to cache the report so when i preview it instantly displays the results and reflect the formatting changes that i apply like crystal does.

Question by:raufraza
    LVL 11

    Expert Comment


    Author Comment

    i have tried this and it works as far as report builder is concerned but i am developing in visual studio. is there any any way to replicate it on VS?
    LVL 25

    Expert Comment

    Another option is you can build a cache table for yourself. You must be doing some calculations which involves different tables to build your dataset. Just schedule with the help of some job and create a table where you fill up all the possible results. So, finally for getting your dataset, you will do a select columnNames from YourTable.
    LVL 21

    Accepted Solution

    in development environment it is not possible.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
    Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now