[2.2.2] How to use crosstabs in librarires ?

Erwan

Hi,

First of all, i would like to apologize for my poor english.

I have a project with a lot of reports, datasets and items. I use librarires to store generic datasets and items. It works very well.

Nevertheless, I don't manage to use properly crosstab via librairies.

Here is my problem :

--> creation steps :

#1 - I create a dataset in a library. This dataset has two parameters : "Year" and "CustomerCategory". The parameter "Year" is binded to a report parameter and the parameter "CustomerCategory" has as default value 4. According to reports the value of the parameter "CustomerCategory" could change.

#2 - I create a datacube based on the previous dataset. I create two groups and one measure. I don't need to use a filtrer because the dataset returns only the datas i want.

#3 - I create a crosstab based on the previous datacube.

--> use in report steps :

#1 - drag & drop the crosstab from the library to the report. I can't set here the value of my dataset parameter "CustomerCategory". What a pity !

#2 - drag & drop the datacube from the library to the report. We are compelled to do this or else the crosstab displays erroneous data.
here, we can not define the parameter value "CustomerCategory"

#3 As we can set the value of the parameter nowhere, we are compelled to drag&drop the dataset from the library to the report and change the default value of the parameter.

When we run the report vie the "preview" tab it works but when we run the report via another way (webapp BIRT) we have an error message :

"GRAVE: Failed to save design!"

How should i use crosstab from librairies with such a dataset ?

Tianli

I think your steps are correct. The simple way is only drag and drop your crosstab in report's layout and drag the parameter from library to report. No need to drag the datasets and cube from library. I'm using BIRT2.3.0 and didn't find your issue the preview result is as expected. Please see attached report and library.