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
