Customize Format and Style of Fields inside a crosstab

Hi all,

i have a data cube with the following dimensions

Source : Project -> Location (2 levels)
Results: Type -> Sub-Type (2 levels)

I have a crosstab with Source applied to the rows and Results applied to the columns. This leads to something like

column[0] : Bugs Duration
sub-column : Severe Medium Compile Run Elaborate

I have a flexible number of sub types per type, depending on the users data.

I want to apply specific formatting rules on each crosstab cell depending on the 'Type' value of the associated column.

Thanks,

Frank
I can't find a solution, can anybody help me?

Find more posts tagged with

Comments

mwilliams

Hi Frank,

Can you attach a screenshot of what the crosstab looks like? What kind of formatting are you wanting to do?

FrankA

Hi Michael,

thanks for picking up the topic. I attach a picture with the current crosstab layout and rendered view.

I also attach a formatting example, i basically want to control highlighting and number format. In some cases i want to present an icon in case a cell has no value.

Any ideas?

Thanks,

Frank

mwilliams

Frank,

Is there any way you can make that image larger? It is hard to read at its current size. Thanks.

FrankA

Hi Michael,

i did now make it a pdf, the jpg is about 900x600 pixel on my host ... not sure why it did scale down.

The pdf should be 1 A4 page wide.

Bye,

Frank

FrankA

... now zipped ...

mwilliams

Frank,

Thanks. Is there any way you can attach a .csv file of sample data that I can make a report with that looks like yours? This way I can do some testing with it.

FrankA

Hi Michael,

hmm ... i have SQL DB data source that i access via DataSets that are defined in a rptlibrary. Not sure i can ship the whole DB ... is there a simple way to 'translate' relevant SQL Table content (manually) to a data set in a xls?

What format would the xls need?

Frank

mwilliams

Frank,

I definitely wouldn't need the entire dataSet. Just a small sample of data how it looks in your dataSet to be able to create and run a report. Just in .csv form if possible.

FrankA

Hi Michael,

i managed to cut down the report and create a fake csv file. The report runs for me and creates the top column values 'Closure' and 'Open Bugs', each with two sub-groups.

I want to have conditional formatting according the top column values. The report includes some scripting which i tried to do, does not work but does not break anything either.

Thanks,

Frank

mwilliams

Frank,

Thanks. One more question. What version of BIRT are you using? Should have asked earlier, but I forgot.

FrankA

Michael,

i use version 2.3.2 ...

Bye,

Frank

mwilliams

Frank,

Ok, what are you trying to do to each column?

TopDimension: Closure
SubDimensions: MyTop & Top

TopDimension: OpenBugs
SubDimensions: DUT & TB

FrankA

Hi Michael,

i want to format and conditionally highlight the table cells depending on the top column name.

For example:

- all cells that belong to "TopDimension: Closure" should be devided by 100 and the result should be shown as %
- all cells that belong to "TopDimension: Closure" that end up to be <80% should be highlighted with red background

Such rules would exist for any possible TopDimension and the condition could be specified as a match to the TopDimension name, e.g. a string match pattern.

The pdf that i did send include more examples ...

Thanks,

Frank

FrankA

Hi Michael,

i found a workaround (attached), it works but is a kind of ugly.

If you have better ways to figure out column names from within a cell, let me know.

P.S.: I had to restructure the scripts and work with persistent variables in order to run it on a server.

Thanks,

Frank