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!

7 Years
Discussion Span
Last Post by bklynman01

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
            ' 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!

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.