tabulation between records

Discussions about tabulating data in the designer or in batch mode
atr
Posts: 21
Joined: August 25th, 2014, 7:03 pm

tabulation between records

Postby atr » August 28th, 2017, 12:17 am

Dear Users,

I have a variable in a Person record that captures each persons income. I want to tabulate household income by summing all these individual income for each household and show the average household income by region.

Grateful for any assistance.

Gregory Martin
Posts: 1070
Joined: December 5th, 2011, 11:27 pm
Location: Washington, DC

Re: tabulation between records

Postby Gregory Martin » August 28th, 2017, 7:04 am

You can do this by creating a new variable in your working storage dictionary and then using table logic to fill that variable in with the sum of the individual incomes. See more here:

http://www.csprousers.org/help/CSPro/ta ... logic.html

atr
Posts: 21
Joined: August 25th, 2014, 7:03 pm

Re: tabulation between records

Postby atr » August 28th, 2017, 6:43 pm

Thanks Greg.... much appreciated.

arkagwa
Posts: 92
Joined: November 18th, 2014, 5:25 am

Re: tabulation between records

Postby arkagwa » May 1st, 2018, 11:41 am

Dear Josh

With the current version 7.1 can can i write a tablogic to create a summary/statistical tables and the export to excel or word for reporting?
Can i create a dashboard to view all project indicators' statistics?This should be done via clicking menu and button to create the summary report.

josh
Posts: 1653
Joined: May 5th, 2014, 12:49 pm
Location: Washington DC

Re: tabulation between records

Postby josh » May 1st, 2018, 11:54 am

You can export tables as RTF which can be imported into Word, tab delimited which can be imported into Excel or as HTML which can be used directly for reporting. You could have a dashboard menu program that uses execpff to launch the tabulation program.

You can also use the new HTML reporting features in CSPro 7.1 to write HTML reports directly from CSPro logic in a data entry or batch application. See "templated reports" in the help for details.

arkagwa
Posts: 92
Joined: November 18th, 2014, 5:25 am

Re: tabulation between records

Postby arkagwa » May 1st, 2018, 12:35 pm

Dear Josh

Thanks very much for your support, Can i get one sample or example of dashboard menu program that uses execpff to launch the tabulation program?? :)

josh
Posts: 1653
Joined: May 5th, 2014, 12:49 pm
Location: Washington DC

Re: tabulation between records

Postby josh » May 1st, 2018, 1:47 pm

I don't have any examples of launching tabulation. Maybe someone else on the forum can post one?


Return to “Tabulation”