Hello , I create a crosstab but i have a problem ,,,i want when a field value 'Y' so backcolour Red and then 'N' so its display Green, how can i solve my problem,,, Thanks to all in advance,,,
hey,, You can use DISTINCT in ur query but it apply all in ur query,,,,,and in report field properties (show in image ) You check print repeated values but when u apply this its blank a full row ,, i think its solve your problem
hey, like first group you add a new report group ,, and drop field in this group header,,you add lots of group in ireport,, its working,, and any time availble for answer,,
Hey , You can use a Report group and set a name of group and set group by master field that u want to print .and then put master field in group header (that you want to print on a new page).Set properties start in a new page,,, i think it solve your problem,,,,
hey,,, Firstly drop crosstab element in summary band,, And then select row group ,,first one location field and second customer field that fetch from database,,, and then coloum group ,,put date field and at last select measure your amount field and thats expression sum and then add a row group that field name "measures" and set class of the field string and total position none and bucket expression fetch from query,, its looking like this and after this some padding ,,,,and finally report looking like this image ,,,Create Carefully its working that u like the format of report,,and delete another band without title,,,,because if u want something write in ur report so use title,,
hey ,, I Understand but not surely know your problem so put here ScreenShot,,,,,,,,,,,,, And in ur second question u check ,,Initial Value Expression in variable ......i thing u put salary field in both ,,,,,,Only put field in variable expression not in initial value expression,,,,,,,,,
Hey,,,,,,,, Set Postion Type-- Float And Stretch Type --Relative to Tallest Object In all field ,,,,,,,, and tick Stretch With Overflow ....in every field,,,,, thats working properly,,,,,,,