I have created a recordset(R1) and add 3 fields to it using the fields collection and appending these fields to it.
1. Manager Name
2. Sales Region
3. Sales Growth
I open a second recordset(R2) and fetch data for the Manager Name and Sales Region from the database. I loop through this recordset(R2) and assign values to fields 1 & 2 fields of my first recordset(R1). The 3rd field is assigned a value based on a complex calculation. There is no way to get the 3rd field as a part of the query using SQL, since it involves a lot of complexity.
Now I want to show my first recordset(R1) as a report using crystal reports 8.5. Can anyone tell me how to assign a recordset to crystal reports at runtime? I will be using the rpt file and I will not be creating the report on the fly.
I do not know how to place a field in the rpt file that does not exist till runtime.
Any URLs in this direction might also help