Scripting a report

[AnnaC]

Hi,

I am trying to develop my first report but am starting to tear my hair out! I need to script a report to give me calculated results in a report layout. I need the script to generate results such as average age (i have an age in years field), number of males. females and transgender clients (this is info is recorded via radio buttons in a gender field), and i also need to be able to script it to look for what choices have been made from several pop-up menus. For example, in my 'area' field i would like to script it to produce how many records show a certain area from this pop-up list. Is this possible?

I hope i haven't confused everyone with these questions and would appreciate any pointers!

Thanks,

Anna

[IdealData]

Don't think scripting is your problem here.

To generate the values you suggest you need to have some calculation fields - check out the "Summary" fields for averages, totals etc... Then put the new calculation fields on your report layout

Whilst a script could generate the values it's unnecessary and highly error prone.

[AnnaC]

Thankyou, i will give this a go. The only query i have is how i actually ask the database to look for how many people have selected a certain option from a value list (i.e. a pop-up menu). Can this be done as a calculation or do i need a script for this? I'm sorry this probably sounds simple to everyone else but i am still learning!

Thanks,

Anna