I don't know why it isn't working, Gnana, but just take the code from the Query, use it to build a cursor and call the report while the cursor is the SELECTed area. Your report will work from it if you don't have specific tables linked to your report fields.

I've found that the View Designer and the Query Builder are more useful to develop the starting SQL code than they are at producing end results.

HTH
Barbara

>I selected output settings of a query in the query designer as reports. The query works fine cuz it returns valid results in the browse window. But my report never gets populated. Am I doing something wrong?
>
>Thanks
>Gnana.