how to generate dynamic crystal reports

[sureshgv]

i want to generate report dynamically in the formate

select * from table where month=m and year =y

How to do this ?very urgent..please help me

[bplacker]

i want to generate report dynamically in the formate

select * from table where month=m and year =y

How to do this ?very urgent..please help me

do the same as you would with a datagrid view.

open a connection to the database,
create a new data adapter (sql statement, connection name),
fill your dataset with the dataadapter,
fill your dataview with the table from the dataset,

set the report source of the crystal report to your dataview

[magache]

bplacker...

HOW CAN I DO THIS:

set the report source of the crystal report to your dataview ??????????????????????????????????????????????????

[dip_developer]

bplacker...

HOW CAN I DO THIS:

set the report source of the crystal report to your dataview ??????????????????????????????????????????????????

actually

1. Set the DataSource of your report object to the Dataset or Dataview....and then.........

2. Set the ReportSource of the CrystalReportViewer to your report object.

 
Dim myReport As New CrystalReport1
myReport .SetDataSource(myDataset)
myCrystalReportViewer.ReportSource = myReport