Cross Tab

Masters

Good, I mention my problem ...

... I need to eat a field of a parent table from a CROSS TAB but I do try to return a null value

as I can do it?

Find more posts tagged with

Comments

mwilliams

I'm not sure I'm understanding. Do you think you could explain a little more?

Netzio

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="76830" data-time="1305053040" data-date="10 May 2011 - 11:44 AM">
I'm not sure I'm understanding. Do you think you could explain a little more? </blockquote>
 
 
Thanks for responding ... 
 
... Really, idk if you saw the report to attach, but I have a series of Cross Tab within a parent table associated with a specified DataSet and consume these Cross Tab each DataSet and receive their value in the Open method that comes from the main table, I do it all for grouping and paging. 
 
this is how I pass the field in the table Tab Cross Father to children ... 
 
 
declare a global variable in the Fetch method 
 
row ["value"] = maximoDataSet.getString ("value"); 
 
reportContext.setGlobalVariable ("provider", (row ["value "])); 
 
 
and the Query Method in Cross Tab Open in global variable that I pass 
 
sqltext = 
"SELECT (MONTH (SCHEDFINISH)) Mo," 
+ "TOTAL_1_MP_MPD = 0" 
+ "TOTAL_2_MP_MPD = 0" 
+ "TOTAL_3_MP_MPD = 0" 
+ "TOTAL_4_MP_MPD = 0" 
+ "TOTAL_5_MP_MPD = 0" 
+ "TOTAL_6_MP_MPD = COUNT (*)" 
+ "FROM WorkOrder" 
+ "WHERE STATUS IN ('COMP', 'CLOSE')" 
+ "AND ISTASK = 0" 
+ "AND WORKTYPE IN ('MP', 'MPD')" 
+ "AND BCP_PROVE = '" + provider + "'" <- HERE 
+ "AND (DATEDIFF (HOUR, SCHEDFINISH, ACTFINISH)> = 72)" 
+ "AND MONTH (SCHEDFINISH) IS NOT NULL" 
+ "GROUP BY MONTH (SCHEDFINISH)" 
 
 
maximoDataSet.setQuery (sqltext) 
 
hope I've explained better, and apologize for my English but I'm from Chile and I'm using Google Translate. 
 
 
Already mcuh thanks 
Netzio

mwilliams

Your issue is not with the dataSet though, right? It's with the values you get in your crosstabs? They're not filtering down how you want? If this is the issue, you'll need to place a filter on your crosstab. When you do this, the expression will have access to the outer table's group value. As long as the you have the field your outer table is grouped on in your crosstab as well or as an attribute to a dimension in your crosstab, it should be easy to do. If this is not the issue you're having or this comes out confusing through Google Translate, let me know.

Netzio

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="76903" data-time="1305153017" data-date="11 May 2011 - 03:30 PM">
Your issue is not with the dataSet though, right? It's with the values you get in your crosstabs? They're not filtering down how you want? If this is the issue, you'll need to place a filter on your crosstab. When you do this, the expression will have access to the outer table's group value. As long as the you have the field your outer table is grouped on in your crosstab as well or as an attribute to a dimension in your crosstab, it should be easy to do. If this is not the issue you're having or this comes out confusing through Google Translate, let me know. </blockquote>
 
 
Just, try to do what they tell me, anyway agradecria much an example or an image ... 
 
Idk if allowed, if I could give you my email for sending files 
 
 
Thank you very much

mwilliams

This devShare post tells what you have to do to limit a crosstab by the data in the outer grouped table:

http://www.birt-exchange.org/org/devshare/designing-birt-reports/1321-limiting-an-embedded-crosstab-to-a-value-from-the-outer-table/

I can build a quick example if you need me to. Just let me know. I'll just post the example in here if you need it.