Execute an existing crystal report through c#.Net web site

Oct 14 2008 3:29 PM
I've few existing reports created in crystal report 10. I want to deploy them on a website.

I've created a simplest of the web site in VS 2008. Default.aspx has a hyperlink to report name.
When user clicks on hyperlink report should be previewed.

Every time I launch the website, Report shows data it was saved with and do not refresh the data automatically.
Also it does not prompt for the parameters.
If I click the refresh button it asks me for for database credentials - I don't want user to input database credentials every time.

Can you suggest solution to achieve above 3 points.

Code on click of hyperlink is.
<div>
        <asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~/Default.aspx"
            Target="_self">Back</asp:HyperLink>
    <CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server"
            ReportSourceID="CrystalReportSource2" Height="1055px"
            Width="820px" EnableDatabaseLogonPrompt="False" HasRefreshButton="True"
            ReuseParameterValuesOnRefresh="True" />
        <CR:CrystalReportSource ID="CrystalReportSource2" runat="server">
            <Report FileName="C:\ranjit on Aad95683\GTMS\GTMSWeb\GTMS_POB.rpt">
            </Report>
        </CR:CrystalReportSource>
    </div>


Answers (2)