Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

passing all values from main report to subreport

Status
Not open for further replies.

rreddy01

Programmer
Apr 18, 2012
15
US
I have a mainreport which has ID,contractID(15 characters- A10000-00-000-0),date..

Mainreport has group by on ID..

for ex: there is a contractID: A11111-00-010-00 is under ID 01 for tthe date may2012.
but there may be same contractId just with slight difference in number under jan2012 and under different ID..I have to look for such ID's and get all in one report.
Mainreport has parameter on date

Now i want to link main report and subreport but while linking i have to pass all the contractid's that i get in main report to subreport and i want one more condition in subreport like it should check first 13 characters in contractid and get the matching contractid's in subreport..

Any help is appreciated..
 
You need a formula field,
Code:
Left({contractID}, 13)
Pass @First13 to the subreport and use it for selection, maybe matching to the first 13 of a field in the subreport data.

Probably you'll need to remove the subreport record selection that will be created automatically by Edit > Subreport Link. Replace it with your own command.

[yinyang] Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top