Showing Result of a Query in GroupHeader

nirmal.rajmohan

Hi Friends,

I need to run the below Query to find the total population and show it in the GroupHeader.

<!--fonto:Courier New--><span style="font-family:Courier New"><!--/fonto-->SELECT Sum(M)+Sum(F) AS Total FROM Population WHERE (((Population.[EntryDate])<#1/1/2001#));<!--fontc--></span><!--/fontc-->

Need to replace the hard coded date in the SQL query with the value from Group Header.

Database


Report



I tried Sub-Reports, events, etc.. but I cannot get this to work...
I have attached the Report with this post, please check it.

Please help me to fix it.


Thanks in advance,

Nirmal. R

gordk

as with any version of fr to display sums of values contained in a group in the group header
the report must be 2 pass store the values in an array on the first pass
in the second pass substitute the value in the array in the memo/s in the header.

sultan

I need to run the below Query to find the total population and show it in the GroupHeader.



____________
sultan