I am using Visual Studio .net 2008, which has a Crystal Reports builder. I have gotten to the point of building the report from a view I have setup on my SQL server.

Instead of using a table on the server, can I use a table from my DataSet? I want to be able to select specific records, and report only results of that select statement.

I'm sorry, I'm very new to Crystal Reports. This may be a very simple problem, but I just don't know.

Any and all help is MUCH appreciated!

For anyone that may have the problem in the future, I figured it out...

Dim reportSource As New DocumentRev

        'setup the parameters 2-2-2010, replaced old system
        Dim crParameterDiscreteValue As ParameterDiscreteValue
        Dim crParameterFieldDefinitions As ParameterFieldDefinitions
        Dim crParameterFieldLocation As ParameterFieldDefinition
        Dim crParameterValues As ParameterValues

        '
        ' Get the report parameters collection.
        '
        crParameterFieldDefinitions = reportSource.DataDefinition.ParameterFields
        If crParameterFieldDefinitions.Count > 0 Then
            ' Add parameter values
            crParameterFieldLocation = crParameterFieldDefinitions.Item("docID")
            crParameterValues = crParameterFieldLocation.CurrentValues
            crParameterDiscreteValue = New CrystalDecisions.Shared.ParameterDiscreteValue
            crParameterDiscreteValue.Value = Me.strID
            crParameterValues.Add(crParameterDiscreteValue)
            crParameterFieldLocation.ApplyCurrentValues(crParameterValues)
            ' Add a parameter value - END
        End If

        Me.CrystalReportViewer1.ReportSource = reportSource

This was rather difficult to do. And there are very little resources online to help with it. Hopefully this code will at least get you started!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.