Ok, I have generated a part of my report, and have some questions...
First,I have the normal sections, header, body, footer. The body section groups by the date of the data.
Ok, now, I have to put some data in the header area from a second table, In addition, in the footer I need to put a field from the data in the body.
How can I add a second table to the report, and print the one field in the footer?
You can do it two ways.
Ok, that helps.. Is there a way to add a section to the report? I have section called a group header, is there a way to add a group footer?
Thanks
If you have a group header you'll also have a group footer, they're added together although you can shrink either one to 0 height. And there doesn't appear to be any way to select it after you've made it 0 height so you can't expand it again.
If you simply want to display some information in the header or in the foot that is already available in the calling window, you could do something like the following in the beforePrinting event handler of a report field you add:
if the calling window is window1 and the company name is on that window in a filed called companyName.....
add a report field called company to the footer. In the beforePrinting event handler for the field called "company" add the following code
company.text = window1.companyName.text
If you needed to load multiple fields, you could probably call a function to load a recordset and display the fields using this event
I think I will give it a go......:-)
It works!
in the beforePrinting event handler for, say, the reportLabel that heads the report, one can place a method call. In that method, a recordset can be instantiated, provided that the calling window has access to the unique ID of the the table from which one wants to build a recordset. Then, using the recordset, one can change reportable text, or reportField text. One caveat - this doesn't work if the report field has a DataField with information contained in it.