Hi,

I seem to be having some problems with SQL Queries.

In my page header I have the following query:

(select Description from PayComponents where [PayComponents].[PCompID]=1)

However, it doesn't show on the first page. It works perfectly on the other pages, but not on the first page.

The bizarre thing is I use the exact same query on another report where it is working perfectly.

Is there any reason why this wouldn't work on the first page?!

Sorry I hadn't toggled email notification. I am using Crystal Reports 2013. I ended up having to copy and paste into a new report and it all works fine now. I don't know what was wrong.