Hi

I'm in desperate need for help.

I've got a report with a subreport inside it - when both the report and the sub report has data - I can export it to excel with no problem

However - when there is no data in the report but data in the subreport I get the following error message:

"You entered an expression that has no value"

Can someone please help

Thanks

Can you export the recordsource of the subreport. Or better yet, create a query that will filter based on what you want and export that query.