Store crystal report in SQL Server

Posted on 2009-04-27
Last Modified: 2012-05-06
I have several crystal reports that I have to distribute to a client. Rather than sending them a couple of files as .rpt files, I was wondering if it was possible to store them as data in an already existing SQL Server DB instead.

I have no idea how to do this and was wondering if it is even possible?

Thanks in advance.
Question by:samic400
    1 Comment
    LVL 4

    Accepted Solution

    We do something similar. We store SSRS reports in our DB with a VARBINARY(MAX) data type. There was a LOT of custom integration through .Net to get this to work, basically the report is rendered as a byte array and propagated down to the DB.

    I'm sure the same thing can be done with Crystal, but I have never done it before. Maybe someone else can give a full answer, I just wanted to comment that it is possible.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Via a live example, show how to shrink a transaction log file down to a reasonable size.

    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