R – Override the Refresh Crystal Report that brings up their criteria page

crystal-reportsnet

I have a vb.net winforms application.

I have created a criteria form that populates parameters in a Crystal Report. These parameters are pretty simple, IE customerId, StartDate, EndDate, etc…

This works fine, but if the user presses the crystal reports "Refresh" button on the CrystalReportViewer control then the CrystalReports criteria page displays. Obviously my user doesn't know the CustomerId so I'd rather not display this screen.

Is there a way to override the CR criteria page with my own? Failing that, can I disable that option on the CrystalReportViewer?

Best Answer

You don't say which version of Visual Studio or Crystal Reports, but the Viewer control should have a property called ShowRefreshButton.

Alternatively, there is also a ReportRefresh event which will fire when you click the button, but I think this will be fired when you initially load the report as well so you'll need to selectively override it by setting e.Handled to True.

Related Solutions

Crystal Reports – “The report you requested requires further information”

I have found the best way to fix a bug is to post the question to StackOverflow and 5 minutes later work it out yourself. Needless to say, I worked this out.

As well as setting all the log on info in the report objects, I also have to do it in the Crystal Viewer component in ASP.NET. So I just write some code like this and it all works, no prompts.

<CR:CrystalReportViewer Height="500px" ID="Viewer" runat="server" />

var connectionInfo = new ConnectionInfo();
    connectionInfo.ServerName = "192.168.x.xxx";
    connectionInfo.DatabaseName = "xxxx";
    connectionInfo.Password = "xxxx";
    connectionInfo.UserID = "xxxx";
    connectionInfo.Type = ConnectionInfoType.SQL;
    connectionInfo.IntegratedSecurity = false;

for (int i = 0; i < Viewer.LogOnInfo.Count; i++)
{
    Viewer.LogOnInfo[i].ConnectionInfo = connectionInfo;
}

Prevent white space from showing on Crystal Report with suppressed page footer

Suppress blank does not always work. In the Format Section properties for that section, click on the conditional suppression button (X+2) and use something like the following:

If OnFirstPage Then
   True
Else
   False

That tells it to set Suppress=True on the first page.

If I misread your question, let me know. It's fixable though.

Best Answer

Related Solutions

Crystal Reports – “The report you requested requires further information”

Prevent white space from showing on Crystal Report with suppressed page footer

Related Topic