Crystal 8.5, Assign recordset

Hi

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

Thank you
LVL 13
VICKRAMAsked:
Who is Participating?
 
ee_ai_constructCommented:
Closed, 50 points refunded.
ee_ai_construct (replacement part #xm34)
Community Support Moderator
0
 
frodomanCommented:
You didn't indicate the development language you're using - I'll assume vb since it seems to be the most common.  You can give this link a try: http://support.businessobjects.com/communityCS/FilesAndUpdates/cr8_vb_rdc_getnextrows.exe.asp

0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
VICKRAMAuthor Commented:
Sorry those didnt help.. I just figured out that you can have a field definition file (.ttx) and then assign a recordset to it at runtime..

anyway thanks for your help
0
 
VICKRAMAuthor Commented:
I think I can have my points credited to me

Thanks
0
 
mlmccCommented:
Actually you can't get them credited to you but you can get them refunded.  Submit a request in the Community Support forum asking they refund the points and PAQ this question.

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.