Hi all,
I've been searching high and low for a solution to something that would take me 5 mins to do in crystal reports :banghead:
I have a report which is grouped via customer. In the header I have iif fields
(=IIf(IsNull([DelAdd5]),IIf(IsNull([AddL5]),[DAdd5],[AddL5]),[DelAdd5])) to pull the delivery address from the customer and order tables. The items are then listed in a details section.
Then the report moved onto the next customer + details etc.
What I'm trying to do is list the Address5 text field (which contains the =iff's) that are in the headers into a text box in the report footer followed by a comma.
I.E 1st customer's post code, 2nd, 3rd, etc. So it should look like
nn10 4ft, lq2 3et, sq6 7ff, etc
I would normally just make a global string, put each one into that and dump the result in the footer.
I would be thankful for any help!
I've been searching high and low for a solution to something that would take me 5 mins to do in crystal reports :banghead:
I have a report which is grouped via customer. In the header I have iif fields
(=IIf(IsNull([DelAdd5]),IIf(IsNull([AddL5]),[DAdd5],[AddL5]),[DelAdd5])) to pull the delivery address from the customer and order tables. The items are then listed in a details section.
Then the report moved onto the next customer + details etc.
What I'm trying to do is list the Address5 text field (which contains the =iff's) that are in the headers into a text box in the report footer followed by a comma.
I.E 1st customer's post code, 2nd, 3rd, etc. So it should look like
nn10 4ft, lq2 3et, sq6 7ff, etc
I would normally just make a global string, put each one into that and dump the result in the footer.
I would be thankful for any help!