Can Crystal do pivoting? PLEASE HELP!!

[sommererdbeere]

Hi,

is it possible for crystal to do pivoting? I want to create a report that will rememeber the data from previous month (this is a monthly trend report).

crystal 8.5

month
1/04 2/04 3/04
sum_cost sum_cost sum_cost
3000 40000 50000
3300 40100 50050
3500 40000 56500


above is just an example. is there anyway tohave the report remember each month i generate the report; meaning that let say i run the report at the end of this month, april. when the report runs, it will show the month from 1-3/04 that i generate before and 4/04 that i just run.

Please please help me if anyone knows it. i've been searching for a long time and i believe this is a difficult question to ask.

thank u thank u for those who help..

m

 

[synapsevampire]

Crystal isn't a programming language nor a database, so it won't remember data.

Further complicating this issue is that you may query the database in April for the month of January, and get different results than you did in February due to the data changing. So what would you want in the report, what was originally shown, or what the current database houses?

Rather than trying to use text to desribe a technical issue, try creating some simple documentation, it should also help you understand the scope of the requirements:

Crystal version
Database/connectivity used
Example data
Expected output

And don't describe what they look like, post examples

You have a business rule to discover, and then if you are just displaying what's currently in the database for all full months to date for the year, set the record selection formula to something like:

{table.date) in cdate(year(currentdate),month(currentdate),day(currentdate)) to maximum(lastfullmonth)

Now select Insert->Cross-tab-> and place it in the report footer.

Place the date field in the Columns and select Group Options

Select A Column Will Be Printed For Each Month

Place your field to sum in the Summarized Fields area and select Change Summary->Sum

If you need the original numbers from previous months, you should be doing that in another process, or exporting your reports monthly in a data format (Access, ODBC, comma delimitede, etc) for use as future data sources.

-k