I have a feeling there was a question about this once before, but I can't find it now.
I have a report where there is a one-to-many link to another table, and i have to use the latest value from this table each time.
I have used a subreport to find this and it is in the detail line of the report, (returning just the one value).
This report has to be exported to Excel, and when I do that, the subreport field appears on a separate line, not at all where it is placed on the report.
I have tried it both at the beginning of the line, and at the end, either way it messes up the spreadsheet.
Is there any way to make it appear on the same spreadsheet row?
IP Logged
