Report Footer Subreport 1

[awl]

I have placed a subreport in the Report Footer section of my main report. In the Detail section of the subreport, I have placed a bound textbox, based on a query. When I go to the design of the main report, the design of the subreport is also displayed. However, when I run the main report, only the label of the subreport is displayed and not the contents of the subreport. When I run the subreport separate from the main report, the contents of the bound text box is displayed. Is there something that I am missing in the properties of the subreport as to why the contents is not displayed in the main report? Thank you for your help.

 

[JerryDennison]

Chcek the subreport's link Master/Child fields property to insure it is pointing to the correct linking field for both reports.

 

[CosmoKramer]

I think it has to do with the fact that the subreport is in the main report's report footer. When the subreport is placed there it will only show the data that links to the last detail.

 

[awl]

Thank you Jerry & Cosmo for responding. Jerry: the Link Master/Child fields property are both set to the same linking field. Cosmo: I placed the subreport in the Report Footer to capture one of the entries in the Detail Section of the Main Report, so I could do a final calculation in the Report Footer. In the design of the main report, I do a Layout Preview of the subreport, which shows a sample of beginning data that is linked to the table based off the query. My possible solution: Create 2 subreports in the Detail Section of the Main Report, thus not using the Report Footer of the Main Report, if I can't get around the Report Footer issue. Thanks....

 

[CosmoKramer]

Why does it have to be a subreport?? Couldn't you re-reference your field and perform your calculation again in the footer??

 

[awl]

Mr. Kramer: I deleted the subreport in the Report Footer, and inserted a bound control, the source coming from a query. Problem: The results prompt me to “Enter Parameter Value” for the sourced query, which I have not directed any parameter values for that query. In the example below, #6 and #7 is what I’m after. #1 through #4 are in the Detail Section of the main report via a select query. #5 is in the Report Footer of the main report. #6 is a bound control text box from a separate query with no parameter values. That value is the same data as #3. #7 would be my final calculation. Is this do-able? Thanks.

1. Corporation A $150.00
2. Corporation B $100.00
3. Misc Income $ 50.00
4. Corporation C $ 40.00
______
5. Total Deposits $340.00
6. Minus Misc Income $ 50.00
______
7. True Income $290.00

 

[CosmoKramer]

You should be able to do 5, 6, and 7 in the report footer. Number 6 could be a DLookup function to get that value and #7 could be a simple calculated text box like:

=([txtFive-txtSix])

 

[awl]

Mr. Kramer: Thanks very much. The following are the two text boxes I used for #6 and #7 based on your suggestion:

=DLookUp("[Amount]","qrySummary of Deposit Descrip Misc&quot

=Sum([SumOfAmount])-(DLookUp("[Amount]","qrySummary of Deposit Descrip Misc&quot)

This is exactly what I was looking for. Thanks again.... Curtis...