I have a column that has a corrosponding row in an other column which is null sometimes and sometimes it has certain value, when its null it doesnt appear in the report , it only appears when it has a value
what can i do to make it appear even if it doesnt have a value…
e.g
the other unmatching row is not a table column its a object in the universe (measure) which is set for prompts also i tried using new data provider it gives the same value for every row
In BusinessObjects Report, just create a new table composed by 2 columns: in the first column you write static strings such as “ALPHA”, “BETA”, “GAMMA”. In the first column you insert a MEASURE created in BusinessObjects Designer in order to COUNT (this means, “measure type of aggregation: COUNT”) the occurrences of ALPHA, …
Of course, you need K measure objects:
Measure object to count ALPHA occurrences;
Measure object to count DELTA occurrences;
Measure object to count GAMMA occurrences;
…
K) Measure object to count … occurrences.
This problem is solved only if the list ALPHA, DELTA, GAMMA is well known and STATIC.
If we are speaking about a DYNAMIC list, let us know!