Information générale
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Network:
Windows 2003 Server
J'aime (1)
Naomi Nosonovsky
>>I have a table that stores data for years.
>>
>>I know how to query the data to get totals, averages, etc for individual years. I even understand how to query for specific months in each years.
>>
>>I am wondering what is the best way to compare data year to year? ie look for trends.
>>
>>I mean like 1999, 2000, give the totals, averages etc, so I can see the net change from year to year. (I know how to convert it to a percent.)
>>
>>What I need is some helpful ideas.
>>
>>TIA,
>>Mike
>
>
>Perhaps you're looking for Crosstab report here. It is better to use SQL Server and SSRS, but you can do this in VFP too.
>
>Look at FastXTab in Downloads section here.
Also Excel. It seems like most users like Excel format best and cross tabs are right up its wheelhouse.
Précédent
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