Hello All,
This is kinda hard to explain but I'll try! I'm updating a existing report in crystal reports 6.0 .. it's a datafile (no sql) and the database is an access db and it is locale (no server). This report does many thing .. oh .. first i should say that i work for an insurance company ... this report links like 40 tables and it is a client detail report. It gets there personal info, which i had to use a subreport for because of conflicts in the "When linking from more than one file" link options. The (insurance) policy info is all done in headers. It loops (i'm not sure how) and prints out all of the clients policys. The detail sections (i have three) is for their investment info. Many
policies are tied to investments. My boss wants me to take the investment info and match it to corrisponding policies and have them print underneither the policy info. The policy info stuff is grouped by a policyID ... what makes them diff (the invest or policy numbers) is an "L" or "I" in the acct number ... 1234567L001 ("L" Life insurance policy) ..... 1234567I004 ("I" Investment). Is there a way
to put the detail stuff (where it applies) right underneith the policy info from the headers??? The groups are grouped by several different things ...not all just one field or formula .. a couple of both ... I hope i described this well enough. Please help ... and let me know if you have anymore questions or if i could be more descriptive.
Thx in advance ...
Jamieson McNab Leitch
This is kinda hard to explain but I'll try! I'm updating a existing report in crystal reports 6.0 .. it's a datafile (no sql) and the database is an access db and it is locale (no server). This report does many thing .. oh .. first i should say that i work for an insurance company ... this report links like 40 tables and it is a client detail report. It gets there personal info, which i had to use a subreport for because of conflicts in the "When linking from more than one file" link options. The (insurance) policy info is all done in headers. It loops (i'm not sure how) and prints out all of the clients policys. The detail sections (i have three) is for their investment info. Many
policies are tied to investments. My boss wants me to take the investment info and match it to corrisponding policies and have them print underneither the policy info. The policy info stuff is grouped by a policyID ... what makes them diff (the invest or policy numbers) is an "L" or "I" in the acct number ... 1234567L001 ("L" Life insurance policy) ..... 1234567I004 ("I" Investment). Is there a way
to put the detail stuff (where it applies) right underneith the policy info from the headers??? The groups are grouped by several different things ...not all just one field or formula .. a couple of both ... I hope i described this well enough. Please help ... and let me know if you have anymore questions or if i could be more descriptive.
Thx in advance ...
Jamieson McNab Leitch