Group footer - how to use data fields

Hans

How can I show data fields in a Group Footer?

We do have very large queries (views with several tables) and group the data at several fields. Per group we do have added a footer with summaries. The summaries are showing well but the description (Table field) are not visible.

I have read that the Table fields should be in the data bands, but is seems very normal that could print Table fields in the groups also (the 'green bands). Like (fat is the data): 'Total for customer Mister Fastrport: 10.340,30'.
Do I have to set some property?


Tia
Hans

AlexTZ

Hello,

There is no problem to print group condition in the group footer. See the attached report, you can run it in the demo.exe.

Hans

Hi Alex,

I have created some test reports with data in the Group footer also, but a real live report does not shown the Table fields in the Group footer.

I included a zip with a Sample.frx and a XML and XSD file with an example. The Bold fields are not shown.

Please, can you have a look?

Thanks
Hans

AlexTZ

Your report has the following structure: Group + Master-detail-subdetail. All databands are connected to the same datasource (which is not correct, you have to use different datasources for each databand).
You are trying to print the data column from the datasource attached to subdetail databand, in the group footer. This is not correct because the subdetail datasource is in EOF state, so you'll get the empty data.