Dear support team,

how can I group the repeated cell items in a table (see TABLE1) as a result like in TABLE 2 (hide the repeated cell contents): (I know this is possible in PIVOT package, but I don't want to use this as I can't remove the subtotals)

Kind regards,

Thx for your hint! I put the removeDuplicate property into my code as follows but however it does not work:

						Table::create(array(
						  "dataStore"=>$this->dataStore('Reporting.autorep_v_0_Bestaende_Table'),
						  "showFooter"=>"bottom",
						  "columns"=>array(
							"WerbegruppeVerbund"=>array(
								"label"=>"Werbegruppe",
								//"formatValue"=>function($value)
								//{
								//	return ""; //Leere Spalte in der Tabelle
								//},
								//"footerText"=>"<span style='font-size:150%;'><b>".$Werbegruppe_Verbund."</b></span>",									
							),
							"NikonKdName"=>array(
								"label"=>"Kundenname",
							),
							"NikonOrt"=>array(
								"label"=>"Kundenort",
							),
							"NikonArtBez"=>array(
								"label"=>"Artikel",
							),	
							"BestandHaendler_aktuell"=>array(
								"label"=>"Bestand Händler",
								//"footer"=>"sum",
								//"footerText"=>"<span style='font-size:150%;'><b>@value</b></span>",									
								"cssStyle"=>"text-align:right;font-weight:bold;font-size:100%;",
							),
							"BestandZentrale_aktuell"=>array(
								"label"=>"Bestand Zentrale",
								//"footer"=>"sum",
								//"footerText"=>"<span style='font-size:150%;'><b>@value</b></span>",																		
								"cssStyle"=>"text-align:right;font-weight:bold;font-size:100%;",
							),
						  "removeDuplicate"=>array("WerbegruppeVerbund"),	
						)));

Here is still the output with 2 x "Einzelhaus", 3 x "Expert Bening", 2 x "Expert Heinze & Bolek" (in the column Werbegruppe):

Any idea how to fix this?

I put it now it directly after the "colums" but the result is excat the same like above:

							Table::create(array(
							  "dataStore"=>$this->dataStore('Reporting.autorep_v_0_Bestaende_Table'),
							  "showFooter"=>"bottom",
							  "columns"=>array(
								"WerbegruppeVerbund"=>array(
									"label"=>"Werbegruppe",
									//"formatValue"=>function($value)
									//{
									//	return ""; //Leere Spalte in der Tabelle
									//},
									//"footerText"=>"<span style='font-size:150%;'><b>".$Werbegruppe_Verbund."</b></span>",									
								),
								"NikonKdName"=>array(
									"label"=>"Kundenname",
								),
								"NikonOrt"=>array(
									"label"=>"Kundenort",
								),
								"NikonArtBez"=>array(
									"label"=>"Artikel",
								),	
								"BestandHaendler_aktuell"=>array(
									"label"=>"Bestand Händler",
									//"footer"=>"sum",
									//"footerText"=>"<span style='font-size:150%;'><b>@value</b></span>",									
									"cssStyle"=>"text-align:right;font-weight:bold;font-size:100%;",
								),
								"BestandZentrale_aktuell"=>array(
									"label"=>"Bestand Zentrale",
									//"footer"=>"sum",
									//"footerText"=>"<span style='font-size:150%;'><b>@value</b></span>",																		
									"cssStyle"=>"text-align:right;font-weight:bold;font-size:100%;",
								),
							  	
							),
							"removeDuplicate"=>array("WerbegruppeVerbund"),
							));

An additional info for you:

I've just updated my KoolReport version to 3.0.0. and the result is unfortunately the same!

Kind regards,

Hmmm... What could be wrong in my code above?

Do you need any further information?

It works fine now! There was a missing "//" for a comment line!