Hi
I have a subreport which lists a table of information:-
Jan 123
Feb 124
Mar 456
Apr 567
I then want the main report to search down the first column and pick out the corresponding figure in the second column. ie. for Feb it would return '124'. I also need it to return '0' if the month being searched for is not in the first column. I know how to get and set data from a subreport to a main report, it is the looking up bit I don't know how to do.
In Excel I would use the 'vLookUp' function, is there a similar way to do this in Crystal Reports 9?
Thanks
I have a subreport which lists a table of information:-
Jan 123
Feb 124
Mar 456
Apr 567
I then want the main report to search down the first column and pick out the corresponding figure in the second column. ie. for Feb it would return '124'. I also need it to return '0' if the month being searched for is not in the first column. I know how to get and set data from a subreport to a main report, it is the looking up bit I don't know how to do.
In Excel I would use the 'vLookUp' function, is there a similar way to do this in Crystal Reports 9?
Thanks
