more problems after creating more records...

[jhermiz]

...Ack..after creating one record and sticking with one single record in my database app I've seem to find more problems today with reporting. My crystral report only shows data for the original record that I had in my database. I created a new record and tried running a report again..and all the header information in the report is totally blank. Its as if it does not see the record. Could something be wrong here? Do I need to provide any connection information to my crystal reports?

Im so confused as to why this is happening. I simply have a vb form with a few combo boxes allowing me to select which record I want to print. After I created a new record I select that record and click the ok button. The crystal report viewer opens up with no header information...and all the sub reports inside of this report refer to the first record I had originally created. WHY WHY WHY1!!!!!!!

Please help,

Jon

[smitsc]

In my limited knowledge of Crystal Reports and the way I've used it, It requires a dataset and a strickly typed dataset at that. To read data from a database I have to use the OleDbDataAdapter (SqlDataAdapter didn't work) from the data toolbox, go thru the connection wizard, then create the dataset with the data context menu drop down "Generate dataset", then in the code do the following:

Dim myDS As New dtsLeadList()
OleDbDataAdapter1.Fill(myDS)
Dim myReport = New rptLeadList()
myReport.SetDataSource(myDS)
crvLeadList.DisplayGroupTree = False
crvLeadList.ReportSource = myReport

dtsLeadList - is the dataset I created
crvLeadList - is the Crystal Report Viewer placed onto the form
rptLeadList - is the report

when you create the report use an expert to pick the dataset and fields.
Let me know if this makes any sense!

[jhermiz]

This has been resolved in the general forums.

Jon

[smitsc]

but where do I put the paperorientation, niether the viewer object or the report class support it and where/what do I declare as "crLandscape"?
In particular how would it apply in the code I sent you in my reply to your thread, I'm using VB.NET and the Crystal Reports Viewer component.