Information générale
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
New report design for TIP
Versions des environnements
Network:
Windows 2008 Server
I have 2 related tables projects and funding that work together in a 1 to many relationship. The funding records contain fields for amount, source, and year. I want to create a report where each project and its funding is displayed together. The project data would be displayed in the first column or block, followed by a column for each year. Something like this:
------------------------------------------------------------------------------------------------------
project1 name|year1amount1|year2amount1|year3amount1
desc |year1amount2|year2amount2|year3amount2
etc |year1amount3|year2amount3|year3amount3
------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------
project2 name|year1amount1|year2amount1|year3amount1
desc |year1amount2|year2amount2|year3amount2
etc |year1amount3|year2amount3|year3amount3
------------------------------------------------------------------------------------------------------
How would you suggest I construct the cursor(s) and report to accomplish this?
Thanks
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement