I'm a little stumped on how best to approach a particular problem. I have a report I'm building that will span an uncertain number of columns and uncertain number of rows. Below is a sample of what the report might look like:
Account Descr Jan Feb Jun Aug Nov Total 51112 Fred $5 $10 $0 $15 $0 $30 51119 Lucy $0 $0 $7 $0 $0 $7 51121 Ethel $0 $20 $0 $0 $3 $23 51178 Ricky $1 $6 $3 $2 $4 $16
The data I pull from the database comes into a result set that looks like this:
Account Month Amount 51112 1 5 51112 2 10 51112 7 15 51119 6 7 51121 2 20 51121 11 3 ..
Look at the following thread http://www.perlmonks.org/index.pl?node_id=324008
I have a complete, working code snippet there for normalizing a denormalized recordset. You can use that as the base to build your own data transformation routine.
------------------------------------------------------- The SF.Net email is sponsored by EclipseCon 2004 Premiere Conference on Open Tools Development and Integration See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. http://www.eclipsecon.org/osdn _______________________________________________ Html-template-users mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/html-template-users
