2004 IR Help Posted August 22, 2006 Share Posted August 22, 2006 By: lgarnier - lgarnier Columns and page break problem 2005-06-13 01:35 Hello first, excuse me for my poor english, but I'm french... My problem is that my report takes four pages with one line per page. Report SQL Query : select distinct o2.objLibelle as libmet, o1.ObjLibelle as libprg, m.MesValeur as valeur from OBJET o1, OBJET o2, MESURE m WHERE o1.ObjID = o2.ObjIDParent AND o1.IntID = o2.IntIDParent AND o1.TobjID = o2.TobjIDParent AND o1.TobjID = 1 AND m.ObjID = o2.ObjID AND o2.TobjID = 2 Result of SQL statement : line 1 : nombre d'instructions de branchement autre qu Prg RVSAC31S 17 line 2 : nombre de lignes en commentaire Prg RVSAC31S 255 line 3 : Complexité¤es structures Prg RVSAC31S 3.29167 line 4 : Nombre cyclomatique Prg RVSAC31S 199 line 5 : nombre d'instructions de branchement autre qu Prg RVSCN21W 7 line 6 : nombre de lignes en commentaire Prg RVSCN21W 83 line 7 : Complexité¤es structures Prg RVSCN21W 1.85714 line 8 : Nombre cyclomatique Prg RVSCN21W 21 line 9 : nombre d'instructions de branchement autre qu Prg RVSSU21V 33 line 10 : nombre de lignes en commentaire Prg RVSSU21V 155 line 11 : Complexité¤es structures Prg RVSSU21V 4.36842 line 12 : Nombre cyclomatique Prg RVSSU21V 106 So, I want a "grid" with 4 columns and 3 lines : col 1 : nombre d'instructions de branchement autre qu col 2 : nombre de lignes en commentaire col 3 : Complexité¤es structures col 4 : Nombre cyclomatique line 1 header : Prg RVSAC31S line 2 header : Prg RVSCN21W line 3 header : Prg RVSSU21V | lib met -----------|--------------- lib prg | valeur There is a problem with colums and "group by", and I have four pages (equals to my four columns). Thanks By: lgarnier - lgarnier RE: Columns and page break problem 2005-06-13 02:53 I have added " GROUP BY libmet,libprg,valeur" to my query, and now, all lines are one the same page ! The problem is that libprg are repeated (Print repeated values for $F{libprg} to false). Any idea ? Thanks Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now