I am using VB6 and CR8.5. I am creating a report from a flat database but a couple of the fields in the database are created during runtime. The number of fields depends on what the user has entered in some other table but it could be up to 2 or 3 extra fields.
Before the table has fields added I have RecID, RecDate, and RecSection. I then add a couple like RecClass1 and RecClass2.
I then use VB code to put data into the database fields ready for the report.
I decided that the only way to pass data to the report was using unbound fields in CR. Then use VB code.
ie.
With IncReport
.unboundnumber1.setunboundfieldsource "{tblFreq.RecDate}"
.unboundnumber2.setunboundfieldsource "{tblFreq.RecClass1}"
.unboundnumber3.setunboundfieldsource "{tblFreq.RecClass2}"
etc
end with
This all seems to work OK. What I now have to do is group by RecSection. Is this possible using unbound fields or is there a better way to do this.
Before the table has fields added I have RecID, RecDate, and RecSection. I then add a couple like RecClass1 and RecClass2.
I then use VB code to put data into the database fields ready for the report.
I decided that the only way to pass data to the report was using unbound fields in CR. Then use VB code.
ie.
With IncReport
.unboundnumber1.setunboundfieldsource "{tblFreq.RecDate}"
.unboundnumber2.setunboundfieldsource "{tblFreq.RecClass1}"
.unboundnumber3.setunboundfieldsource "{tblFreq.RecClass2}"
etc
end with
This all seems to work OK. What I now have to do is group by RecSection. Is this possible using unbound fields or is there a better way to do this.