Wrox Programmer Forums
|
Crystal Reports General discussion about Crystal Reports. For discussions specific to the book Professional Crystal Reports for VS.NET, please see the book discussion forum for that book.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Crystal Reports section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 27th, 2004, 05:48 AM
Registered User
 
Join Date: May 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Parameter Prompts

We are trying to allow filtering at the report level. Ideally we would want drop down lists on the report that the user can use to select the parameters. Is this possible with crystal? It seems the current way is to prompt the user for the parameter with a pop up. Can we remove this popup or format it's appearance?

Cheers in advance :)

 
Old May 30th, 2004, 01:04 PM
Registered User
 
Join Date: Nov 2003
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default


Hi.
- place a CrystalReportViewer control on a form
- a button
- a combobox

in the following code,
the user selects a value in the combo (wich is first bind to a datasource, datamember etc..)
press the button and the viewer loads the
report passing the combo selection as parameter
then no popup is needed.


here is the code: hope this helps.
with thanks to the 'DragonsHouse'.
--------------------------------------------


Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

        CrystalReportViewer1.ParameterFieldInfo = Nothing
        CrystalReportViewer1.ReportSource = Nothing

        paramField = New ParameterField
        descreteVal = New ParameterDiscreteValue
        paramField.ParameterFieldName = "ClientName"
        descreteVal.Value = Me.CMB_ClientName.SelectedValue
        paramField.CurrentValues.Add(descreteVal)
        paramFields.Add(paramField)

        CrystalReportViewer1.ParameterFieldInfo = paramFields

        Dim a As New crCustomerByWorkers ' the rpt file
        CrystalReportViewer1.ReportSource = a
    End Sub







Similar Threads
Thread Thread Starter Forum Replies Last Post
Report prompts to save changes on close srcLakeJake Access 3 January 4th, 2008 09:16 AM
Disable or Hide Prompts? LiamBFC Access VBA 2 April 19th, 2006 07:54 AM
Frequent prompts 4 password mod_ntml.so in apache urmilasingh J2EE 0 August 4th, 2005 10:50 AM
dsn prompts for password femig ASP.NET 1.x and 2.0 Application Design 1 April 14th, 2005 08:12 AM
Append Query Prompts lryckman Access 3 September 30th, 2004 08:12 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.