I am using VB6 SP5 and CR8 Developer Edition and the RDC. I am making a record selection formula from a form which has a DataGrid and the Pr_Id field of the currently selected record should become the recordselectionformula.
The CRViewer is on another form (Form2) so I have to use Form1.dcProjects.Recordset!Pr_Id to set the RecordSelectionFormula for each print. Everything goes fine when I do the first view on the screen using CRViewer. But that is it. For the next record onwards only a blank format appears and no data!!! When I quit the application and return again, I get the first print (could be any record) perfectly but after that nothing..... Interestingly, the Report.Recordselectionformula property displays the correct selection formula for all the subsequent records.
Here is the relevant part of the code:
Report.RecordSelectionFormula = "{Project.Pr_Id}=" & Form1.dcProjects.Recordset!Pr_Id
Please help. TIA.
The CRViewer is on another form (Form2) so I have to use Form1.dcProjects.Recordset!Pr_Id to set the RecordSelectionFormula for each print. Everything goes fine when I do the first view on the screen using CRViewer. But that is it. For the next record onwards only a blank format appears and no data!!! When I quit the application and return again, I get the first print (could be any record) perfectly but after that nothing..... Interestingly, the Report.Recordselectionformula property displays the correct selection formula for all the subsequent records.
Here is the relevant part of the code:
Report.RecordSelectionFormula = "{Project.Pr_Id}=" & Form1.dcProjects.Recordset!Pr_Id
Please help. TIA.