Simulated Cross-Tabs, urgent!!!!

mercoledì 19 dicembre 2007 - 12.27

Elenco Threads

Stanze Forum

Aggiungi ai Preferiti

Cerca nel forum

4ndre4 Profilo | Newbie

8 messaggi | Data Invio: mer 19 dic 2007 - 12:27

Hi,
I urgently need to know how building a cross-tab (in Crystal Reports for Eclipse) where, in the columns I have the "months" and in the rows I have a series of attributes taken from a table.

In other words in columns I have attribute Month that determines a number of columns equal to its values, and in rows I do not have a single attribute that determines the number of rows with its values, but as many rows as atrributes.
For example:

VOCI-----------GENUARY------------FEBRARY---------------MARCH
---------------------------------------------------------------------------------------------------------------------------------
Salary---------137.391,828----------137.400---------------138.345

Expenditure----300,876----------------1000------------------4300

Purchases------2134,9----------------43828-----------------63209

How can I use a cross-table or alternatively how can solve the problem?
Thanks.

freeteo Profilo | Guru

6.542 messaggi | Data Invio: mer 19 dic 2007 - 22:14

hi,
if u got the values thet are dynamic in the both sides,but still reside in the the same column of your table, the cross-tab is the right object to use.
In the column drag the "date" column, and choose the option button : "group by->month".

But if u got something different like the columns in the datatable that the query return are "dynamic", u cant make something with Crystal.
This happens because Crystal need to know the right "schema" of the datasource that process across the pages, you are not able to manage the datasource schema, the report engine doesnt' work in this way

ps: but why do u speak english? your email contact for the forum is ".it"...

ciao.

Matteo Raumer
[MCAD .net]
http://blogs.dotnethell.it/freeteo

Torna su

Stanze Forum

Elenco Threads

Partecipa anche tu! Registrati!

Hai bisogno di aiuto ?
Perchè non ti registri subito?

Dopo esserti registrato potrai chiedere
aiuto sul nostro Forum oppure aiutare gli altri

Consulta le Stanze disponibili.

Registrati ora !