Binding gone when I hide Group levels on Cross Tab

I'm having a issue with disappearing binding on the Cross Tab. 
 
I have a group that has two levels, the first level is a numeric representation and the second the text representation. 
 
I want to be able to sort on the numeric value. And add it to the sort properties 
So far so good. 
I don't actually want to see the numeric value and I used the 'Show/Hide group level' to hide the numeric value. 
But the moment I hide the Numeric Group level the report breaks. It breaks because the binding for the data disappears together with the hidden grouping level 
 
Is it possible to hide a grouping level but still use the data? 
 
This same question has been asked on the 
<a class='bbc_url' href='http://www.eclipse.org/forums/index.php?t=msg&goto=488396&S=a0b0446dcd4ffa6a3e1f49446378a780'>Eclipse Community Forums</a> 
 
The exception thrown is a; org.mozilla.javascript.EvaluatorException 
and the message is 
The outer query results does not exist. This might be caused by a "_outer" reference in a query without parent query.

Find more posts tagged with

Comments

mwilliams

Hi meindert,

You may have to just use the visibility feature to hide this dimension and do it that way. The crosstab is only bound to dimensions used in it, so if you hide the dimension, it removes the binding as you've seen.

meindert

Hi mwilliams

thanks for the quick response. I will do that.

Where is the 'visibility feature to hide this dimension'?

At the moment I delete the Dataset column out of the cell to hide the value, but I want to hide the cell lines to.
To do this I changed the cell width to 0 and the padding to 0, next I had to edit the crosstab-cell style and created the styles for the different type of cells (visible horizontal, visible vertical, hidden horizontal and hidden vertical)

This works, was just wondering if there is a easier way.

mwilliams

meindert, 
 
That's probably going to be the best way. Unfortunately, the cell remains if the dimension binding remains. This could be something that would be a good enhancement to crosstab designing if you'd like to request it at <a class='bbc_url' href='http://www.eclipse.org/birt/phoenix/reportabug.php'>BIRT: Reporting Bugs and Requesting Enhancements</a>.

keith_c06

I've been reading through the forums and newsgroups for a solution to my issue and cannot seem to find a working one.
Here is the issue:
I am using a cross tab that gets its data from a scripted data source. The data is to be grouped & sorted by a value determined by the business rules, this value will not be one that can be simply sorted alphabetically or numerically (i.e. days of the week, name of the month). I have added a row to the data set for the sort order (call it 'orderId'). It is simple enough to group and sort by this order id, but I do not want to display the order id as it has no meaning to the business, I want to display the value that is useful to the business.

I have not been able to add any extra data or get the cross tab to sort by any data that is not explicitly in the cross tab, even if it is in the data cube. I am using Birt 2.3.2.
Any help would be appreciated.

Thanks,

Keith