Group With Cross Tab

i want data to be displayed in order :

group1
group2
Cross tab report

now cross tab data should be dependent upon group1 and group2. if i am using cross tab i am getting data in this format :
group1 group2 data(depending upon group1 and group2) but i don't want in this format as it consumes column space ..
i want in below mentioned format
group1
group2
Cross tab report.

How can i do that. Kindly help me.

Thanks
Rajesh Kumar

Find more posts tagged with

Comments

mwilliams

If I understand you correctly, if you embedded your crosstab into a grouped table or list, you could do this.

Rajesh kmr

Thanks for you reply.

But if i am using cross tab inside table then i cant map the group value of table to the cross tab data.

as there is not "data set parameter binding" for cross tab databinding.
in this case the cross tab data will not be displayed according to outer table.

Please reply..is there any option so that we can map..or any other solution.

Thanks
Rajesh Kumar

Rajesh kmr

Hi willaiams, 
 
I tried using the cross tab inside grouped table, but in this case am getting the records repeating for each group of the table. Its not correct.. 
 
The actual requirement is that we need to display the records in a grouped manner (which can be done using crosstab), but we need to change the layout of the group header ie., we have to display the group names on the top of the each group as a header.. 
 
Also we tried using the reportContext.setGlobalVarable in the onCreate script of the xtab(setting the global variable to the groupname) and fetching the global variable outside the cross tab as reportContext.getGlobalVarable, but still this is incorrect, as it displays the groupname only once... 
 
Is there any way to get this crosstab, where we can change the format of the group headers( like position,style etc.,) 
 
Thanks in Advance..

Yogesh Maharwade

Hi
If you want cross tab depending on your groups. for that you have to put filter on your crosstab.

Regards

Rajesh kmr

Thanks for your reply

But i am using multiselect parameter for grouping,
now when i am selecting multiple parameter then only the first one is coming in group and cross tab is displaying only for that group.

so what to do so that the table group should take the group name which i will select from parameter.

Thanks

Rajesh kumar

Rajesh kmr

as i think my data set is not getting populated according to multiselect parameter.
as if i am printing one field of my dataset it is not printing all value according to all selected parameter(cascade).

its giving result according to first parameter among selected parameters.

mwilliams

Can you create a sample report that shows your issue, using the sample database?

Rajesh kmr

Thanks for your reply

now the grouping problem is solved ..but now in which band of table should i place my crosstab ..so that that band is auto expandable with crosstab data.

problem is that i tried in all the band but its not expanding,if i am making bandwidth of a table band is too large then ..in case of less data in crosstab its leaving a marginal space..

if table band is fitted to crosstab size then some data is getting missed.

Thanks

Rajesh kumar

Rajesh kmr

Thanks for your reply
I have attached the sample report.

mwilliams

Sorry for the delay. I was at EclipseCon, last week and was not in here much. I'm taking a look, now.

mwilliams

Is this better? I removed the padding from the table cells. You can also go to the style section of the outline and remove the crosstab styles. This will take away the borders and it won't look so bad.