Liveware Publishing Support Forum

Hope you can help me I am using Report Writer version 9 I need to create a basic report where a text field has a total next to it.____I need the total to count all instances within the selected table. The report needs to go away and calculate this each time the report is run.____Any help on this would be greatly appreciated as i^m tearing my hair out!!____Thank-you in advance__Martin Young

Should be easy enough but u may need to give a sample of the sort of data you have and what output u expect as its tricky to tell exactly what u want to end up with.____Counting records is done using the calculated total fields. YOu can pre-process some totals if you want to show the count at the start of a group rather than at the bottom.____Also there is a built in function called recno() which gives you the current record no.____Hope this helps

Thanks for your help.____I have tried to be a bit more specific, if any more info is needed let me know.____I use report writer to access an oracle database via an ODBC link. the data that i am extracting is occupational health information.____I use the table clinical encounters in my database which contains several fields. The field that i base my report on is S_Episode_Type this contains a description of any assessments that an individual has. There are about 20,000 fields within the database. Many are duplicated several times in a random order as we are a company of about 5000 people and most have been to the health dept at some point.____An example of the data is as follows____Audioty assessment__Audioty assessment__Audioty assessment__C02 Welders Assessment__Audioty assessment__Boiler house assessment__Boiler house assessment__Boiler house assessment__C02 Welders Assessment__Audioty assessment__Audioty assessment__Audioty assessment__C02 Welders Assessment__C02 Welders Assessment__Audioty assessment__Boiler house assessment__Boiler house assessment__C02 Welders Assessment__Boiler house assessment__Boiler house assessment____What i need to do is to print the instance of the text once and have a total of all occurances of that instance next to it.____Hope this helps?____Thanks for your continued help and support

Sorry i was not logged in might have confused things a bit there!

If you can sort/group on this field then counting the number of unique instances is easy. You would create a grand total that counts this field and accumulates once per group.____But if you cannot sort/group on this field, then the task is not quite possible to do in a single report.____Kathleen__R&R Support

Thank-you __I can sort and group this field. i know it^s basic stuff but can you tell me how to create and apply the total as i^m really stuck!!

Group on the field that contains the data.____Create a total that counts the records and resets when the field changes(end of the group)____Place the total in the group footer,__Place the field beside it____Run the report, verify that all is counted correctly.____go back and suppress Records____You will then get only the group footers with the data you want. May have to remove the group header or you will have a line between each group.____Rick Johnson