CODEWITHSUNDEEP
crystal-reportscrosstab
veljasije
veljasije

Reputation: 7092

Add columns to Cross-Tab element

Report needs to have a table (like a matrix in SSRS) with dynamically created columns and rows based on data from dataset. With no additional requirements, the crosstab works perfectly. But I need to add static columns outside of any group (horizontal or vertical) which will be shown in any case. I tried to do this with Cross-Tab element in Crystal Reports but without success.

Is it even possible to do such a task using aforementioned element? Is it possible to add new columns to expand cross-tab element?

Currently, on y-axis I show months, on x-axis I show customers, but I need two additional columns, like customer code, or something else.

enter image description here

In the picture above is presented desired output. Little explanation: Value from dataset 1 ... n are generated in runtime, based on data from dataset, while Date of birth column is always present.

What I got already is table with dynamically generated Value from dataset 1 ... n but I cannot add new column Date of birth in Cross-Tab element.

I think it is clear enough now.

Upvotes: 1

Views: 4827

Answers (1)

Siva
Siva

Reputation: 9101

Actually you can do it but you will get the extra column at the end not at the beginning as stated in your question.

Go to preview and then go to the last column of cross tab

Right click --> calculated member --> insert column

After that you can get new column and add the changes you require

Upvotes: 1

Related Questions