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..
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..