generating a crystal report depending on the selected item in a dropdownlist

[dianaj86]

How to generate a Crystal Report depending on the selected Item in a dropdownlist using vb?

Thanks,

[dip_developer]

How to generate a Crystal Report depending on the selected Item in a dropdownlist using vb?

Thanks,

Depending on the SelectedItem of combobox your sql query will be changed.....

So try something like...

 
Dim mySqlString As String 
Select Case mydrodown.SelectedItem.Text 
Case "FirstItem" 
mySqlString="Select A From myTable1" 
Case "SecondItem" 
mySqlString="Select B From myTable2"
End Select
 

1.now populate a DataSet (say myDataset) with query mySqlString
2.set your Crystal report(say myReport) DataSource property to myDataset
3.set your CrystalReportViewer(say myCRV) ReportSource property to myReport

try this.....

 
If myDataset.Tables(0).Rows.Count = 0 Then 
MsgBox("NO RECORD FOUND", MsgBoxStyle.Critical)
Else
Dim myReport As New CrystalReport1
myReport .SetDataSource(myDataset)
myCRV.ReportSource = myReport 
End If