Radicore Forum: Transaction Patterns

Home » RADICORE development » Transaction Patterns » PDF Report

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

PDF Report [message #1241]

Fri, 25 January 2008 10:07

lyndonj
Messages: 5
Registered: January 2008

Junior Member

Hi, I need to report events by year and month with totals of attendees etc for each month and year. What are the options for doing this?

Thanks

Lyndon

Report message to a moderator

Re: PDF Report [message #1242 is a reply to message #1241]

Fri, 25 January 2008 13:25

AJM
Messages: 2246
Registered: April 2006
Location: Surrey, UK

Senior Member

If you want one record per page then use Output 3 - PDF (detail view).

I you want multiple records per page then use Output 2 - PDF (list view). This is a simple "read a record then print a line" process. There is the option to include a line of accumulated totals at the bottom of the page, as shown in http://www.tonymarston.net/php-mysql/output-to-pdf.html#exam ple.list.view.totals.

If you want subtotals in the body of the report there is no standard option for that. It sounds like you might have to create a temporary table with the subtotals in it, then process the contents of that temporary table.

If this is unsatisfactory then you will have to send me your database schema with some test data, and a sample of what you want the data to look like so that I can play around with the code.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: PDF Report [message #1243 is a reply to message #1241]

Fri, 25 January 2008 19:10

lyndonj
Messages: 5
Registered: January 2008

Junior Member

Yes its a detail list with group header and totals for month and year I was after.

2008
Jan
Event 1: 20
Event 2: 25
Event 3: 50
Totals Jan: 95

Feb
Event 4: 30
Event 5: 55
Event 6: 45
Totals Feb: 130
etc
Total 2008: 225

2007
.
.
.
Total 2007:
etc
(with more totals and calculated fields (e.g. income by event, month, year). Although the application has many tables the report data is in a single table: date, event, number of attendees etc.
Using a temp table as you suggest would allow me to put the monthly subtotals in a separate report for each year (with yr total) which might be acceptable to the users. Otherwise I could maybe use a separate reporting application
Thanks
Lyndon

Report message to a moderator

Re: PDF Report [message #1244 is a reply to message #1243]

Sat, 26 January 2008 05:08

AJM
Messages: 2246
Registered: April 2006
Location: Surrey, UK

Senior Member

The way that the PDF list report works currently is a simple "read a row, print a row", but to handle situations like this it sounds like you want the ability to have a "pre_print" and "post_print" function with which you can supply any number of other rows for printing. I will work on this and see if I can include it in the next release.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: PDF Report [message #1245 is a reply to message #1244]

Sat, 26 January 2008 08:59

lyndonj
Messages: 5
Registered: January 2008

Junior Member

Thanks. That sounds like an excellent solution.
Lyndon

Report message to a moderator

Re: PDF Report [message #1953 is a reply to message #1245]

Fri, 20 February 2009 11:40

AJM
Messages: 2246
Registered: April 2006
Location: Surrey, UK

Senior Member

The ability to print subtotals (or any other data for that matter) either before or after the current row has been added to the PDF library - please refer to List View with Line Breaks.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Previous Topic:	List2 with multiple parent relations to the same table
Next Topic:	Search and List ideas

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Jun 12 07:30:41 EDT 2021

Total time taken to generate the page: 0.02185 seconds